3 ms·
SQLite is fine, but I have ran Postgresql on a $20 server without any issues, and I would suggest if you have to deal with concurrent users and tasks, Postgresq
by t_mahmood 6mo ago
SQLite is fine, but I have ran Postgresql on a $20 server without any issues, and I would suggest if you have to deal with concurrent users and tasks, Postgresql is the way to go. SQLite WAL works, but sometimes it caused some issues, when you have a lot of concurrent tasks running continuously.
And, not sure I'm correct, but I felt Postgresql has more optimized storage if you have large text data than SQLite, at least for me I had storage full with SQLite, but same application on Postgresql never had this issue
- bornfreddy 6mo agoPlus, if/when you start caring about HA, it will be easier.
- La-Douceur 6mo agoYou can also absolutely run Postgres on your vps, the setup is slightly more complicated than sqlite, but it's a matter of 15 minutes vs 5 minutes.