• 2 Posts
  • 19 Comments
Joined 1 year ago
cake
Cake day: June 10th, 2023

help-circle









  • Nothing specific, but Postgres date management is really, really useful, i can do a query on a date, parts of a date, timestamps, compare dates and times, intervals, all sorts of powerful operations. SQLite seems to have none of that, the date seems like a courtesy item added later as an afterthought because somebody asked or something, it has absolutely none of that, and when i have to do things with it it’s painful, relying on doing operations on the Unix epoch of dates for most stuff because the dates themselves are not really usable. Was hoping somebody else had done something to improve on this but doesn’t look like it.