4 ms·
SQLite's lack of type safety makes me hesitate to use it as a drop-in replacement for Postgres.
by lukeschlather 5y ago
SQLite'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