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

help-circle









  • UNIX time uses a Julian calendar date as a reference, but is independent after that.

    As for the 13 month calendar, it’s about as nice as cloverleaf interchanges: appealing because it’s symmetrical, terrible in practice. Having the days of the month always align to the same weekday means leap years would make things even worse because every 4 years the entire calendar shifts. And if you skip the leap day as a holiday then you just make calculating dates from an epoch like UNIX time even more convoluted.










  • I’ve seen it successfully happen due to licensing costs and cloud migration (MSSQL->Spanner), as well as for scalability reasons (vanilla postgres->cockroach). The first one was a significant change in features, the latter did sacrifice some native plugins. In the first case the company was using vendor specific features, and rewrote the backend to fit the new vendor.

    There’s vendor agnosticism, and then there’s platform agnosticism. Writing your code so that it’s not tied to one specific implementation of postgres is fine, and lets you use a compatible drop-in. Writing your code so you can swap MSSQL for Oracle or Aurora or whatever at will does not make sense. In every case of attempted platform agnosticism I’ve seen they ended up abandoning the project within a year or two with nothing to show for it.