Episode 176 JSONB vs. Window Functions | Security Checklist | Full-Text Search | NFL Time-Series

<p>In this episode of Scaling Postgres, we discuss JSONB vs. window functions, a Postgres security checklist, implementing full-text search and using NFL timeseries data.</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://swarm64.com/post/postgresql-jsonb-vs-window-functions/">https://swarm64.com/post/postgresql-jsonb-vs-window-functions/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/postgresql-security-things-to-avoid-in-real-life/"> https://www.cybertec-postgresql.com/en/postgresql-security-things-to-avoid-in-real-life/</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database"> https://blog.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database</a><br /> <br /> <a href= "https://blog.timescale.com/blog/hacking-nfl-data-with-postgresql-timescaledb-and-sql/"> https://blog.timescale.com/blog/hacking-nfl-data-with-postgresql-timescaledb-and-sql/</a><br /> <br /> <a href= "https://ardentperf.com/2021/07/26/postgresql-logical-replicas-and-snapshots-proceed-carefully/"> https://ardentperf.com/2021/07/26/postgresql-logical-replicas-and-snapshots-proceed-carefully/</a><br /> <br /> <a href= "https://www.pgmustard.com/blog/max-parallel-workers-per-gather">https://www.pgmustard.com/blog/max-parallel-workers-per-gather</a><br /> <br /> <a href= "https://fluca1978.github.io/2021/07/27/pgbackrestAsync.html">https://fluca1978.github.io/2021/07/27/pgbackrestAsync.html</a><br /> <br /> <a href= "https://b-peng.blogspot.com/2021/07/deploying-pgpool2-exporter-with-docker.html"> https://b-peng.blogspot.com/2021/07/deploying-pgpool2-exporter-with-docker.html</a><br /> <br /> <a href= "https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/"> https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/</a><br /> <br /> <a href= "https://postgresql.life/post/ro