SQL

Configure Relational databases, brush up on your query languages, or find third-party services to supercharge your data.

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

Pythonic Database Management with SQLAlchemy

The iconic Python library for handling any conceivable database interaction.

Something we've taken for granted thus far on Hackers and Slackers is a library most data professionals have accepted as an undisputed standard: SQLAlchemy.

In the past, we've covered database connection management and querying using libraries such as PyMySQL and Psycopg2, both of which do an excellent job of interacting with databases just as we'd expect them to. The nature

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

A Dirty Way of Cleaning Data (ft. Pandas & SQL)

Code Snippet Corner ft. Pandas & SQL

Warning The following is FANTASTICALLY not-secure.  Do not put this in a script that's going to be running unsupervised.  This is for interactive sessions where you're prototyping the data cleaning methods that you're going to use, and/or just manually entering stuff.  Especially if there's any chance there could be something malicious hiding in the data to be uploaded.  We're

Pandas Matthew Alhonte avatarMatthew Alhonte Matthew Alhonte avatar
mattJan 15
Jul 16
Read

Using PyMySQL: Python's MySQL Library

Lightweight Python library to interact with MySQL

It's almost Friday night, and the squad at H+S is ready to get cooking. Dim down the lights and slip into something more comfortable as we take you on this 100% organic flavor extravaganza. Tonight's menu? A Python MySQL library: PyMySQL.

PyMySQL is lightweight and perfect for fulfilling MySQL queries. If you want bells and whistles, you're probably barking

Python Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Jun 15
Read