Entity-Attribute-Value Design, JSON Subscripting, mysql-fdw Push-down, New Regex | Scaling Postgres 193
In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate pushdowns and new regex functions in PG 15.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.cybertec-postgresql.com/en/entity-attribute-value-eav-design-in-postgresql-dont-do-it/ https://blog.logrocket.com/whats-new-json-postgresql-v14/
https://www.enterprisedb.com/blog/aggregate-push-down-mysqlfdw
https://www.depesz.com/2021/11/26/waiting-for-postgresql-15-add-assorted-new-regexp_xxx-sql-functions/
https://blog.crunchydata.com/blog/using-timescaledb-extension-with-the-pgo-the-postgres-operator
https://www.highgo.ca/2021/11/27/how-to-run-a-specific-regression-test/
https://postgresql.life/post/pavel_luzanov/
Create your
podcast in
minutes
It is Free