10 Things Developers Love To Hate About SQLite Databases

SQLite has a giant list of quirks and “gotchas” that have made PostgreSQL “the champion.” Here’s what you need to know.

Photo by Galina Nelyubova on Unsplash

I read this great Reddit comment about SQLite vs. PostgreSQL, where a smart developer is listing out every thing he doesn’t like about SQLite.

“[1] SQLite is flexible with regard to datatypes. Datatypes are advisory rather than mandatory.😒

[2] No Separate BOOLEAN Datatype😒

[3] No Separate DATETIME Datatype😱

[4] Foreign Key Enforcement Is Off By Default😱

[5] PRIMARY KEYs Can Sometimes Contain NULLs😞

[6] Does Not Do Full Unicode Case Folding By Default😞

[7] Keywords Can Often Be Used As Identifiers🥴

[8] Dubious SQL Is Allowed Without Any Error Or Warning😒

[9] AUTOINCREMENT Does Not Work The Same As MySQL😞