5
polv
5d

Embedded database is so lack of choice. SQLite, might be best, if you want stability / ACIDity.

Again, SQL means normalize everything, if I've ever want to index it...

Then, ON DELETE CASCADE? TRIGGER? Also, MANY-to-MANY kills.

Comments
  • 0
    Well... you could use MS Access...

    Can't you use an ORM that generates the SQL for you?
  • 1
    I feel the same. I hate the need to convert my data from hierarchical to relational and back again. But I can't find an alternative for secure, fast and reliable data storage.
  • 0
    If it's python, I have some good news for you: https://dataset.readthedocs.io/en/.... Converts types. If it's node, i again have good news: alopex (written by me because I was fan of the dataset lib) and sqlite has great support for writing custom adapters so you could write generuc stuff to match your needs
  • 1
    @rooter

    You forgot that indexing is important. SQLite can only index normalized tables, and string indexes do not search fast with LIKE '%xxx%'. (Or json1 extension).
  • 0
    @polv I don't forget, I ignore 😂 But I see you tagged desktop. I'm a sqlite fan but since docker is around I'm happy with others as well.

    I think sqlite doesn't have much competition because it's pretty cool for a file dB
  • 0
    @polv I'm not aware LIKE '%...%' performs well in any database... Have you considered using the full text search extension instead?

    https://www.sqlite.org/fts5.html
  • 1
    @sbiewald fts, at least in SQLite, requires sentences to be tokenize properly; as well as doesn't support wildcards.

    Some implementations I don't know might support wildcards.

    As for LIKE adaptation I am talking about, is, '% '||?||' %' for ` ${tags.join(' ')} `

    I do know a solution - normalized Tag table, with COLLATE NOCASE.
  • 0
    @sbiewald MongoDB does support string array indexing. Not sure about postgres; but definitely not SQLite.
Add Comment