Hacker News Reader

Comment by Pete-Codes | Hacker News Reader

hey, I posted the article. Good to know! I'm sure I had read it somewhere on their site. Maybe it was just from other developers that I got the impression it wasn't meant from production.

Thanks

View on HN

SQLite is staggeringly productions ready. I think the trick is to think of it less like a traditional database and more like a file format with an SQL front end.

From the website [1]

> SQLite is used by literally millions of applications with literally billions and billions of deployments.

It's also worth noting (at least, imo) that it's automated test suite is fantastic. I seems to recall it has considerably more test code than actual library code.

[1] https://www.sqlite.org/famous.html

I also used to have this impression, I think I got this from Rails and Django docs, maybe you read something similar?

> Rails comes with built-in support for SQLite, which is a lightweight serverless database application. While a busy production environment may overload SQLite, it works well for development and testing. Rails defaults to using a SQLite database when creating a new project, but you can always change it later.

> By default, the configuration uses SQLite. If you’re new to databases, or you’re just interested in trying Django, this is the easiest choice. SQLite is included in Python, so you won’t need to install anything else to support your database. When starting your first real project, however, you may want to use a more scalable database like PostgreSQL, to avoid database-switching headaches down the road.

The Django docs word it better - the chief problem with SQLite is that it's a _local_ database. If you outgrow a single server, you will now need to also migrate your database to something that can handle multiple external clients, or else figure out another way of making writes on one server be available to read on the other servers.

SQLite runs in airplanes [1]. I would say that is all that needs to be said on whether or not SQLite is production-ready :)

In fact, I would argue SQLite is the most well-tested and production ready database system out there.

[1] https://www.sqlite.org/famous.html

I've found that Apple uses sqlite too, for Safari history and if I recall correctly macOS Notes app too.

Apple built Core Data on top of sqlite. There are probably a lot more Apple apps using it than just Safari and Notes.

https://developer.apple.com/documentation/coredata/

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

ahh that explains it, very good to know, thank you.

iMessage too

> Flame is a malware spy program that is reported to make heavy use of SQLite.

Maybe we need an /infamous.html page

Reply on news.ycombinator.com