4 ms·
Because SQLite is often the right tool for the job, more so than Postgres and MySQL. It scales insanely well and requires minimal configuration and near zero ad
by andrewguenther 8y ago
Because SQLite is often the right tool for the job, more so than Postgres and MySQL. It scales insanely well and requires minimal configuration and near zero administration. I try to use SQLite for as long as is feasible in my projects purely because it "just works".
Don't let the "Lite" fool you. Depending on your needs, you can scale to 10s of thousand of users using just SQLite. Or not! It is all about knowing your system and properly evaluating your options. I choose to use SQLite because it often fits the use case of small to medium projects the best.
- deleted 8y ago[deleted]
- chubot 8y agoHonest question: where do Postgres and MySQL fall down for such deployments? What is the administration required? Backups? Users and permissions? Indices? FWIW I use sqlite for a personal wiki, i.e. a website with exactly one user :)
- codefined 8y agoI think the idea is that if your service does more, it necessarily needs more work to maintain. From a simple point of view, there are just more moving parts to go wrong.
- deleted 8y ago[deleted]
- eismcc 8y agoThe lite doesn’t refer to light, it refers to a “mineral”. https://changelog.com/podcast/201 https://changelog.com/podcast/201
- oblio 8y agoI was confused by this, so I read the transcript. In case anyone else reads this, the name is supposed to be read as: SQL (S Q L or sequel, your call) - ite So it does sound like the name of a mineral: bauxite, boehmite, hematite, etc. Heck, kryptonite :D
- TeMPOraL 8y ago> Jerod Santo: > Hm, like a mineral. Were you playing on the word "light", or were you just playing on mineral...? > Richard Hipp: > I was, I was. It's pronounced as a mineral. It's still a pun on "light". And an obvious one, given what SQLite is compared to other RDBMSes.
- api 8y agoIf someone put a good fast raft replication engine in process in front of sqlite you'd have a pretty killer db for a lot of things.
- captn3m0 8y agoIt exists: https://github.com/CanonicalLtd/dqlite https://github.com/CanonicalLtd/dqlite
- oconnor663 8y agoToday is your lucky day: https://github.com/rqlite/rqlite https://github.com/rqlite/rqlite