Blog content (HTML) datatype in database - Githubissues

Ma-Kas / kansaibeyond

Monorepo for a blog and travel website, consisting of frontend, backend, and headless cms.

https://www.kansaibeyond.com

0 stars 0 forks source link

Blog content (HTML) datatype in database #28

Closed Ma-Kas closed 5 months ago

Ma-Kas commented 7 months ago

What is better to store in the database, html string or JSON of editor state?

JSON: PROS:

Native format of lexical editor
No conversion on cms CONS:
Retrieval from database to website needs conversion to html string. SLOW!
Conversion to html string on frontend needs lexical editor instance exposure

HTML String: PROS:

Easy retrieval and direct implementation on the frontend, cms preview or wherever direct rendering is necessary without conversion CONS:
Conversion from html to editor state every time editor in cms is used. Speed less critical there, but conversion accuracy??

Both: PROS:

Editor state for editor use, html string for rendering use
No conversions CONS:
Two sources of truth - can get out of sync without great care
More columns in database