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

Looking for another camera.

Looking for a compact digital camera. This is the spot for taking notes. I want a small camera with a decent lens that takes raw images. It must also have manual F-stop and aperture settings.  I take a lot of pictures from my bike like this one .  My Samsung Galaxy Note 3 takes good images, but I want better. I have an ancient Canon EOS 10D with a Cannon EF 20mm 1:28 lens.  I love taking still life and landscape photos with this camera and super sharp lens.  The dang thing is so heavy that I do not want to ride with it unless I am really on a camera taking picture ride. The The Fujifilm FinePix F900EXR This is another possibility. Generally I have always purchased Canon cameras, but I may have to change.
Read more