4 ms·
Yeah, it was bad. What kills me is SQLite has its own absurd set of gotchas [0] yet is seen as amazing and wonderful by devs. PKs can have NULLs? Sure! Strings
by sgarland 2y ago
Yeah, it was bad. What kills me is SQLite has its own absurd set of gotchas [0] yet is seen as amazing and wonderful by devs. PKs can have NULLs? Sure! Strings can have \0 in the middle of them? Why not? FKs aren’t enforced by default? Yeah, who needs referential integrity, anyway?
My only conclusion is that the majority of devs don’t actually read documentation, and rely purely on the last blog post they read to influence their infrastructure decisions.
[0]: https://www.sqlite.org/quirks.html https://www.sqlite.org/quirks.html
- hu3 2y agoUnderstanding and memorizing shortcomings and quirks takes time and effort. Most devs just go with whatever the influencer du jour says is good. "Nobody ever got fired for choosing insert_currently_hyped_tech_here"