Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

There are over one trillion SQLite databases in active use

sqlite.org

Post reply on HN
Print view View original

21–30 of 92 posts

Re: There are over one trillion SQLite databases in active use

#21

Post by spicybright »

ntumlin wrote: post #17
andkon wrote: post #8

Don’t forget to count all the cruise missiles, too!

Those tend to fall out of the “active use” category not long after entering it, so it’s probably not a big factor. On a more serious note, had there been something special about SQLite supporting military use of their project that prompted this? Otherwise that’s the point of free software, people are free to do (mostly) whatever they want with it. Including building weapons. SQLite is so prevalent, it’s almost like p…

I'm sure it was picked a long time ago and it's too costly to switch. I imagine any code going into multi-million dollar missile needs to be incredibly audited and understood.

(Not that this never happens! https://www.simscale.com/blog/2017/12/nasa-mars-climate-orbi...)

Re: There are over one trillion SQLite databases in active use

#23

Post by Aeolun »

peterth3 wrote: post #5
ccozan wrote: post #3

Ok 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.

Hundreds of SQLite files? In active use? Unless iOS itself spawns a few hundred instances and actively uses them all the time I have a hard time thinking of what would use so many databases, much less that they’re actually in active use.

Re: There are over one trillion SQLite databases in active use

#25

Post by acatton »

nojito wrote: post #20
acatton wrote: post #12

Earlier quoted context omitted.

I love PostgreSQL, and would recommend it anytime. Even though jsonb is very powerful, in general if you store JSON in a SQL database you're very likely doing something wrong. (You're breaking first normal form) But if you really wanted to use SQLite to store JSON à la jsonb in PostgreSQL you can use generated fields[1] sqlite> create table t(id integer primary key autoincrement, data text); sqlite> insert into t(dat…

Disagree storing json in databases is often the best thing to do. Clickhouse for example allows you to quickly pull out relevant data and feed materialized views.

I never said storing json in databases was wrong. I said storing json in *SQL* databases was an anti-pattern.

https://en.wikipedia.org/wiki/First_normal_form

Re: There are over one trillion SQLite databases in active use

#26

Post by dfox »

JensRantil wrote: post #13

https://twitter.com/bagder/status/1467895841541210118?t=pPU8... and https://daniel.haxx.se/blog/2021/10/21/the-most-used-softwar... might be relevant here. TLDR; cURL is likely installed in even more devices (but not listed on SQLite's page).

I would hazard a guess that most used "software module of any description" is dtoa().

Re: There are over one trillion SQLite databases in active use

#28

Post by thepasswordis »

sdfghderwg wrote: post #19

Love god? What? What an oddly discriminatory thing to have on the code of ethics... EDIT: I'm convinced this must be some sort of forgotten April fool's remnant.

The code of ethics is a 1500 year old "code of ethics" meant to govern the lives of benedictine monks: https://en.wikipedia.org/wiki/D._Richard_Hipp

That might provide some context.

edit: haha, this is what I get for skimming the wikipedia article. He has a PhD in computer science, but the full "doctorate of philosophy" is written out instead of abbreviation on that wikipedia article. My pattern matcher needs tuning, apparently. Thanks to those who pointed this out.

Re: There are over one trillion SQLite databases in active use

#30

Post by joshuamorton »

sdfghderwg wrote: post #19

Love god? What? What an oddly discriminatory thing to have on the code of ethics... EDIT: I'm convinced this must be some sort of forgotten April fool's remnant.

It isn't. The SQLite team is 3ish people who don't accept outside contributions and are all Christan.
Post reply on HN