3 ms·
Webapps (or webapp frameworks) like Nextcloud and Django, come, by default, with SQLite. That makes it easy to start, but they all warn you: When you get seriou
by teekert 5y ago
Webapps (or webapp frameworks) like Nextcloud and Django, come, by default, with SQLite. That makes it easy to start, but they all warn you: When you get serious, get a real DB like MariaDB or PostgreSQL... And with stuff like this I wonder, is this really necessary?
I really like SQLite, it's well supported in Python, backup-restore is very simple. What is the real difference (probably application depended) between SQLite and a "real" DB engine?
- tcbasche 5y agoI guess the idea is you can scale the app independently of the DB. How do you scale out a single file? (Genuinely curious)
- teekert 5y agoHmm, never thought of this :) I come more from a selfhosting angle. And my django website is prototype only so far… But it is a point I never considered so thanx. I wonder at what scales this starts to count (in human readable units ;))
- discordance 5y agoThis spells out where it’s appropriate and where it isn’t: https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html
- teekert 5y agoThanx!