Re:SQLite – The “server-process-edition” branch
by chubot on Wednesday August 15, 2018 @07:20PM
(#17770585)
Honest 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 :)
Re:SQLite – The “server-process-edition” branch
by codefined on Thursday August 16, 2018 @05:15PM
(#17778470)
I 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.
Re:SQLite – The “server-process-edition” branch
by eismcc on Wednesday August 15, 2018 @08:31PM
(#17770951)
The lite doesn’t refer to light, it refers to a “mineral”.
Re:SQLite – The “server-process-edition” branch
by oblio on Thursday August 16, 2018 @03:40AM
(#17772696)
I 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
Re:SQLite – The “server-process-edition” branch
by TeMPOraL on Thursday August 16, 2018 @04:10AM
(#17772823)
> 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.
Re:SQLite – The “server-process-edition” branch
by api on Wednesday August 15, 2018 @11:09PM
(#17771594)
If 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.
Re:SQLite – The “server-process-edition” branch
by captn3m0 on Wednesday August 15, 2018 @11:14PM
(#17771612)
It exists: https://github.com/CanonicalLtd/dqlite
Re:SQLite – The “server-process-edition” branch
by oconnor663 on Wednesday August 15, 2018 @11:14PM
(#17771615)
Today is your lucky day: https://github.com/rqlite/rqlite
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.