Value of SQL, Window Functions, DB Migrations, Data Storage | Scaling Postgres 51
In this episode of Scaling Postgres, we review articles covering the value of SQL, window functions, scaling database migrations and efficient data storage.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.youtube.com/watch?v=eZhSUXxfEu0
http://www.craigkerstiens.com/2019/02/12/sql-most-valuable-skill/
https://blog.jooq.org/2019/02/14/how-to-calculate-a-cumulative-percentage-in-sql/
https://modern-sql.com/blog/2019-02/postgresql-11
https://benchling.engineering/move-fast-and-migrate-things-how-we-automated-migrations-in-postgres-d60aba0fc3d4
https://azure.microsoft.com/en-us/blog/performance-best-practices-for-using-azure-database-for-postgresql-connection-pooling/
https://info.crunchydata.com/blog/how-your-postgresql-data-model-affects-storage
https://fosdem.org/2019/schedule/event/whats_new_in_postgresql_11/
https://fosdem.org/2019/schedule/track/databases/
https://www.youtube.com/watch?v=lgzXuFQ0Pbk
https://www.youtube.com/watch?v=NGcV30hrU5k
https://www.youtube.com/watch?v=uSEXTcEiXGQ
https://www.youtube.com/watch?v=02P_09egiVk
https://www.youtube.com/watch?v=059NNng5BUQ
https://thebuild.com/blog/2019/02/11/whats-up-with-set-transaction-snapshot/
https://severalnines.com/blog/overview-index-changes-postgresql-11
Create your
podcast in
minutes
It is Free