Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016
What it is
A three-hour PyCon 2016 tutorial by Christophe Pettus that orients Python developers to PostgreSQL. It covers installation, administration, and use, including vacuuming, MVCC, replication and backups.
Why Hacker News recommends it
HN readers recommend it as a thorough, practical introduction to Postgres fundamentals and optimization for application developers.
- 3 people recommended it
- 3 different months
- 2 strong recommendations
- first 2016, last 2016
What HN commenters said
“I highly recommend this tutorial by Christophe Pettus from PyCon”
Covers the basics of setting up Postgres and more.
insertnickname, 2016-06 · Strong recommendation · in “PG Casts – Postgres Screencasts”
“I found this to be great introductory that touches on all the major points to keep in mind with Postgres.”
Great, up-to-date introduction covering vacuuming, MVCC, replication, and backups.
elmigranto, 2016-09 · Strong recommendation · in “Things I Hate About PostgreSQL (2013)”
“I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization”
PostgreSQL basics and optimization.
ceyhunkazel, 2016-08 · Recommendation · in “Practical Guide to PostgreSQL Optimizations”
Excerpts from Hacker News comments, linked to the originals. Summaries and labels were written by a language model from those comments.
Topics: postgresql, mvcc, vacuum, replication, python, databases
Also recommended by the same people
talk"Testing Distributed Systems w/ Deterministic Simulation" by Will WilsonStrange Loop Conference · 12 HN recommenders · 2014–2024
talkThe Value of Values with Rich HickeyInfoQ · 10 HN recommenders · 2014–2023
talkAWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)Amazon Web Services · 12 HN recommenders · 2019–2025
talk"Turning the database inside out with Apache Samza" by Martin KleppmannStrange Loop Conference · 9 HN recommenders · 2015–2025
talkConflict Resolution for Eventual Consistency • Martin Kleppmann • GOTO 2016GOTO Conferences · 3 HN recommenders · 2017–2020
lecture01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)CMU Database Group · 6 HN recommenders · 2020–2023
talkIntroduction to NoSQL • Martin Fowler • GOTO 2012GOTO Conferences · 6 HN recommenders · 2015–2021
talkRich Hickey rants about HttpServletRequest in 1080p: Death By Specificity from Clojure Made SimpleFred Overflow · 5 HN recommenders · 2020–2026