So today I did something fun. I wrote a script to parse out data from a CSV file and push the various data into several different (and mostly unrelated) tables in theRead More…
Today I was working on setting up a MySQL backup/failover for our Identity Management servers and needed to install some additional MySQL Utilities to make it work. I downloaded the files toRead More…
I normally use the PHP PDO to retrieve data from a MySQL database, and then convert the data to JSON after calling $statement->fetchAll(PDO::FETCH_ASSOC). This has worked well for me, and each rowRead More…
The Requirements Our library has several electronic resources that have stipulations on who may access that information. Some are restricted to Alumni, others to people on campus, and others to faculty andRead More…
Just recently the library at the school where I work asked me to write a web application so that they could more easily manage their electronic resources. The resources they were trackingRead More…
I just ran across this post (via Planet Mysql) at Flite Mechanics. Apparently you can now use common_schema to parse JSON directly. Now there’s no more need to run your JSON throughRead More…
Here’s a nice tutorial for the MySQL Workbench. I’ve used this tool quite a bit, but didn’t realize – or overlooked – many of the additional features that this tool provides. OfRead More…
Here’s an interesting tutorial about Scaling MySQL for Developers that I ran across at Johathan Levin’s blog. It touches on indexing, troubleshooting, and table optimization, as well as a lot more, butRead More…
Nice comic from XKCD.
Head on over to MySQL to watch this webinar. You’ll need to register in order to view it, so if you really don’t like leaving your email, this may not be forRead More…