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

SQLite is likely used more than all other database engines combined

sqlite.org

Post reply on HN
Print view View original

51–60 of 82 posts

Re: SQLite is likely used more than all other database engines combined

#51

Post by TZubiri »

simonw wrote: post #33
TZubiri wrote: post #7

In terms of installations, sure. In terms of total data, probably not. In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity. Server side and centralized beats client side decentralized for all but sensitive consumer data.

You may be shocked to learn how much of the world's "important data" lives in Excel files.

Not shocked, not a problem.

Easier to copy/replicate, packaged with a GUI, provider with a commercial relationship, programmatic support ( formulas, vba, COM, raw data access)

Would be closer to sqlite than server side though, but it's capacity for replication and sharing makes it more adecuate for sqlite.

Sqlite's lack of GUI gives data a programmer bias, important data uses excel because unless you are in a technocratic environment.

Re: SQLite is likely used more than all other database engines combined

#52

Post by TZubiri »

strogonoff wrote: post #50
simonw wrote: post #33

Earlier quoted context omitted.

You may be shocked to learn how much of the world's "important data" lives in Excel files.

A lot of world’s important data is on paper . As far as important data served from a relational database is concerned, MySQL most likely beats the hell out of everything in terms of popularity. The bulk of SQLite’s usage has to be various runtime caches, file data, and so on.

Postgresql superseded mysql ever since the maria fork/oracle acquisition.

Re: SQLite is likely used more than all other database engines combined

#53

Post by ysabri »

ARandomerDude wrote: post #44
novariation wrote: post #41

Earlier quoted context omitted.

Fun fact: my (french) company audited the french navy and found out they share important nuclear submarine maintenance data as excel files through email.

Former US military officer here. This does not surprise me at all. I wasn’t in subs but we absolutely did this for maintenance of other multimillion dollar assets.

Microsoft is in so many government offices around the world it's not even funny.

Re: SQLite is likely used more than all other database engines combined

#54

Post by TZubiri »

alganet wrote: post #18
TZubiri wrote: post #7

In terms of installations, sure. In terms of total data, probably not. In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity. Server side and centralized beats client side decentralized for all but sensitive consumer data.

How would you go about measuring that, or determining what's important? Huge SQL for servers is just a different use case. Someone's temporary browser data or settings for my android alarm app could be just as important and sensitive as an average record on those big servers. Fortunatelly, SQL fits the role of a small transactional engine very well to support those small use cases for a large number of applications.…

We don't need to measure everything, we may talk about variables that are hard or subjective to measure.

Re: SQLite is likely used more than all other database engines combined

#55

Post by ysabri »

TZubiri wrote: post #7

In terms of installations, sure. In terms of total data, probably not. In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity. Server side and centralized beats client side decentralized for all but sensitive consumer data.

I remember reading or seeing this post about how SQLite can really scale and supports a really high amount of transactions per second. I don't know if it supports distrubuted loads that well, which might be the reason why it's use didn't pick up server side.

Re: SQLite is likely used more than all other database engines combined

#56

Post by TZubiri »

II2II wrote: post #24
TZubiri wrote: post #7

In terms of installations, sure. In terms of total data, probably not. In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity. Server side and centralized beats client side decentralized for all but sensitive consumer data.

> In terms of total data, probably not. > In terms of important data, 100% not. Choosing not to focus upon quantity or quality is likely the reason why SQLite is so popular. It is a lot easier to manage and develop for SQLite than it is to do the same for large databases that require high availability and reliability under heavy loads. There are many more applications for small databases that contain data that is imp…

You can also use a plain file system, it allows data to be exported more easily and through un unbiased app like a file explorer.

I'd say if the data is important and client side, you'd probably want it to be accesible in a protocol format rather than a sqlite file format.

It's cool that sqlite is open source and u can technically recover the data, but at the end of the day excel data is more accesible, which defeats the ethos of open sourceness

Re: SQLite is likely used more than all other database engines combined

#57

Post by hehdhdjehehegwv »

tibbar wrote: post #42
hehdhdjehehegwv wrote: post #39

Earlier quoted context omitted.

The number of societal-wide problems that occur if your Lightroom database gets corrupted is zero. The amount of hell that would be unleashed if the financial systems layers upon layers of database transactions got broken is impossible to comprehend. So if you mean “important” as “necessary for society to function”, then no, your browser bookmark files, contact list, or the other two dozen things your laptop and phon…

This is a false equivalence, as one user’s particular usage of SQLite is not comparable to all financial instructions’ databases. Better to compare to the prospect of all smartphones being irreversibly corrupted at once.

Literally all smartphones dying at once is preferable because they are all backed up into heavy duty databases. You can restore every phone from the cloud in this thought experiment.

You can not restore a data center from a pile of phones.

Re: SQLite is likely used more than all other database engines combined

#58

Post by TZubiri »

arh68 wrote: post #27
TZubiri wrote: post #7

In terms of installations, sure. In terms of total data, probably not. In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity. Server side and centralized beats client side decentralized for all but sensitive consumer data.

Right. In terms of installations, I bet textfiles still win. Doesn't mean much, does it?

Gross theoretical error. Text files are a (ambiguous and undefined) file format, while sqlite is an application.

Re: SQLite is likely used more than all other database engines combined

#59

Post by TZubiri »

yndoendo wrote: post #40
TZubiri wrote: post #7

In terms of installations, sure. In terms of total data, probably not. In terms of important data, 100% not. Important data needs guarantees, and its privacy is second to its longevity. Server side and centralized beats client side decentralized for all but sensitive consumer data.

Would you classify a nurse call system as requiring important data retention and access? Mapping backbone devices with passive and interactive end user devices with means to communicate whom should provide assistance? Works great there too with μC/OS-II. Competition was using Windows XP and Microsoft Access. Only time ever using Oracle has been with internal business analytics, not very important.

No I would not, the application is important and critical, but the data? What data are you holding? Historical auditable data regarding calls? I have some experience with hospitals, and deep data like this would never be used for diagnostics or even epidemiology tracing.

Re: SQLite is likely used more than all other database engines combined

#60

Post by strogonoff »

TZubiri wrote: post #52
strogonoff wrote: post #50

Earlier quoted context omitted.

A lot of world’s important data is on paper . As far as important data served from a relational database is concerned, MySQL most likely beats the hell out of everything in terms of popularity. The bulk of SQLite’s usage has to be various runtime caches, file data, and so on.

Postgresql superseded mysql ever since the maria fork/oracle acquisition.

The topic is not quality but popularity.
Post reply on HN