2 ms·

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

• OutOfHere 2mo ago
  Are you saying that STRICT was insufficient for you? What more did you want beyond one of: INT, INTEGER, REAL, TEXT, BLOB, ANY? https://sqlite.org/stricttables.html https://sqlite.org/stricttables.html
  • lenkite 2mo ago
    Want SQL-92 standard DATE/TIME/TIMESTAMP.
    • OutOfHere 2mo ago
      Can't those be stored as integers with a desired resolution?
      • deleted 2mo ago
        [deleted]
      • lenkite 2mo ago
        No data integrity, No automatic formatting, No timezone support, No standard date functions, etc
• DC-3 2mo ago
  You can mitigate this with decent bindings, but I agree it's not ideal.