Hacker News Reader

The main issue with SQLite is the very poor type system, after testing it for an app I was shocked.

Are you saying that STRICT was insufficient for you? What more did you want beyond one of: INT, INTEGER, REAL, TEXT, BLOB, ANY?

Want SQL-92 standard DATE/TIME/TIMESTAMP.

Can't those be stored as integers with a desired resolution?

No data integrity, No automatic formatting, No timezone support, No standard date functions, etc

You can mitigate this with decent bindings, but I agree it's not ideal.