SQLite is not SQL standards compliant. It doesn't even support data types from c... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		lenkite on July 18, 2024 \| parent \| context \| favorite \| on: How we sped up Notion in the browser with WASM SQL... SQLite is not SQL standards compliant. It doesn't even support data types from core SQL-92. One needs more than INTEGER, REAL, TEXT, BLOB for applications. Adopting it as WebSQL would have been a terrible mistake.

AntonCTO on July 18, 2024 [–]

Is IndexedDB SQL standards compliant? Inventing IndexedDB is a terrible mistake.

lenkite on July 19, 2024 | [–]

Fully agreed. Lets not compound a mistake with another mistake.

resonious on July 19, 2024 | | [–]

Fair enough. But if I could pick just one mistake, I'd pick SQLite.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact