ALTER TABLE is quite limited in SQLite (for example there is no DROP COLUMN). Have you missed this?
Yes I miss proper ALTER TABLE a lot when it would have been useful. But my experience shows me that I can design software pretty well following YAGNI and the occasional instances of when I need missing functionality is more than made up for the ease of use otherwise.
What are the advantages, in your own experience, of using SQLite instead of something like PostgreSQL? With PostgreSQL, you could run database migrations during business hours and use a proper ALTER TABLE.
I'm curious: why do you queue instead of directly writing to the database?
ssh user@server
sqlite file://$PWD/db.sqlite?mode=roI was thinking of something more "graphical", similar to pgAdmin or SequelPro, when you need to navigate in a dataset.
But I suppose you'll have to string up something if you want it to access a remote db.