logoalt Hacker News

wewewedxfgdftoday at 7:58 AM1 replyview on HN

I would visit lobste.rs more if it filtered out stories that are on Hacker News.

I'm not interested in a rehash of Hacker News but I am interested in more tech news.

Anyhow on topic: I find it puzzling the whole "use sqlite in production!" thing.

- you're stuck on a single machine now.

- you don't have remote database access.

- you have to live with the inflexibility of sqlite's schema change capability.

- all writes go through a single writer.

- fewer data types

- fewer backup/security/high availability options

- foreign keys and strict disabled by default.

- you're single core in a multi core world.

It's not a terrible decision but when you can choose Postgres, why would you go with sqlite?


Replies

simonsantoday at 8:30 AM

A single page answers that question: https://www.sqlite.org/whentouse.html