SQL Fiddle
sqlfiddle.com
SQL Fiddle
1–10 of 28 posts
Re: SQL Fiddle
#2What's the point of this?
Re: SQL Fiddle
#3This looks like a great way to test SQL syntax differences, but it's been ages since I've needed to do so - now I either have some abstraction layer (ORM like PDO) that allows me to code in objects or I'm using key-value stores anyway.
Re: SQL Fiddle
#4This looks like a great way to test SQL syntax differences, but it's been ages since I've needed to do so - now I either have some abstraction layer (ORM like PDO) that allows me to code in objects or I'm using key-value stores anyway.
If you're referring to PHP's PDO, it's not an ORM and you're still exposed to all the syntax quirks if you have to support several databases.
Re: SQL Fiddle
#5I could see myself using this when I'm killing time answering questions on Stack Overflow and don't want to launch SQL Management Studio to test out my answers, or if I'm on a machine where it's not available. I was pleased to see it supports the declare table variables in MSSQL. Are there limitations on commands, etc?
Re: SQL Fiddle
#6What's the point of this?
Testing out snippets of code without altering a structure of the database you have installed locally/on a server.
Doesn't require a startup of the database - the results can be discarded and you don't have to worry about cleaning it up :)
Generally, just a fast way to test things - I would see it coming in handy during some presentations maybe?
Re: SQL Fiddle
#7combine it with WWW SQL Designer and you can have some fun:
http://ondras.zarovi.cz/sql/demo/?keyword=default
these two projects should merge...
Re: SQL Fiddle
#8What's the point of this?
the same point as JSFiddle.net I presume
Re: SQL Fiddle
#9I played with this for a couple of minutes to see where the boundaries were, and I've gotten 'database already exists', 'internal server error', Apache alerts, random hangs and disconnects, and 'command terminated by administrator'.
It's a neat concept, but it needs serious polishing before I'd consider going to this even for quick and dirty testing or demo purposes.
Re: SQL Fiddle
#10You sir, if you make this shine as well as jsfiddle, I want you to come into my house and take one of anything. While you're at it, partner up with this guy http://www.tsqltidy.com/ .