PHP MySQL script to create table, insert test entries

Sometimes I need to set up a database/table in MySQL for just testing a few things, and its not that easy to do manually (especially for a large number of entries). So I wrote a quick PHP script to actually do this work for me.

YAML to MySQL (yaml2sql) Script in PHP

I often find myself having to prototype code and create database tables that I restructure often. I needed a tool to quickly generate MySQL database table structures without my having to manually write the CREATE TABLE statements myself.

Creating & Shutting Down Amazon RDS MySQL Instances – AWS SDK & PHP

I have to sometimes automatically stand up (create) and shut down temporary MySQL instances in order to run some scripts and commands on them. Instead of having to keep an instance running forever, I was able to make sure of Amazon’s RDS service for cloud MySQL instances, using its AWS SDK in PHP.