I spend 75% of development time on UX. You should too. Try my fiddle. http://SenchaFiddle.com/
SQL Fiddle
11–20 of 28 posts
Re: SQL Fiddle
#12SQLite support would be great. It's everywhere and really easy to setup.
Re: SQL Fiddle
#13The first thing I did was check to see if I could test a mongo query...
...and then I remembered I'm an idiot.
Re: SQL Fiddle
#14shoot me up an email if you need help with your project its my handle at gmail, great project I think it has a promising future!
Re: SQL Fiddle
#15SQLite support would be great. It's everywhere and really easy to setup.
SQLite is the next option on my list of databases to support.
Re: SQL Fiddle
#16I 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.
Thanks for taking a look at it; sorry you found some bugs. I should point out that I only posted it publicly a week ago, and this has been my first traffic spike (thanks YCombinator!). I actually only started working on it less than three weeks ago, so I'm not surprised some boundary cases cause trouble. I've got more plans for it in the future. One thing I should note - a lot of people are working against the sample fiddles, but those are probably not where most people will be doing actual fiddling with their own queries, when they use the site for real. Different schema definitions are completely isolated (with little traffic), and so shouldn't see the sorts of problems you stumbled on.
Re: SQL Fiddle
#17You 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/ .
I've been meaning to add links to other useful SQL resources, such as that and http://dbdsgnr.appspot.com/. If you think of more ideas, I'd love to hear them - send me a message @sqlfiddle on twitter. Thanks!
Re: SQL Fiddle
#18I 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?
I don't allow stored procedures or other programming (custom functions, triggers, etc...), because I worry about the danger of opening up that to the whole world. It should be pretty much open for any other standard database+sql commands you would need to do.
BTW - I basically built this site to facilitate answering SQL questions on Stack Overflow. Here's my SO profile: http://stackoverflow.com/users/808921/jake-feasel
Re: SQL Fiddle
#19shoot me up an email if you need help with your project its my handle at gmail, great project I think it has a promising future!
Thanks for the offer; at this point, testing and new ideas are the main things I'm looking for. Shoot anything my way : https://twitter.com/#!/sqlfiddle
Re: SQL Fiddle
#20What's the point of this?
This is not just for testing SQL (which it could be handy for), but for sharing. Suppose you have a scenario where you have a few tables, and you run some SQL and it's not giving the result you expect. You can create a SQL fiddle, post it on your favorite Q/A site, and other SQL experts can quickly tweak your SQL to work right, and share the result back with you.
I'd use this tool.