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

61–70 of 82 posts

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

#61

Post by TZubiri »

TheRealPomax wrote: post #12
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'm not sure I buy the "important data" one: my Lightroom catalog, to me , constitutes incredibly important data. Losing it and just having the base files would destroy over a decade of work. It also happens to be a SQLlite3 database. And the same is true for a slew of other applications that (quite rightly) use SQLite databases as their file format. You might be thinking of things like financial transactions, or med…

How do you physically store it? An external disk?

I venture a guess that for each sqlite db holding important work data, you have dozens or hundreds of traditional db datasets, that are critical to your work. And yes, I mean your bank, but also messaging apps, online services.

If you backup your hard drive in the cloud at all, you are already depending on trad dbs for the very use case supposedly highlighting your dependence on sqlite.

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

#62

Post by TZubiri »

strogonoff wrote: post #60
TZubiri wrote: post #52

Earlier quoted context omitted.

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

The topic is not quality but popularity.

Yes. In terms of popularity (installs/time) psql superseded mysql. Although of course at the tipover point msql still may have beaten psql in terms of total installations, i'm pretty sure even by that metric psql already won.

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

#64

Post by strogonoff »

TZubiri wrote: post #62
strogonoff wrote: post #60

Earlier quoted context omitted.

The topic is not quality but popularity.

Yes. In terms of popularity (installs/time) psql superseded mysql. Although of course at the tipover point msql still may have beaten psql in terms of total installations, i'm pretty sure even by that metric psql already won.

Source? I’ve only been using PostgreSQL, but I believe most legaxy systems are not going to rush to update, and world consists of legacy systems and systems that will become legacy tomorrow.

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

#65

Post by RyanHamilton »

TZubiri wrote: post #51
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.

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 technoc…

There's quite a few guis available, eg here's mine: https://www.timestored.com/qstudio/database/sqlite You raise an interesting idea. What if sqlite database s has also been .exe executable to give at least a cli. That would have been interesting, similar to redhead.

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

#66

Post by TZubiri »

strogonoff wrote: post #64
TZubiri wrote: post #62

Earlier quoted context omitted.

Yes. In terms of popularity (installs/time) psql superseded mysql. Although of course at the tipover point msql still may have beaten psql in terms of total installations, i'm pretty sure even by that metric psql already won.

Source? I’ve only been using PostgreSQL, but I believe most legaxy systems are not going to rush to update, and world consists of legacy systems and systems that will become legacy tomorrow.

I'm the source

we have been living in a psql era for longer than mysql, so it has had enough time to catchup.

If you feel otherwise it's probably that memory bias effect where distant events seem closer and we underestimate the passage of time,

There's an xkcd for that

https://xkcd.com/891/

"The death of mysql(2010) is closer to its birth(1995) than to the present (2025)" will become a true statement next year.

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

#67

Post by ffsm8 »

TZubiri wrote: post #66
strogonoff wrote: post #64

Earlier quoted context omitted.

Source? I’ve only been using PostgreSQL, but I believe most legaxy systems are not going to rush to update, and world consists of legacy systems and systems that will become legacy tomorrow.

I'm the source we have been living in a psql era for longer than mysql, so it has had enough time to catchup. If you feel otherwise it's probably that memory bias effect where distant events seem closer and we underestimate the passage of time, There's an xkcd for that https://xkcd.com/891/ "The death of mysql(2010) is closer to its birth(1995) than to the present (2025)" will become a true statement next year.

So it's essentially your gut feeling?

It's obviously going to be hard to determine a number for a statistic like "most popular", and there are always very different interpretations of the available numbers, ending up with vastly different rankings.

I.e. this one keeps Oracle DB at place 1, mysql at second: https://db-engines.com/en/ranking

It links to their method at the top of the statistics. (Oracle has basically a DB monopoly if you believe that ranking, as these are both owned by them)

It's dataset is probably flawed, but I think we can say

"Rumors of mysqls death have been greatly exaggerated"

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

#68

Post by [deleted] »

TheRealPomax wrote: post #12
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'm not sure I buy the "important data" one: my Lightroom catalog, to me , constitutes incredibly important data. Losing it and just having the base files would destroy over a decade of work. It also happens to be a SQLlite3 database. And the same is true for a slew of other applications that (quite rightly) use SQLite databases as their file format. You might be thinking of things like financial transactions, or med…

[deleted]

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

#69

Post by yen223 »

cmur wrote: post #10

I’m curious, is the prevalence of SQLite similar to how PHP is widely used because it’s behind many WordPress sites?

Kind of, at least in regards to mobile.

When developing iOS and Android apps, the "default" frameworks for storing data (Core Data for iOS, Room for Android) are wrappers around sqlite.

I would guess >50% of apps installed on your phone uses sqlite.

Post reply on HN