| 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? |