1. 43
  1. 3

    I miss things like date and timestamptz (and their related functions/operations) the most, when using sqlite instead of postgresql. I’m sure there are a lot of solutions in different libraries/language bindings, but having it in the core would be a nice boon in terms of having actual types (yes, I realize my feature wishlist is growing here), accessing/modifying the same db from different languages, probably be optimally implemented etc.

    1. 1

      SQLite has now shipped the ‘strict tables’ feature, which means strong types are available. https://www.sqlite.org/draft/stricttables.html

      1. 3

        Sorry that I was unclear. I meant “actual types [for date & time]”, rather than https://www.sqlite.org/datatype3.html#date_and_time_datatype. For example, postgres’ timestamp with time zone

    2. 1

      I was surprised when I realised that SQlite doesn’t have much to offer in terms of regex by default (mostly replace & extract are missing).

      1. 2

        True, although it’s dead simple to add this functionality with Python or your favorite language – see for example https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_function