3 ms·
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 ser
by pmontra 7y ago
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.
- redhale 7y ago> "forever" You can always migrate later, and avoid the extra overhead now. No decision is forever.