490
Syncthing 2.0 Launches With Major Database Overhaul
(linuxiac.com)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 12 Aug 2025
490 points (99.6% liked)
Linux
57274 readers
448 users here now
From Wikipedia, the free encyclopedia
Linux is a family of open source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991 by Linus Torvalds. Linux is typically packaged in a Linux distribution (or distro for short).
Distributions include the Linux kernel and supporting system software and libraries, many of which are provided by the GNU Project. Many Linux distributions use the word "Linux" in their name, but the Free Software Foundation uses the name GNU/Linux to emphasize the importance of GNU software, causing some controversy.
Rules
- Posts must be relevant to operating systems running the Linux kernel. GNU/Linux or otherwise.
- No misinformation
- No NSFW content
- No hate speech, bigotry, etc
Related Communities
Community icon by Alpár-Etele Méder, licensed under CC BY 3.0
founded 6 years ago
MODERATORS
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?