JSONB vs. Window Functions, Security Checklist, Full-Text Search, NFL Time-Series | Scaling Postgres 176
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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://swarm64.com/post/postgresql-jsonb-vs-window-functions/
https://www.cybertec-postgresql.com/en/postgresql-security-things-to-avoid-in-real-life/
https://blog.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database
https://blog.timescale.com/blog/hacking-nfl-data-with-postgresql-timescaledb-and-sql/
https://ardentperf.com/2021/07/26/postgresql-logical-replicas-and-snapshots-proceed-carefully/
https://www.pgmustard.com/blog/max-parallel-workers-per-gather
https://fluca1978.github.io/2021/07/27/pgbackrestAsync.html
https://b-peng.blogspot.com/2021/07/deploying-pgpool2-exporter-with-docker.html
https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/
https://postgresql.life/post/roman_druzyagin/
https://www.rubberduckdevshow.com/episodes/6-handling-exceptions/
Create your
podcast in
minutes
It is Free