MySQL

Mostly database snippets.

Redshift and MySQL's giant list of datetime / timestamp functions

Redshift and MySQL's giant list of datetime / timestamp functions

How to find Redshift current date and other common expressions for working with date, time, datetime, and timestamp columns in MySQL 5.7.x and Redshift.

Sep 8, 2018
Using Python enums in SQLAlchemy models

Using Python enums in SQLAlchemy models

How to use enums in your models to enforce value consistency.

May 16, 2018
Bash script to relink alembic migrations

Bash script to relink alembic migrations

Sick of `alembic merge heads` slowing down your builds? Here's a short bash script I wrote to rename your migration files and update its down revision.

Jun 12, 2017
Bash script to monitor instances and MySQL

Bash script to monitor instances and MySQL

A simple Bash script to check multiple server instances are responding, and rows are being added to a MySQL database.

Nov 11, 2015
Made with JoyBird