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

help-circle

  • obviously it depends on your requirements but what I meant was you can’t compare them at the DB level within queries… you have to pull the data out into your application layer to use your date library.

    The problem there is you effectively need to grab more data than you need to answer queries like “which record has the most recent date” or “give me all the records between the values of the result of this subquery”. it can quickly become a massive bottleneck and may even prevent you from doing certain types of queries at all due to memory limitations.