There are over one trillion SQLite databases in active use • Hacker News Board

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

#31

Post by pessimizer » Mon, Dec 06, 2021, 4:54 PM UTC

da_chicken wrote: post #6

peterth3 wrote: 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.

No, that still seems inflated. That's like counting installs of Word or Excel by counting the number of documents that exist.

"Active" is a big word here. Each of these databases is in nearly continuous use. You couldn't say that about the vast majority of excel spreadsheets, or any word documents.

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

#32

Post by anamexis » Mon, Dec 06, 2021, 4:54 PM UTC

Aeolun wrote: post #23

peterth3 wrote: 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.

What does active use really mean? The databases themselves are only accessed for a few nanoseconds at a time.

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

#33

Post by throwanem » Mon, Dec 06, 2021, 4:55 PM UTC

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.

> No one is required to follow The Rule...[The SQLite developers] view The Rule as their promise to all SQLite users of how the developers are expected to behave. This is a one-way promise, or covenant. In other words, the developers are saying: "We will treat you this way regardless of how you treat us."

I don't see a problem here, despite my own disinterest in following the Christian faith or any other. It's not hard to distinguish what's applicable from what's not in the verbatim quote of the Rule as given in the document, and if I had maintained my childhood Catholicism I too might demur from merely excerpting a saint.

Had anyone involved with SQLite mistreated someone for not happening to share their faith, I would expect it quite quickly to become public knowledge at least in the community including HN. I haven't heard such a report. Have you?

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

#34

Post by hstan4 » Mon, Dec 06, 2021, 4:56 PM UTC

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.

> No one is required to follow The Rule, to know The Rule, or even to think that The Rule is a good idea. The Founder of SQLite believes that anyone who follows The Rule will live a happier and more productive life, but individuals are free to dispute or ignore that advice if they wish.

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

#35

Post by hereforphone » Mon, Dec 06, 2021, 4:56 PM UTC

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.

That's just because you disagree. Go read the Rust code of ethics, it may be more up your alley.

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

#36

Post by tyingq » Mon, Dec 06, 2021, 4:56 PM UTC

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.

>must be some sort of forgotten April fool's remnant.

I don't think so. His homepage has a couple of religious references, and you can find stuff like this in the tests: https://github.com/sqlite/sqlite/blob/37d4ec86bfa78c31732132...

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

#37

Post by hereforphone » Mon, Dec 06, 2021, 4:56 PM UTC

bigdict wrote: post #29

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.

SQLite code of conduct, §17: bury the dead. Hmmm… ok.

To be fair it's better than leaving them laying around in the open

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

#38

Post by throwanem » Mon, Dec 06, 2021, 4:57 PM UTC

anamexis wrote: post #32

Aeolun wrote: post #23

Earlier quoted context omitted.

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.

What does active use really mean? The databases themselves are only accessed for a few nanoseconds at a time.

I think "something somebody uses will break if this file is missing or corrupt" probably makes a reasonable definition here.

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

#39

Post by [deleted] » Mon, Dec 06, 2021, 4:57 PM UTC

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…

[deleted]

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

#40

Post by raziel2p » Mon, Dec 06, 2021, 4:58 PM UTC

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.

Not quite April fool's, but it's definitely a joke, but one with a practical purpose.

> This document continues to be used for its original purpose - providing a reference to fill in the "code of conduct" box on supplier registration forms.

> [we] have pledged to govern [...] in accordance with the "instruments of good works" from chapter 4 of The Rule of St. Benedict (hereafter: "The Rule"). This code of ethics has proven its mettle in thousands of diverse communities for over 1,500 years, and has served as a baseline for many civil law codes since the time of Charlemagne.

So on paper, this makes it a very good code of conduct - something very safe to put on a supplier registration form.