Follow

Time I once again asked the question, "this year what are the differences between and ?" Extensibility is a huge one (so you can program addons to Postgres but not MySQL). and also this thing called Materialized Views. postgresql.org/docs/9.3/rules-

It looks like you can take snapshots of the data at a certain point. A full-blown XTDB it's not, but that could be useful.

@worldsendless mysql ironically powers most of the torment nexus though. twitter, facebook, youtube, ...

yes a materialized view is basically a copy of a table and all of its data with an easy way to trigger it be regenerated.
@worldsendless it's from a joke that goes something like

'tech companies announced we created the torment nexus form the book "dont create the torment nexus"'
Sign in to participate in the conversation
Qoto Mastodon

QOTO: Question Others to Teach Ourselves
An inclusive, Academic Freedom, instance
All cultures welcome.
Hate speech and harassment strictly forbidden.