Great SQL Tool

I really got excited this morning when I was researching a solution to a database problem.  I always find myself pouring over other peoples questions on sites like Stack Overflow until I find a solution or a clue to my error or problem.  today I was looking at a solution and discovered that the correct answer was posted using a cool online SQL site, http://sqlfiddle.com/

I know I am not always up to date on stuff, but this site is really great.  It will allow you to build a schema and test your ideas without doing any real damage to a database system.  I have always set up a test database for this purpose, but being able to quickly write a SQL statement and se what idt does all on one web page is really cool.  I can test out ideas quickly and then use the SQL code on the production database.

Comments

Post a Comment

Popular posts from this blog

Austin Friends and places

There is too much fun stuff to do in Austin. This weekend is my last one that I will spend in Texas for a while. I enjoyed spending some time this weekend with a three friends that I have had the pleasure to meet in the short time that I have lived here. I also wanted to visit a few of my favorite spots before I left.
Read more

PHP Web Store

Well finally I have made progress on one of my goals. I have been working on learning PHP and have created my first eCommerce web store. If you want to check it out it is located here . I am going to add artwork to this store and I hope to generate some income from it. One thing for sure is that I'm learning how to create dynamic web pages using PHP and a MySQL database.
Read more

Georgia on my mind

Texas was not deep enough in the south for me so I relocated to Albany, Georgia. I have been her almost a month and the adventure of living in a new city and working at a new institution are still fresh. This week week as I walked across the campus with my paper notebook in hand I was whistling as I passed through groups of students go to classes. I noticed how everyone of them was either talking on a mobile device or listening to music on them. I marveled at how odd I must seem to them as I walked without having any electronic device turned on and instead i was making the music with my lips. Albany Georgia is a lot like Portland, only smaller and really flat. Albany has the Flint River running through the middle of the downtown area and lots of pine and pecan trees all over.
Read more