As a sysadmin mostly used to the nice and powerful way Postgres manages dates, every time i’ve had to do stuff on SQLite i find myself missing that. Feels like they offloaded that into whatever code connects to the database instead of handling it at DB level.
Is there a way to give SQLite the powerful and reliable date management Postgres has, or at least something similar? Hopefully something as devoid of dependency hell as SQLite itself is
Nowhere as convenient as using
psqlbut you could try using Python or Perl to have a more civilised interaction w/ SQLite. For Python the modulesqlite3is already in the stdlib and for Perl just installperl-DBD-sqliteusing your package manager.