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.
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.
SQLite has now shipped the ‘strict tables’ feature, which means strong types are available. https://www.sqlite.org/draft/stricttables.html
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
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).
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