News for hackers. Stuff that matters.
Re:Why you should probably be using SQLite by llimllib on Friday October 27, 2023 @10:12AM (#38038672)
simonw's sqlite-utils can be helpful for executing table changes:

https://sqlite-utils.datasette.io/en/stable/python-api.html#...

https://sqlite-utils.datasette.io/en/stable/cli-reference.ht...

> Also it doesn't allow you to use multiple application servers.

Not in the same way you use postgres etc, but you can do it with sharding or with LiteFS, but you do have to consider carefully how you scale your app.

I'm not _really_ disagreeing with you, but I think you're painting with a bit too broad of a brush.

Re:Why you should probably be using SQLite by modo_ on Friday October 27, 2023 @11:44AM (#38040032)
Thanks! Came to this thread hoping for something like these. They look useful!