from Hacker News

Ask HN: Why does SQLite (in production) have such a bad rep?

by rrmdp on 6/19/24, 10:12 PM with 9 comments

• by fendale on 6/20/24, 1:40 PM

  Over the last few months I have been seeing a push toward using Sqlite in production, where appropriate. Some of this has been coming from 37 Signals with their "Once" products, which use Rails and a SqliteDB.

  Sqlite can go pretty far if you have fast SSD disk. The biggest problem is that your app is constrained to a single host. For many apps, with backups and a failover plan, that may be OK. For other its a non starter.

• by brauhaus on 6/26/24, 9:25 AM

  I know SQLite is popular with no-backend native mobile apps BUT I read somewhere it's not safe: if a malicious app is granted the ability to read your phone files, it can access the data from the SQLite of other apps.

  Can anyone confirm (or deny) this to me?

• by moomoo11 on 6/19/24, 11:44 PM

  I think a lot of people use it for the wrong use case, and then people who don't fully understand many things propagate malinforation after misinterpreting the article and its findings/learnings.

• by stop50 on 6/19/24, 10:45 PM

  It has a bad rep? Then Why do i see sqlite so often in different products?

• by AA-BA-94-2A-56 on 6/20/24, 9:50 PM

  SQLite is excellent at on-dick storage, but why would you use it in lieu of PostgreSQL? It seems less scalable.

• by jarsin on 6/19/24, 10:50 PM

  Cause it has to be accessed by disk protocols which are slow over the network is my guess. As you have to scale to more than one machine then you lose the convience of sqlite.