We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
1–10 of 125 posts
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#2Could (2016) be added to the title?
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#3As a postgresql nut, the people suggesting those other platforms (incl. pgsql) are idiots. Postgres in particular would be a bad idea unless he wanted to incorporate VACUUM() into his loading screen
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#4Related note: in the last year I started using SQLite with my Clojure scripts instead of using a remote database, and I'm storing everything in git. Works like a charm for single-user tasks.
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#5Related note: in the last year I started using SQLite with my Clojure scripts instead of using a remote database, and I'm storing everything in git. Works like a charm for single-user tasks.
Do you store the binary .sqlite in Git or source .sql and build the .sqlite?
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#6Can confirm. SQLite is great. I've written an e-commerce website for a customers a few years ago. Most of the data was static and only updated a couple times per day in bulk. It was easy to do the main import/data update completely offline, then copying over the db file to multiple servers and doing mostly read-only queries on the DB. SQLite was more than fast enough and not having to manage another service was totally worth it. It's good having SQLite in your toolbox.
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#7Could (2016) be added to the title?
[deleted]
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#8Kudos to this guy. As the maintainer of an open source project, the hardest job is to tell people "your idea is stupid and I won't do it"
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#9The mistale here is thinking that a "fancier DBMS" MUST be off-process.
I totally wish for a fancier DBMS that can be embebed (firebird fit here!) and work on mobile (but not here yet).
And not only "fancier" in the limited sense that most believe. I truly mean A LOT FANCIER.
Re: We’re happy with SQLite and not urgently interested in a fancier DBMS (2016)
#10SQLite is a fantastic database for desktop applications. https://www.sqlite.org/appfileformat.html is a great essay on its benefits for this kind of use-case.