Ask HN: Have you used SQLite as a primary database?
I'm a bit late to the party, but just in case it's useful to anyone: I'm using one DB per user for my CV tool on withoutdistractions.com<p>Since every user has a separate DB file, writes to those files don't block reads from the global DB file which contains everyones public data. As long as you keep your user DB schema the same as the global DB schema, it's pretty easy to sync records using a simple cron job.<p>More info on my tech stack here: <a href="https://withoutdistractions.com/cv/faq#technology" rel="nofollow">https://withoutdistractions.com/cv/faq#technology</a><p>In case that link ever goes down, here's an archive link: <a href="https://web.archive.org/web/20220503102946/https://withoutdistractions.com/cv/faq" rel="nofollow">https://web.archive.org/web/20220503102946/https://withoutdi...</a>