2 ms·
Even foreign keys weren't available before 2009, and are still not enabled by default: https://sqlite.org/foreignkeys.html https://sqlite.org/foreignkeys.html
by Rendello 3mo ago
Even foreign keys weren't available before 2009, and are still not enabled by default:
https://sqlite.org/foreignkeys.html https://sqlite.org/foreignkeys.html
- akoboldfrying 3mo agoThanks, I've been using SQLite for a while and I did not realise that FKs are disabled by default! Fortunately not on anything critical, still... Yikes.
- Rendello 3mo agoThe SQLite docs have a great "quirks" page [1], which contains this telling quote: > The original implementation of SQLite sought to follow Postel's Law which states in part "Be liberal in what you accept". This used to be considered good design - that a system would accept dodgy inputs and try to do the best it could without complaining too much. More recently, people have come to prefer software that is strict in what it accepts, so as to more easily find errors. > There are now millions of applications that take advantage of SQLite's flexible and forgiving design choices. We cannot change SQLite to follow the current preference toward strict and dogmatic behavior without breaking those legacy applications. 1. https://sqlite.org/quirks.html https://sqlite.org/quirks.html