Hackers and Slackers: Data Science for Badasses

SQL

10 Posts
Interacting with data the real way.

Cloud SQL Postgres on GCP

Diving 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 the Cloud SQL API , which generates predictable REST endpoints for presumably reading and writing to your database. Please allow a

Google Cloud Author imageTodd Birchard August 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 going to be executing formatted strings of SQL unsanitized code.  Also, this will lead to LOTS of silent failures, which

Pandas Author imageMatthew Alhonte July 16
Read

Using PyMySQL

MySQL with Python

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 up the wrong tree (and you probably should’ve used a DB other than MySQL in the first place).

Why

Python Author imageTodd Birchard June 15
Read

Lynx Roundup, June 15th

Cool things for cool animatronic devices

https://towardsdatascience.com/embedding-machine-learning-models-to-web-apps-part-1-6ab7b55ee428

https://www.manning.com/books/exploring-data-with-python

https://www.citusdata.com/blog/2018/06/01/fun-with-sql-window-functions-in-postgresql/

https://lispcast.com/avoid-naming-at-all-costs/

Roundup Author imageMatthew Alhonte June 15
Read

Accessing MySQL Externally

MySQL pt 2

In the previous post we got familiar with the basics of creating and navigating MySQL databases. Now we'll look into how to open a database up to be modified from another domain.

As you already know, doing anything across domains is kind of a pain in the ass the first time around. This typically means making configuration changes to the service or webserver you're running which is attempting to stop you from doing exactly what you're doing: making your server

MySQL Author imageTodd Birchard April 22
Read

Setting up a MySQL Database

MySQL pt 1

As frameworks evolve and our tools remove us further and further away from boilerplate code, the intricacies of setting up and interacting with databases has become mostly a casualty. This may be for good reason, as I can't imagine why anybody would become adept at the one-off processes behind creating or interacting with a data environment.

Look, I'm not exactly an expert at setting up databases. Chances are a lot of us aren't considering we have plenty of tools to

DevOps Author imageTodd Birchard April 17
Read