Re:Ask HN: Who uses SQLite database in production?
by pmontra on Saturday July 06, 2019 @12:56AM
(#20367965)
I've been there a few times myself. I don't have time now to go into details (weekend) but if you know your app is going to stay small and simple and single server forever
1. Congratulations for your foresight skills :-)
2. You can stay with SQLite
In any other case move to PostgreSQL (or MySQL if you really have to) because you'll be hit by things you can't do or that you can do at a cost higher than migrating to a proper db and managing it.
Downsides: simple and few data types, lack of advanced SQL functions (MySQL too) and features, single server, write lock, poor CLI tool.
Be really sure you don't have and want to grow your app.
1. Congratulations for your foresight skills :-)
2. You can stay with SQLite
In any other case move to PostgreSQL (or MySQL if you really have to) because you'll be hit by things you can't do or that you can do at a cost higher than migrating to a proper db and managing it.
Downsides: simple and few data types, lack of advanced SQL functions (MySQL too) and features, single server, write lock, poor CLI tool.
Be really sure you don't have and want to grow your app.