Re:Ask HN: Have you used SQLite as a primary database?
by tianzhou on Saturday April 30, 2022 @12:32PM
(#31217199)
We also used SQLite and leverage PRAGMA user_version to do the trick. But decided to move to PostgreSQL mainly due to the schema migration constraints.
Our experience is SQLite is OK for small to medium projects, but when the business logic/data model becomes more complex, SQLite is not sufficient.
Our experience is SQLite is OK for small to medium projects, but when the business logic/data model becomes more complex, SQLite is not sufficient.
More discussions are captured here https://news.ycombinator.com/item?id=31038614