Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact | Security Implementation Guide

<p>In this episode of Scaling Postgres, we discuss PostgreSQL as the DBMS of the year, running better data migrations, the impact of idle connections and a security implementation guild.</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://db-engines.com/en/blog_post/85">https://db-engines.com/en/blog_post/85</a><br /> <br /> <a href= "https://medium.com/doctolib/stop-worrying-about-postgresql-locks-in-your-rails-migrations-3426027e9cc9"> https://medium.com/doctolib/stop-worrying-about-postgresql-locks-in-your-rails-migrations-3426027e9cc9</a><br /> <br /> <a href= "https://aws.amazon.com/blogs/database/resources-consumed-by-idle-postgresql-connections/"> https://aws.amazon.com/blogs/database/resources-consumed-by-idle-postgresql-connections/</a><br /> <br /> <a href= "https://aws.amazon.com/blogs/database/performance-impact-of-idle-postgresql-connections/"> https://aws.amazon.com/blogs/database/performance-impact-of-idle-postgresql-connections/</a><br /> <br /> <a href= "https://www.depesz.com/2021/01/08/how-to-limit-rows-to-at-most-n-per-category-fix/"> https://www.depesz.com/2021/01/08/how-to-limit-rows-to-at-most-n-per-category-fix/</a><br /> <br /> <a href= "https://info.crunchydata.com/blog/announcing-the-crunchy-data-postgresql-stig"> https://info.crunchydata.com/blog/announcing-the-crunchy-data-postgresql-stig</a><br /> <br /> <a href= "https://www.percona.com/blog/2021/01/04/postgresql-database-security-what-you-need-to-know/"> https://www.percona.com/blog/2021/01/04/postgresql-database-security-what-you-need-to-know/</a><br /> <br /> <a href= "https://fluca1978.github.io/2021/01/03/PostgreSQLSingleUserModeP.html"> https://fluca1978.github.io/2021/01/03/PostgreSQLSingleUserModeP.html</a><br /> <br /> <a href= "https://info.crunchydata.com/blog/using-r-in-postgres-for-logistic-regression-modeling-1"> https://info.crunchydata.com/blog/using-r-in-postgres-for-logistic-regression-modeling-1</a><br /> <br /> <a hr