Sysadmin

5587 readers

1 users here now

A community dedicated to the profession of IT Systems Administration

founded 5 years ago

MODERATORS

[email protected]

PostgreSQL vs SQLite date management (kbin.social)

submitted 1 year ago by [email protected] to c/[email protected]

3 comments fedilink hide all child comments

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

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 7 points 1 year ago

Nowhere as convenient as using psql but you could try using Python or Perl to have a more civilised interaction w/ SQLite. For Python the module sqlite3 is already in the stdlib and for Perl just install perl-DBD-sqlite using your package manager.