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 solve the common task of retrieving data from a database. The sequence will look something like:

  • Connect to the database
Read

MySQL, Google Cloud, and a REST API that Generates Itself

Deploy a MySQL database that auto-creates endpoints for itself.

It wasn’t too long ago that I haphazardly forced us down a journey of exploring Google Cloud’s cloud SQL service. The focus of this exploration was Google’s accompanying REST API for all of its cloud SQL instances. That API turned out to be a relatively disappointing administrative API which did little to extend the features you’d

MySQL Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Oct 23
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

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 this way. Unless you're getting deep into some heavy architecture, most people opt to use cloud services such as AWS

MySQL Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Apr 30
Read

Accessing Self-Hosted MySQL Externally

Connecting to MySQL instances hosted on a VPS

In the previous post we got familiar with the basics of creating and navigating MySQL databases. This leads us to the next most logic thing to ask: how can I use this in any meaningful way?

MySQL installations default to refusing connections outside of the local machine's IP address, as we should expect. That said, relational databases aren't usually being

MySQL Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
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 repetitive command-line interactions with databases, thus making any service's one-click-deploy button all the more sensible.  If I  had to imagine

MySQL Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Apr 17
Read