insertnicknameon Hacker News • Recommends
On “PG Casts – Postgres Screencasts”
For this, I highly recommend this tutorial by Christophe Pettus from PyCon: link to this video It covers the basics of setting up Postgres as well as other things.
0:00 / 0:00
Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016
PyCon 2016
15K subscribers • 8 videos on Hallway
- Recommended by 3 people: 3 on Hacker News.
- Presented by Christophe Pettus
- Linked in the descriptionPyCon/2016-slides
- May be out of date. The tools, versions or practices it shows have likely moved on.
Intermediate. Assumes working knowledge.
7.8K views10 years ago3 recommendations
Databases and dataProgramming languagesPostgresPythonDatabase internals
Christophe Pettus provides a comprehensive orientation to PostgreSQL for Python developers, covering installation, administration, MVCC, vacuuming, and replication.
Speaker: Christophe Pettus PostgreSQL has become the default database for most green-field development projects, and is the data storage architecture behind many major Python-based success stories, such as Instagram. Despite a reputation as being complex and fiddly, Postgres is easy to install, administer, maintain, and use... with just a little bit of orientation. This is that orientation. Slides can be found at: speakerdeck.com/pycon2016 and github.com/PyCon/2016-slidesWhy it's here
3 people recommend thisWhat people say. Recommended as an excellent, practical introduction to PostgreSQL basics, optimization, and administration for developers.
elmigrantoon Hacker News • Recommends
On “Things I Hate About PostgreSQL (2013)”
I found this to be great introductory that touches on all the major points to keep in mind with Postgres. It's pretty up-to-date too! link to this video It isn't quite what you ask for, but should be enough to get you high-level overview of major systems and contains solid practical advices (on vacuuming, mvcc, replication, backups, etc…), so you know what to google for deeper understanding.
ceyhunkazelon Hacker News • Recommends
On “Practical Guide to PostgreSQL Optimizations”
I recommend following Christophe Pettus - PostgreSQL Proficiency for Python People - PyCon 2016 video for postgresql basics and optimization link to this video