2 ms·
What 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
by simonw 4y ago
What 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!