Hi all!
I’m back to work with kirby on a new project after long time.
We plan to have a website where the user can comment on anything that’s part of an article:
- texts
- images
- videos
- audios
For each block the user can comment on the entire block or select a portion of it (for text an offset, for audio a clip, etc). So far so good.
To store comments I thought to use SQLite (or eventually PostgreSQL) by:
- outputting the kirby block ID to the DOM as a
data-attribute
- use that ID to reference the comment in the table
I’m sharing all this to ask if anyone tried a similar setup before? I think one possible thing to figure out would be concurrent writing on SQLite, but I am more concerned / curious about if creating a relationship between kirby blocks and a SQL db like this is good?
Thanks and happy to report back the way we handled this.