3 ms·

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

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.

roblh 3y ago
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.
- throwaway2037 3y ago
  Hat tip to both the amazing native JSON support from Postgres, and the SQLite module with JSON functions: https://www.sqlite.org/json1.html https://www.sqlite.org/json1.html