Episode 174 Lateral Joins | Generating JSON | dbcritic | Fetch First Rows

<p>In this episode of Scaling Postgres, we discuss understanding lateral joins, generating JSON with Postgres, the dbcritic utility, and fetch first rows vs. limit.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.cybertec-postgresql.com/en/understanding-lateral-joins-in-postgresql/"> https://www.cybertec-postgresql.com/en/understanding-lateral-joins-in-postgresql/</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/generating-json-directly-from-postgres"> https://blog.crunchydata.com/blog/generating-json-directly-from-postgres</a><br /> <br /> <a href= "https://www.channable.com/tech/dbcritic-constructively-criticizing-your-postgres-schema"> https://www.channable.com/tech/dbcritic-constructively-criticizing-your-postgres-schema</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/postgresql-limit-vs-fetch-first-rows-with-ties/"> https://www.cybertec-postgresql.com/en/postgresql-limit-vs-fetch-first-rows-with-ties/</a><br /> <br /> <a href= "https://elephanttamer.net/?p=58">https://elephanttamer.net/?p=58</a><br /> <br /> <a href= "https://www.youtube.com/watch?v=znPL6iDDou8">https://www.youtube.com/watch?v=znPL6iDDou8</a><br /> <br /> <a href= "https://fluca1978.github.io/2021/07/13/PostgreSQLWalTraffic.html">https://fluca1978.github.io/2021/07/13/PostgreSQLWalTraffic.html</a><br /> <br /> <a href= "https://www.postgresql.fastware.com/blog/improved-logging-by-libpq-in-postgresql-14"> https://www.postgresql.fastware.com/blog/improved-logging-by-libpq-in-postgresql-14</a><br /> <br /> <a href= "https://www.highgo.ca/2021/07/14/first-contact-with-the-pg_filedump/"> https://www.highgo.ca/2021/07/14/first-contact-with-the-pg_filedump/</a><br /> <br /> <a href= "http://amitkapila16.blogspot.com/2021/07/logical-replication-of-in-progress.html"> http://amitkapila16.blogspot.com/2021/07/logical-replication-of-in-progress.html</a><br /> <br /> <a href= "https://postgresql.life/post/jean-christoph