3 ms·
My understanding is that SQLite tries to maintain compatibility with Postgres in the subset of SQL that it supports. So if this program reaches a reasonable le
by blacksqr 5y ago
My understanding is that SQLite tries to maintain compatibility with Postgres in the subset of SQL that it supports. So if this program reaches a reasonable level of maturity I would love to be able to use it with pre-existing products that were designed to use Postgres as a backend, to substitute SQLite as a drop-in replacement. One might hope that this could work for products that don't use Postgres's more cutting-edge features.
- lukeschlather 5y agoSQLite's lack of type safety makes me hesitate to use it as a drop-in replacement for Postgres.
- benbjohnson 5y agoI wouldn't use SQLite as a drop-in replacement either but, in case you haven't seen it, SQLite did add "strict mode" for better enforcement of type safety: https://sqlite.org/src/wiki?name=StrictMode https://sqlite.org/src/wiki?name=StrictMode
- simonw 5y agoThey fixed that a couple of versions ago: https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html