1. 49
  1.  

  2. 31

    Finally, we have STRICT tables, which brings type safety to SQLite!

    1. 5

      That was my excitement source as well. I hope the datetime types get added soon - it looks like they’re not supported yet.

      1. 1

        In order to continue supporting this ability, even in STRICT tables, the new ANY datatype name is introduced. When the datatype of a column is “ANY”, that means that any kind of data - integers, floating point values, strings, or binary blobs, can be inserted into that table and its value and datatype will be preserved exactly as it is inserted. As far as we know, SQLite is the only SQL database engine that supports this advanced capability.

        Can’t help but think “anti-pattern” here. And find the tone of it oddly smug.

        Certainly a welcome feature when used responsibly nonetheless!