This month’s T-SQL Tuesday blog is brought to us by Todd Kleinhans (b | t) and this month topic is about what you use databases in your personally life. As database professionals if shouldn’t really surprise anybody that we do this after all we love data. I can think of a million ways everyone could be using databases in their personally lives.
I personally have two main databases. One I haven’t touched in awhile is my sports card collection. I have over 50,000 baseball, basketball, and football cards that I put in database years ago and haven’t updated since I haven’t really bought any new cards. I used to spend hours updating the database monthly on the pricing and be able to run queries to tell me how much my collection was worth. My first database for this was created when I was in 7th grade on a program called My Databases (not sure it was a real database) but at least my collection was organized on my MSDOS 3.3 machine and I had a nice floppy disk menu system built to tell which disc to insert to get to the which set of data. Yes I was programming at that age too.
Today I store my fitness data in a database. Yes everything my Garmin watch is recorded including all the exercise I get, like I know I’ve already exercise more time wise this year than I did all last year combined (such a sad state of affairs to speak on last year). I started this when I started running to keep up with my training runs then expanded into to include my triathlon training. Then bought a fancy Garmin watch that tracks so much other stuff and wanted to know who much sleep I was getting on average. Last year I average and hour less sleep that I did the year before (another sad statistic ).
Those are the two databases I use personally. I don’t have a reason to have one for anything else that hasn’t already been made.