Postgres

The configuration of PostgreSQL databases, and building the queries to run against them.

Psycopg2: Postgres & Python the Old Fashioned Way

Managing Postgres Database connections in Python with Psycopg2

Last time we met, we joyfully shared a little tirade about missing out on functionality provided to us by libraries such as SQLAlchemy, and the advantages of interacting with databases where ORMs are involved. I stand by that sentiment, but I’ll now directly contradict myself by sharing some tips on using vanilla Psycopg2 to interact with databases.

We never

Postgres Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Jan 15
Read

Postgres as a Google Cloud Service

Deep Dive into Cloud SQL and its out-of-the-box API

Well folks, I have a confession to make. I've been maintaining an affair with two lovers. That's right; they're none other than Postgres, and Google Cloud. While such polygamy may be shunned by the masses, I believe that somehow, some way, we can just make this menage a trois work. What entices me about Cloud SQL is the existence of

Google Cloud Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Aug 10
Read