I 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'.<p>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.
I 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?
Damn (but jolly well done anyway).<p>MSSQL: The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.: exec xp_cmdshell<p>MySQL: Access denied for user 'user_46783'@'localhost' (using password: YES): load data infile '/etc/passwd' into table leet;
You 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 <a href="http://www.tsqltidy.com/" rel="nofollow">http://www.tsqltidy.com/</a> .
This 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.
Great work, love it!<p>An idea: Integrate with different ORMs (Python SQLAlchemy, Ruby ActiveRecord etc.) and let users execute code against the schemas.<p><a href="http://imgur.com/O5PoV" rel="nofollow">http://imgur.com/O5PoV</a><p>Would obviously require a sandboxed execution environment, like some of the pastebins that allow code execution (for instance <a href="http://codepad.org" rel="nofollow">http://codepad.org</a>).
combine it with WWW SQL Designer and you can have some fun:<p><a href="http://ondras.zarovi.cz/sql/demo/?keyword=default" rel="nofollow">http://ondras.zarovi.cz/sql/demo/?keyword=default</a><p>these two projects should merge...