Hackers and Slackers

MySQL

Database configuration, building queries, and cloud hosting options for MySQL.

Create a REST API Endpoint Using AWS Lambda

Use Python and MySQL to Build an Endpoint

Now that you know your way around API Gateway, you have the power to create vast collections of endpoints. If only we could get those endpoints to actually receive and return some stuff.

We'll create a GET function which will

AWS Author imageTodd Birchard Author imagetodd Oct 29
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

Python Author imageTodd Birchard Author imagetodd Jun 15
Read

MySQL on the Cloud with AWS RDS

Spinning up a standalone MySQL Database with Amazon

Last time we became familiar with the handiwork of setting up MySQL locally, navigating databases via command line, and exposing your database to external access. While badass, it has come to my attention that most people don't bother doing things

MySQL Author imageTodd Birchard Author imagetodd Apr 30
Read

Accessing MySQL Externally

For those with self-hosted MySQL instances

In the previous post we got familiar with the basics of creating and navigating MySQL databases. The next most common thing to ask might be "great, but how can I use this in any meaningful way?"

MySQL installations

MySQL Author imageTodd Birchard Author imagetodd Apr 22
Read

Setting up a MySQL Database on Ubuntu

Setting up MySQL the old-fashioned way: on a Linux server

As frameworks and services evolve to remove us further away from boilerplate code, the first casualty of saved time is the fundamental understanding of what we're actually doing sometimes. This has good reason; one can only learn so much from

MySQL Author imageTodd Birchard Author imagetodd Apr 17
Read