News for hackers. Stuff that matters.
Re:SQLite is not a toy database (2021) by menzoic on Tuesday August 16, 2022 @02:09AM (#32479682)
> Using SQLite for a network service when the app runs on the same machine as the SQLite file is perfectly fine

If preventing data loss is important for your app then this would be more hassle than using a networked db because now you have to replicate SQLite across a network to another machine.

Re:SQLite is not a toy database (2021) by samb1729 on Tuesday August 16, 2022 @02:49AM (#32479900)
> If preventing data loss is important for your app then this would be more hassle than using a networked db

How so? A networked database requires a persistent connection, while SQLite backups work fine with an intermittent connection. The best case (100% network uptime) and worst case (total network outage) are the same, but in the middle, SQLite-with-backups is more resilient to brief outages.