3 ms·
simonw's sqlite-utils can be helpful for executing table changes: https://sqlite-utils.datasette.io/en/stable/python-api.html#transforming-a-table https://sqli
by llimllib 3y ago
simonw's sqlite-utils can be helpful for executing table changes:
https://sqlite-utils.datasette.io/en/stable/python-api.html#transforming-a-table https://sqlite-utils.datasette.io/en/stable/python-api.html#...
https://sqlite-utils.datasette.io/en/stable/cli-reference.html#transform 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.
- modo_ 3y agoThanks! Came to this thread hoping for something like these. They look useful!