
Scaling Postgres Episode 193 Entity-Attribute-Value Design | JSON Subscripting | mysql-fdw Push-down | New Regex
Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate push-down and new regex functions in PG 15.
Content Discussed
- Entity-attribute-value (EAV) design in PostgreSQL – don’t do it!
- What’s new with JSON in PostgreSQL v14
- Aggregate Push-down in mysql_fdw
- Waiting for PostgreSQL 15 – Add assorted new regexp_xxx SQL functions.
- Using TimescaleDB with PGO, the open source Postgres Operator
- How to run a specific regression test
- Pavel Luzanov