3 ms·
Downside with separate SQLite databases will be when you want to have statistics over many users.
by ozim 3y ago
Downside with separate SQLite databases will be when you want to have statistics over many users.
- rudasn 3y agoI'm in this situation right now. How would one go about solving this? To keep this simple, I'm thinking exporting just the necessary data from each db and inserting that to a stats db (having a source column to each table, referring to the original db). Then load the stats db with Metabase or something. Migrations on the stats db may be a bit of a pain, as well as making sure that all data is exported and imported correctly every time. I'm sure there are better ideas.
- jocaal 3y agoLitestream is a library that allows you to easily create backups. You can probably just do analytics queries on the backup data. https://litestream.io/ https://litestream.io/
- djfobbz 3y agoSee this: https://news.ycombinator.com/item?id=26581807 https://news.ycombinator.com/item?id=26581807