Hacker News new | ask | show | jobs
by tfigment 1859 days ago
MySQL and mariadb have first class temporal tables. Pg has compile requirement and so cannot use in AWS RDS.
3 comments
lowercased 1859 days ago
I was aware maria had temporary tables, but not mysql proper. Any links you can point me to? Every search is coming up with 'temporary' table info, not temporal.
link
dragonwriter 1859 days ago
> MySQL and mariadb have first class temporal tables. Pg has compile requirement and so cannot use in AWS RDS.

There’s a pl/pgsql reimplementation of temporal tables specifically for that use case.

link
phonon 1859 days ago
https://news.ycombinator.com/item?id=26768220
link
lowercased 1859 days ago
mysql8 has gis/spatial stuff built in now. may not quite be on par with postgis, but... i also don't have to futz with "doesn't come baked in". Dealt with someone who wrote a whole bunch of lat/lon/spatial stuff in client code because we're on postgres but ... he couldn't get postgis installed (then even if he could, figuring out how to convince the ops people to add a new 'thing' in production would have been a delay).

having stuff baked in is often a win.

link