Database Playground Series

I met the US Census for 1990 and fell in love, it’s a plethora of data that I can toss into some MySQL database tables and play with. I’ll walk you through the major steps and you can just grab whatever information is relevant to your needs. At the end I’ll provide a dump of all the files and MySQL table data for you to play with on your server.

US Census Data as a MySQL Database Playground


Somehow I ended up at the 1990 US census and I realized what a valuable data resource it is! All kinds of data that I can use to make a well structured MySQL playground to test new scripts and ideas on.

Popularity: 13% [?]

Populating the Regions, Divisions and States MySQL Tables


The relationships between states, divisions and regions are simple but need to be setup properly from the start. Here we’ll walk though the setup.

Popularity: 17% [?]

MySQL Queries Made Easy With PHP Functions Library


Every web developer has a library of code that they reference frequently, if not constantly. I’m sharing with you one of my most useful snippets my MySQL helper class that helps me organize my queries and easily reference commonly used functions.

Popularity: 50% [?]

Database Playground - Temporary Hiatus


Database Playground is on a temporary hiatus but it will be back as soon as I can catch up on some of the posts I need to write!

Popularity: 11% [?]

Making MySQL Update and Insert Easier


An addition to our PHP/MySQL Query class created last month now we have quick and organized ways to maintain our MySQL INSERT and UPDATE queries.

Popularity: 54% [?]