There are over one trillion SQLite databases in active use
1–10 of 92 posts
Re: There are over one trillion SQLite databases in active use
#2They'd have one trillion + 1 if they had better JSON support.
I'd be using it in a large healthcare project I'm working on now.
Unfortunately, the JSON support is basically "serialize to a string". Postgres is miles ahead with jsonb.
Shame, I <3 sqlite.
Re: There are over one trillion SQLite databases in active use
#3Ok tens of billions I believe, but trillion+ is likely an exaggeration
Re: There are over one trillion SQLite databases in active use
#4Richard Hipp discussed this (alongside a deep-dive on the philosophies underpinning his Fossil SCM) when we had him back on The Changelog podcast recently:
Re: There are over one trillion SQLite databases in active use
#5Ok tens of billions I believe, but trillion+ is likely an exaggeration
> Since SQLite is used extensively in every smartphone, and there are more than 4.0 billion (4.0e9) smartphones in active use, each holding hundreds of SQLite database files, it is seems likely that there are over one trillion (1e12) SQLite databases in active use.
Sounds reasonable to me.
Re: There are over one trillion SQLite databases in active use
#6Ok tens of billions I believe, but trillion+ is likely an exaggeration
> Since SQLite is used extensively in every smartphone, and there are more than 4.0 billion (4.0e9) smartphones in active use, each holding hundreds of SQLite database files, it is seems likely that there are over one trillion (1e12) SQLite databases in active use. Sounds reasonable to me.
No, that still seems inflated. That's like counting installs of Word or Excel by counting the number of documents that exist.
Re: There are over one trillion SQLite databases in active use
#7Earlier quoted context omitted.
> Since SQLite is used extensively in every smartphone, and there are more than 4.0 billion (4.0e9) smartphones in active use, each holding hundreds of SQLite database files, it is seems likely that there are over one trillion (1e12) SQLite databases in active use. Sounds reasonable to me.
No, that still seems inflated. That's like counting installs of Word or Excel by counting the number of documents that exist.
That's exactly what's being counted. A database is a SQLite document.
Re: There are over one trillion SQLite databases in active use
#8Don’t forget to count all the cruise missiles, too!
Re: There are over one trillion SQLite databases in active use
#9Earlier quoted context omitted.
> Since SQLite is used extensively in every smartphone, and there are more than 4.0 billion (4.0e9) smartphones in active use, each holding hundreds of SQLite database files, it is seems likely that there are over one trillion (1e12) SQLite databases in active use. Sounds reasonable to me.
No, that still seems inflated. That's like counting installs of Word or Excel by counting the number of documents that exist.
The pays says: "Billions and billions of copies of SQLite exist in the wild". Which seems reasonable and is counting the number of installs as you preferred.
Later on the page says "it is seems likely that there are over one trillion (1e12) SQLite databases in active use" which is the quoted title and seems like a reasonable claim and is counting "documents" not installs.
I don't think "documents" is an uninteresting statistic. It is just a different one.
Re: There are over one trillion SQLite databases in active use
#10Earlier quoted context omitted.
> Since SQLite is used extensively in every smartphone, and there are more than 4.0 billion (4.0e9) smartphones in active use, each holding hundreds of SQLite database files, it is seems likely that there are over one trillion (1e12) SQLite databases in active use. Sounds reasonable to me.
No, that still seems inflated. That's like counting installs of Word or Excel by counting the number of documents that exist.
That's... Exactly what a SQLite database is - a file. This thread isn't about the number of unique devices that potentially use SQLite