Live data from Hacker News

There are over one trillion SQLite databases in active use

sqlite.org

91–92 of 92 posts

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

#91
post #23
post #5

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

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.

The OS does do that, on behalf of applications CoreData or those using SQLite directly.

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

#92
post #25
post #20

Earlier quoted context omitted.

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

It's perfectly fine

one column for a timestamp and one column to store the json

You then build materialized views pulling out whatever json fields you need.

Post reply on HN