I remember using SQLite like 12 years ago as a backend for Minecraft mods, and even more recently as a backend for HomeAssistant and switching away to something else for performance…and now switching back. Kudos to them for all the work that went into that! Worst to first!
It is beautiful. I haven’t even thought of using a database server for personal projects in years. SQLite all the way. It’s so simple and performant (for my use cases).
As much as I would like to agree with you, permissive licenses are killing open source software as a whole since corporations absolutely abuse the software, provide very little value back to the code in return, and often DEMAND the authors patch their vulnerabilities.
Open source props up the world and the least that corporations could do is throw 0.0001% of their revenue their way. But they can’t even be bothered to do that.
SQLite is one of the very few open source projects with a reasonable plan for monetisation.
Do you want to use one of the proprietary extensions? Fork up a few thousand. No biggie.
Do you operate in a regulated industry (aviation) and need access to the 100% coverage test suite along with a paper trail? Fork up ”Call us”.
Is your company insisting that you only use licensed or supported software? Well, you can apparently pay them for a licence to their public domain software.
Basically, squeeze regulated industries, hard.
I’m all for open source, but at some point developers should stop acting surprised when people use their work at the edges of the licence terms (Looking at you Mongo, Redis and Hashicorp). As for developers running projects on their free time, maybe start setting boundaries? The only reason companies aren’t paying is because they know they can get away withholding money, because some sucker will step up and do it for free, ”for the greater good”. Stop letting them get it for free.
Looks like RedHat is kinda going in this direction (pay to get a paper trail saying a CVE-number is patched), and basically always have been squeezing regulated industry. Say what you want about that strategy, it’s at least financially viable long term. (Again, looking at you Hashicorp, Redis, Mongo, Minio and friends)
SQLite continues to be the “Do Nothing. Win” of databases
It’s wild how it has the fastest read performance of any other sql backend, even postgres.
I remember using SQLite like 12 years ago as a backend for Minecraft mods, and even more recently as a backend for HomeAssistant and switching away to something else for performance…and now switching back. Kudos to them for all the work that went into that! Worst to first!
I love SQLite but is this still true? I thought DuckDB was on its way to supplanting SQLite is this area.
Oh, have they started working on aviation grade test harnesses?
SQLite will rule our world for a long time, far after we are gone.
I thought Turso is the new cool kid on the block
It is beautiful. I haven’t even thought of using a database server for personal projects in years. SQLite all the way. It’s so simple and performant (for my use cases).
Its sheer flexibility and public domain license are definitely big factors
As much as I would like to agree with you, permissive licenses are killing open source software as a whole since corporations absolutely abuse the software, provide very little value back to the code in return, and often DEMAND the authors patch their vulnerabilities.
Open source props up the world and the least that corporations could do is throw 0.0001% of their revenue their way. But they can’t even be bothered to do that.
SQLite is one of the very few open source projects with a reasonable plan for monetisation.
Basically, squeeze regulated industries, hard.
I’m all for open source, but at some point developers should stop acting surprised when people use their work at the edges of the licence terms (Looking at you Mongo, Redis and Hashicorp). As for developers running projects on their free time, maybe start setting boundaries? The only reason companies aren’t paying is because they know they can get away withholding money, because some sucker will step up and do it for free, ”for the greater good”. Stop letting them get it for free.
Looks like RedHat is kinda going in this direction (pay to get a paper trail saying a CVE-number is patched), and basically always have been squeezing regulated industry. Say what you want about that strategy, it’s at least financially viable long term. (Again, looking at you Hashicorp, Redis, Mongo, Minio and friends)
Am I missing something? SQLite is great, but it isn’t really comparable to most other SQL databases, unless you’re talking about nosql alternatives?