3 ms·
SQLite is magical and incredibly lean, but it is not leaner than Postgres if you need real database features. You end up reimplementing a lot of features in cod
by scrollaway 4y ago
SQLite is magical and incredibly lean, but it is not leaner than Postgres if you need real database features. You end up reimplementing a lot of features in code that belong in the db.
- simonw 4y agoWhat kind of features are you talking about here? This doesn't match my experience from the last few years. SQLite in WAL mode is extremely capable. The only thing I really miss from PostgreSQL is that PostgreSQL has more built-in functions for things like date handling - but SQLite custom functions are very easy to register when you need them.
- scrollaway 4y agoConstraints and validation for example. Efficient json store. Etc
- simonw 4y agoSQLite has check constraints - and recent versions can have STRICT tables: https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html It also has excellent JSON features - JSON maybe stored as text rather than a binary format like JSONB in PostgreSQL, but the SQLite JSON functions crunch through it at multiple GBs per second so it doesn't seem to matter.
- deleted 4y ago[deleted]
- scrollaway 4y agoDidn't know about strict tables, very cool!