3 ms·
Are all writes blocked during database migrations? ALTER TABLE is quite limited in SQLite (for example there is no DROP COLUMN). Have you missed this?
by ngrilly 8y ago
Are all writes blocked during database migrations?
ALTER TABLE is quite limited in SQLite (for example there is no DROP COLUMN). Have you missed this?
- cheez 8y agoAll writes are blocked during database migrations, so there is potential offline time. For example, when I added the index, I needed to be offline. Fortunately, my application is only needed during business hours. 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.
- ngrilly 8y agoThanks for sharing your experience with SQLite :-) 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.
- cheez 8y agoMain reason is that SQLite is embedded with my application. There isn't a second, third or fourth "microservice" to spin up. I know Terraform/Docker, love them, but the gymnastics I need to orchestrate for my particular situation is not worth it. So for the tradeoff of complexity for functionality, SQLite hits a very good sweet spot for me.