Lateral Joins, Generating JSON, dbcritic, Fetch First Rows | Scaling Postgres 174
In this episode of Scaling Postgres, we discuss understanding lateral joins, generating JSON with Postgres, the dbcritic utility, and fetch first rows vs. limit.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.cybertec-postgresql.com/en/understanding-lateral-joins-in-postgresql/
https://blog.crunchydata.com/blog/generating-json-directly-from-postgres
https://www.channable.com/tech/dbcritic-constructively-criticizing-your-postgres-schema
https://www.cybertec-postgresql.com/en/postgresql-limit-vs-fetch-first-rows-with-ties/
https://elephanttamer.net/?p=58
https://www.youtube.com/watch?v=znPL6iDDou8
https://fluca1978.github.io/2021/07/13/PostgreSQLWalTraffic.html
https://www.postgresql.fastware.com/blog/improved-logging-by-libpq-in-postgresql-14
https://www.highgo.ca/2021/07/14/first-contact-with-the-pg_filedump/
http://amitkapila16.blogspot.com/2021/07/logical-replication-of-in-progress.html
https://postgresql.life/post/jean-christophe_arnu/
https://www.rubberduckdevshow.com/episodes/4-pair-programming-when-why-how/
Create your
podcast in
minutes
It is Free