3 ms·
Why? Now I have to learn a crappier version of SQL (no support for real date types, no user management, etc) and heaven help me if my toy project actual gets tr
by 3pt14159 10y ago
Why? Now I have to learn a crappier version of SQL (no support for real date types, no user management, etc) and heaven help me if my toy project actual gets traction. I'll have to migrate everything over to Postgres or I'll have to keep my DB on a single server because it's just a single file.
Compared to just using Postgres or even MySQL I do not understand the benefit. It takes less than an hour to spin up a PG database with user permissions and migrations to make tables and indexes.
- rch 10y agoSQLite provides date and time functions for working with e.g. ISO8601 strings, but I understand where you're coming from. https://www.sqlite.org/lang_datefunc.html https://www.sqlite.org/lang_datefunc.html https://www.sqlite.org/datatype3.html#section_2_2 https://www.sqlite.org/datatype3.html#section_2_2