71–80 of 82 posts
Earlier quoted context omitted.
Former US military officer here. This does not surprise me at all. I wasn’t in subs but we absolutely did this for maintenance of other multimillion dollar assets.
Microsoft is in so many government offices around the world it's not even funny.
Earlier quoted context omitted.
Source? I’ve only been using PostgreSQL, but I believe most legaxy systems are not going to rush to update, and world consists of legacy systems and systems that will become legacy tomorrow.
I'm the source we have been living in a psql era for longer than mysql, so it has had enough time to catchup. If you feel otherwise it's probably that memory bias effect where distant events seem closer and we underestimate the passage of time, There's an xkcd for that https://xkcd.com/891/ "The death of mysql(2010) is closer to its birth(1995) than to the present (2025)" will become a true statement next year.
In terms of installations, sure. In terms of total data, probably not. In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity. Server side and centralized beats client side decentralized for all but sensitive consumer data.
I'm not sure I buy the "important data" one: my Lightroom catalog, to me , constitutes incredibly important data. Losing it and just having the base files would destroy over a decade of work. It also happens to be a SQLlite3 database. And the same is true for a slew of other applications that (quite rightly) use SQLite databases as their file format. You might be thinking of things like financial transactions, or med…
So is contacts list, sms messages, Whatsapp data, browser data etc etc. whese are separate installations of sqlite, hundreds per phone. And they ARE important, at least to me.
i find it ironic one of the most gatekeepy, closed, walled garden companies in the history of the planet, Bloomberg, is a sponsor of one of the most free most open piece of software ever.
The majority of these SQLite use cases that the article is celebrating are... as the internal data store in an app where it is locking up user data in a proprietary, closed, gate kept wall garden. This irony has layers. Like an onion.
Earlier quoted context omitted.
If I'm not mistaken, Apple's CoreStorage is based on SQLite, so pretty much every Apple device for the last years (or decade, probably) is constantly using tens (or more) SQLite databases, per OS. That includes Macs, Phones, Watches, AppleTV etc. That has got to be more than 3 billion devices (since there are at least 2 billion of the phones in active use). SQLite is also quite often a CI/CD default when building and…
It's also heavily used on Android, so that's some 3bn devices (based on active users numbers from earlier this year). Plus it's in Firefox, Chrome, and so on.
Suffice to say SQLite is probably at least 6bn active usages in size.
I love SQLite. It’s pluggable interfaces and concise C code make it enjoyable to use (and sometimes to debug - as long as you don’t have to go through the single file version!). Unfortunately, I wish there were multiple implementations of it, and that the file format was documented and stable.
https://sqlite.org/fileformat2.html https://sqlite.org/lts.html https://sqlite.org/locrsf.html
Earlier quoted context omitted.
The majority of these SQLite use cases that the article is celebrating are... as the internal data store in an app where it is locking up user data in a proprietary, closed, gate kept wall garden. This irony has layers. Like an onion.
Do you use music player? Most, including open source are using SQLite inside. There are open source tiling maps formats like MBTiles, based on SQLite. Just dig around, you can find plenty of examples. It's other way around since database format is well known with tooling available
Keeping your playlists in a specific music player app’s SQLite database forces you to use that app to search or delete or share those playlists. Heck, some apps use SQLite blob storage to store images or even music files.
Open software should use open file formats and store data in the file system where other programs can access it.
Earlier quoted context omitted.
I'm the source we have been living in a psql era for longer than mysql, so it has had enough time to catchup. If you feel otherwise it's probably that memory bias effect where distant events seem closer and we underestimate the passage of time, There's an xkcd for that https://xkcd.com/891/ "The death of mysql(2010) is closer to its birth(1995) than to the present (2025)" will become a true statement next year.
There are stats that claim MySQL is used more, but I did not link to them because I don’t know if they are trustworthy. You, meanwhile, just made a fact out of thin air.
Earlier quoted context omitted.
Do you use music player? Most, including open source are using SQLite inside. There are open source tiling maps formats like MBTiles, based on SQLite. Just dig around, you can find plenty of examples. It's other way around since database format is well known with tooling available
I’m not remotely claiming ‘I never use software that has SQLite inside it’. I use loads of programs that do. And that’s precisely the kind of walled garden I’m talking about. Keeping your playlists in a specific music player app’s SQLite database forces you to use that app to search or delete or share those playlists. Heck, some apps use SQLite blob storage to store images or even music files. Open software should us…
That's what SQLite is.