News for hackers. Stuff that matters.
Re:Siren Call of SQLite on the Server by Skinney on Tuesday February 18, 2025 @07:27AM (#43088722)
Keep user information in one database, keep user _data_ in another.

It all depends on your app, really. For some apps the above won't make sense, but maybe it would make sense to keep one db per org, or something like that.

Re:Siren Call of SQLite on the Server by gnulinux on Tuesday February 18, 2025 @07:36AM (#43088788)
You can also use a different but similar tool e.g. use sqlite to keep user information, use duckdb to keep user data. I find this combo very effective since sqlite is best as fast btree based indexed operations and duckdb is best at multiple row based aggregate computations (get me user X vs get me all users with property Y).