News for hackers. Stuff that matters.
Re:Lessons Learned from 11 Years of Hosting a SaaS by mejutoco on Thursday June 15, 2023 @05:34AM (#36338191)
I agree with you about the worse type system not being a feature. Also missing the json features of postgres is inconvenient.

Only one file to backup or deploy is the biggest advantage of sqlite IMO.

Re:Lessons Learned from 11 Years of Hosting a SaaS by roblh on Thursday June 15, 2023 @08:41AM (#36339643)
It may not quite have all of the JSON features of Postgres, but recently the JSON handling has become way more usable in SQLite. More than usable for sure.
Re:Lessons Learned from 11 Years of Hosting a SaaS by throwaway2037 on Thursday June 15, 2023 @09:02AM (#36339840)
Hat tip to both the amazing native JSON support from Postgres, and the SQLite module with JSON functions: https://www.sqlite.org/json1.html