jfeasel

I don't have that feature exactly, but I can offer this - if you have a table of regularly-formatted text data, you can paste it into the "Text-to-DDL" feature to have it automatically generate your CREATE TABLE and INSERT INTO statements.

Re: 2) Some day when I have a huge amount of free time, I would like to migrate to Groovy on Grails. Until then - CF is what I had used for over a decade, and it was the easiest thing for me to use to build with at the time (Jan 2012). I was more interested in getting something out there than using whatever the latest trendy tech.

If anyone is interested in how this site gets used, here's an idea:

http://stackoverflow.com/search?tab=newest&q=url%3a%22http%3...

Ok folks. It's back up now. I will keep my eye on it, hopefully it doesn't get hugged to death again.

Love it when I go to lunch, just to find out that someone posts my site to Hacker News and it gets crushed.

It will be back up and running shortly!

Thanks for your work, azakai! I was very pleased when I learned about it. A perfect fit for my site, and a cool way of implementing a new "back"-end.

Good point. I plan on building some help tips that explain how it works a bit better (beyond simply the examples which I have now) and that sounds like something worth including.

Also, a shout out to mrpollo (http://news.ycombinator.com/user?id=mrpollo) who helped me with the redesigned UI, after seeing the first post here on Hacker News. Thanks Ramon!

Thanks to Hacker News for the feedback I received earlier! I have been able to incorporate many of your ideas, and still look forward to hearing more.

LOL yeah, I tried to do some of the more obvious security limitations to prevent just that sort of thing.

@jeremya - sorry for the misattribution. I just signed up for an account here, so I didn't know the lay of the land.

/newb

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

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

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!

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.

SQLite is the next option on my list of databases to support.