News for hackers. Stuff that matters.

A comment on Size isn't everything for the modest creator of SQLite (2007).

Re:Size isn't everything for the modest creator of SQLite (2... by sehugg on Sunday February 07, 2016 @12:43AM (#11051804)
So how many SQLite databases are in use? "We don't have a good way of counting it," he says, "but we're guessing it's the most widely deployed SQL database in the world."

This article came out before the original iPhone was released -- it certainly is by now, probably by an order of magnitude.

[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by skeeterbug on Sunday February 07, 2016 @02:02AM (#11051998)
Chrome uses it for local storage too right?
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by infogulch on Sunday February 07, 2016 @02:31AM (#11052069)
And Firefox. There are probably more instances of SQLite in use than humans on the planet.
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by abtinf on Sunday February 07, 2016 @03:57AM (#11052237)
Just "an order of magnitude"? I suspect you are off by an order of magnitude. If you count each deployed instance of each product using it, it's probably the most popular by close to 10 orders of magnitude.

Edit: phones are just the start. Numerous embedded products use it - the kind that ship in such large quantities that a couple pennies per device become significant sums of money. And even in the phone case, every app is using a separate database.

[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by adrianN on Sunday February 07, 2016 @04:17AM (#11052280)
10 orders of magnitude is a lot. Are you really saying there are ten billion times more SQLlite databases than the next most popular SQL?
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by masklinn on Sunday February 07, 2016 @04:41AM (#11052329)
That's probably excessive by a lot, but every modern smartphone has at least one sqlite bundled (possibly more, some software will bundle their own in case the system changes its version), OSX bundles it (and Apple Mail uses it for some stuff), Chrome and Firefox bundle it, …
[ Parent | on HN ]
Re:Size isn't everything for the modest creator of SQLite (2... by throwawaymsft on Sunday February 07, 2016 @05:38PM (#11055293)
Off by "an (one) order of magnitude", i.e. off by 2 orders of magnitude.
[ Parent | on HN ]