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.
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.
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. Continue reading