18 ms·

SQL Fiddle

162 points by neokya 13y ago

deleted 13y ago
[deleted]
JimmaDaRustla 13y ago
Nice! Might be good to teach some co-workers some SQL stuff rather than drawing on white-boards and drafting up SAS jobs.
wehadfun 13y ago
Used this a long time ago it is a great tool for figuring out a SQL query.
gnarbarian 13y ago
A friend of mine wrote this. If you have any questions I can try to get him on here.
- mmastrac 13y ago
  He's leaking stacktraces on error BTW: no SMTP Server defined at railo.runtime.net.smtp.SMTPClient.send(SMTPClient.java:676):676 at railo.runtime.tag.Mail.doEndTag(Mail.java:519):519 at wheels.global.cfml_cfm$cf._1(/root/sqlfiddle/src/main/webapp/wheels/global/cfml.cfm:93):93 at wheels.global.cfml_cfm$cf.udfCall(/root/sqlfiddle/src/main/webapp/wheels/global/cfml.cfm):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215 at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377 at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774 at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1495):1495 at wheels.events.onerror_cfm$cf.udfCall(/root/sqlfiddle/src/main/webapp/wheels/events/onerror.cfm:42):42 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215 at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377 at railo.runtime.tag.Invoke.doFunction(Invoke.java:224):224 at railo.runtime.tag.Invoke.doEndTag(Invoke.java:191):191 at wheels.global.cfml_cfm$cf._1(/root/sqlfiddle/src/main/webapp/wheels/global/cfml.cfm:44):44 at wheels.global.cfml_cfm$cf.udfCall(/root/sqlfiddle/src/main/webapp/wheels/global/cfml.cfm):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215 at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377 at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774 at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1495):1495 at wheels.events.onerror_cfm$cf.udfCall(/root/sqlfiddle/src/main/webapp/wheels/events/onerror.cfm:14):14 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215 at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434 at railo.runtime.type.UDFImpl.call(UDFImpl.java:384):384 at railo.runtime.ComponentImpl._call(ComponentImpl.java:615):615 at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1815):1815 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:349):349 at railo.runtime.listener.ModernAppListener.onError(ModernAppListener.java:336):336 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2045):2045 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2002):2002 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722):722 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225):225 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169):169 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168):168 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98):98 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565):565 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307):307 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source):-1 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1 at java.lang.Thread.run(Unknown Source):-1
  - k3n 13y ago
    Probably don't need it pasted here...
buckbova 13y ago
I've used this for interviewees. Set them up with a test fiddle with questions set in the comments.
- goostavos 13y ago
  As a guy about to finish up school and make his way into the work force, would you be willing to release some of the questions you use in interviews. It be neat to see which areas I need to patch up knowledge wise!
  - buckbova 13y ago
    When the site is back up, I'll verify the link and post here. It's been about 2 months since I've used it. Simple query stuff though. Basic aggregate stuff. When to use "LEFT JOIN". Creating a scalar function. Multiple table JOINs.
  - buckbova 13y ago
    Try this quiz. It's based on a quiz I saw posted on HN a while back. http://sqlfiddle.com/#!3/3973f/1 http://sqlfiddle.com/#!3/3973f/1 Edit: I'm not allowed to reply just yet, so I'll post here. You need to add the boss first to the employee table with a NULL bossID. Then you add another employee that has a bossID that refers to that last added record.
    - jsmeaton 13y ago
      Aww - no test data? And when trying to add test data, I get errors due to the self-referencing foreign key. Perhaps the schema could do with a > DEFAULT (IDENT_CURRENT('dbo.Employees')) on the BossID column. Been awhile (years) since I've worked with SQL Server.
jvoorhis 13y ago
Is the site slow?
- camus 13y ago
  it's the HN effect , one should better web scale before linking one's work ;) nice site though.
- yebyen 13y ago
  The site is apparently HN'ed... railo.runtime.net.mail.MailException which seems to be a framework error from a ColdFusion application server. Shame on OP, posting something cool and letting it get upvoted without warning the author/host in advance! :)
  - neokya 13y ago
    Sorry about that. I didn't expect that would happen. Will definitely do that next time. I found it really cool and thought of just posting it on HN. Edit: Pinged @sqlfiddle on twitter. I hope maintainer did notice it.
    - yebyen 13y ago
      I was only joking. How do you know it's going to get upvoted anyway? I think it's probably good netiquette though.
  - jvoorhis 13y ago
    I was making a joke about the performance implications of a public SQL free-for-all, but I was probably being too subtle! That said, I applaud the creators of the site.
rip747 13y ago
this project has always impressed me. keep telling myself that i need to browse the source to see how it was all done. congrats jake!
deleted 13y ago
[deleted]
MSM 13y ago
Fantastic tool. It pops up constantly on StackOverflow and I've found it incredibly useful for interviews. I noticed recently that the Execution Plan was added which just opens more avenues for teaching & interviewing.
deleted 13y ago
[deleted]
mountaineer 13y ago
Been a while since I've seen a coldfusion error dump
nikentic 13y ago
This must be the ugliest error screen I have ever seen. Is this 1990?
- Gigablah 13y ago
  Quick, add Bootstrap 3 and flat UI to everything!
nbevans 13y ago
http://i.imgur.com/RHxoW5J.png http://i.imgur.com/RHxoW5J.png 1. Security flaw in leaking that much error info. 2. Who uses ColdFusion in 2013?
- bmj 13y ago
  * Who uses ColdFusion in 2013?* Me? Because I have to maintain a rather old site for my employer, and there is absolutely no chance that anyone would sign-off on migrating it to a different platform.
  - carbonmachine 13y ago
    Same here... Want to start a support group?
    - bmj 13y ago
      I need one. Interestingly, about a year ago, we were told that we would no longer be doing any updates to the system, and yet, here we are, a year later, still doing minor releases. I suspect it will never go away.
- benihana 13y ago
  >Who uses ColdFusion in 2013? About 2/3 of the federal government. Also, that isn't ColdFusion, it's Railo, an OS alternative.
  - ZoF 13y ago
    He had "railo" highlighted... I think he knows that it's not literally ColdFusion...
- rip747 13y ago
  pud's latest project is still on the homepage of HN and he wrote it in CFML: https://news.ycombinator.com/item?id=6519743 https://news.ycombinator.com/item?id=6519743 Just because project X is not written in your language of choice, means absolutely nothing. Its all about execution and this project is pretty impressive.
codinghorror 13y ago
Also try http://data.stackexchange.com http://data.stackexchange.com where you can query Stack Overflow and other SE site data in real time using SQL.
jpwagner 13y ago
i still haven't seen the main site, but i found these: http://sqlfiddle.com/about.html http://sqlfiddle.com/about.html https://github.com/jakefeasel/sqlfiddle https://github.com/jakefeasel/sqlfiddle
jfeasel 13y ago
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!
jfeasel 13y ago
Ok folks. It's back up now. I will keep my eye on it, hopefully it doesn't get hugged to death again.
jfeasel 13y ago
If anyone is interested in how this site gets used, here's an idea: http://stackoverflow.com/search?tab=newest&q=url%3a%22http%3a%2f%2f*sqlfiddle.com%2f*%22 http://stackoverflow.com/search?tab=newest&q=url%3a%22http%3...
neokya 13y ago
The site is up again :)
breckinloggins 13y ago
One thing that would be great here would be autocompletion. I often forget exactly what the syntax of "CREATE TABLE" is or which options I can use. The same goes for infrequently used SQL functions (now is that date_diff or datediff?). You could combine autocompletion with a doc panel that automatically updates to show the "quick reference" for the keyword you're currently typing.
- jfeasel 13y ago
  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.
  - breckinloggins 13y ago
    Awesome, thanks!
- jka 13y ago
  Slightly off-topic, but one thing that always impressed me about Microsoft's LINQ as an alternative to SQL queries is that they considered autocompletion up-front in the language syntax. For SQL, it's a big challenge - you may type in 'SELECT', but your IDE still has no idea what relation(s) you're going to access, and so it can't reasonably autocomplete the possible fields you might want to use. It's an interesting example of a language that was arguably designed for human readability in the small ('give me this from that cross-referenced with this other thing'), but in some sense became a weakness of sorts later on.
  - radiowave 13y ago
    One way to approach it would be to have a grab bag of templates. You drag a template like "SELECT ... FROM ... WHERE ..." out into the editor and then tab through it filling in the blanks. I've always thought that SQL's notion of readability was somewhere between superficial and disingenuous - you can read the query and it sounds like it ought to make sense, but there's so many occasions where you won't actually be able to understand why it isn't working unless you know how to translate in your head from the order in which the clauses are written, to the order in which they're carried out.
shennyg 13y ago
Used this last night to get help debugging an issue on #mysql, worked great. thanks Xgc and jfeasel
wassago 13y ago
Cool but it can't handle traffic like JSFiddle (the originator of all code playgrounds) can.
smsm42 13y ago
Excellent tool, especially for checking if certain set of SQL works on certain platform. I wish they added DB2 too...
dancecodes 13y ago
its cool but slow

162 points by neokya 13y ago

deleted 13y ago

[deleted]

Nice! Might be good to teach some co-workers some SQL stuff rather than drawing on white-boards and drafting up SAS jobs.

wehadfun 13y ago

Used this a long time ago it is a great tool for figuring out a SQL query.

gnarbarian 13y ago

A friend of mine wrote this. If you have any questions I can try to get him on here.

mmastrac 13y ago
He's leaking stacktraces on error BTW: no SMTP Server defined at railo.runtime.net.smtp.SMTPClient.send(SMTPClient.java:676):676 at railo.runtime.tag.Mail.doEndTag(Mail.java:519):519 at wheels.global.cfml_cfm$cf._1(/root/sqlfiddle/src/main/webapp/wheels/global/cfml.cfm:93):93 at wheels.global.cfml_cfm$cf.udfCall(/root/sqlfiddle/src/main/webapp/wheels/global/cfml.cfm):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215 at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377 at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774 at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1495):1495 at wheels.events.onerror_cfm$cf.udfCall(/root/sqlfiddle/src/main/webapp/wheels/events/onerror.cfm:42):42 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215 at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377 at railo.runtime.tag.Invoke.doFunction(Invoke.java:224):224 at railo.runtime.tag.Invoke.doEndTag(Invoke.java:191):191 at wheels.global.cfml_cfm$cf._1(/root/sqlfiddle/src/main/webapp/wheels/global/cfml.cfm:44):44 at wheels.global.cfml_cfm$cf.udfCall(/root/sqlfiddle/src/main/webapp/wheels/global/cfml.cfm):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215 at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377 at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774 at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1495):1495 at wheels.events.onerror_cfm$cf.udfCall(/root/sqlfiddle/src/main/webapp/wheels/events/onerror.cfm:14):14 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215 at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434 at railo.runtime.type.UDFImpl.call(UDFImpl.java:384):384 at railo.runtime.ComponentImpl._call(ComponentImpl.java:615):615 at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1815):1815 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:349):349 at railo.runtime.listener.ModernAppListener.onError(ModernAppListener.java:336):336 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2045):2045 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2002):2002 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722):722 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225):225 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169):169 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168):168 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98):98 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565):565 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307):307 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source):-1 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1 at java.lang.Thread.run(Unknown Source):-1
- k3n 13y ago
  Probably don't need it pasted here...

buckbova 13y ago

I've used this for interviewees. Set them up with a test fiddle with questions set in the comments.

goostavos 13y ago
As a guy about to finish up school and make his way into the work force, would you be willing to release some of the questions you use in interviews. It be neat to see which areas I need to patch up knowledge wise!
- buckbova 13y ago
  When the site is back up, I'll verify the link and post here. It's been about 2 months since I've used it. Simple query stuff though. Basic aggregate stuff. When to use "LEFT JOIN". Creating a scalar function. Multiple table JOINs.
- buckbova 13y ago
  Try this quiz. It's based on a quiz I saw posted on HN a while back. http://sqlfiddle.com/#!3/3973f/1 http://sqlfiddle.com/#!3/3973f/1 Edit: I'm not allowed to reply just yet, so I'll post here. You need to add the boss first to the employee table with a NULL bossID. Then you add another employee that has a bossID that refers to that last added record.
  - jsmeaton 13y ago
    Aww - no test data? And when trying to add test data, I get errors due to the self-referencing foreign key. Perhaps the schema could do with a > DEFAULT (IDENT_CURRENT('dbo.Employees')) on the BossID column. Been awhile (years) since I've worked with SQL Server.

jvoorhis 13y ago

Is the site slow?

camus 13y ago
it's the HN effect , one should better web scale before linking one's work ;) nice site though.
yebyen 13y ago
The site is apparently HN'ed... railo.runtime.net.mail.MailException which seems to be a framework error from a ColdFusion application server. Shame on OP, posting something cool and letting it get upvoted without warning the author/host in advance! :)
- neokya 13y ago
  Sorry about that. I didn't expect that would happen. Will definitely do that next time. I found it really cool and thought of just posting it on HN. Edit: Pinged @sqlfiddle on twitter. I hope maintainer did notice it.
  - yebyen 13y ago
    I was only joking. How do you know it's going to get upvoted anyway? I think it's probably good netiquette though.
- jvoorhis 13y ago
  I was making a joke about the performance implications of a public SQL free-for-all, but I was probably being too subtle! That said, I applaud the creators of the site.

rip747 13y ago

this project has always impressed me. keep telling myself that i need to browse the source to see how it was all done. congrats jake!

deleted 13y ago

[deleted]

MSM 13y ago

Fantastic tool. It pops up constantly on StackOverflow and I've found it incredibly useful for interviews. I noticed recently that the Execution Plan was added which just opens more avenues for teaching & interviewing.

deleted 13y ago

[deleted]

mountaineer 13y ago

Been a while since I've seen a coldfusion error dump

nikentic 13y ago

This must be the ugliest error screen I have ever seen. Is this 1990?

Gigablah 13y ago
Quick, add Bootstrap 3 and flat UI to everything!

nbevans 13y ago

http://i.imgur.com/RHxoW5J.png http://i.imgur.com/RHxoW5J.png 1. Security flaw in leaking that much error info. 2. Who uses ColdFusion in 2013?

bmj 13y ago
* Who uses ColdFusion in 2013?* Me? Because I have to maintain a rather old site for my employer, and there is absolutely no chance that anyone would sign-off on migrating it to a different platform.
- carbonmachine 13y ago
  Same here... Want to start a support group?
  - bmj 13y ago
    I need one. Interestingly, about a year ago, we were told that we would no longer be doing any updates to the system, and yet, here we are, a year later, still doing minor releases. I suspect it will never go away.
benihana 13y ago
>Who uses ColdFusion in 2013? About 2/3 of the federal government. Also, that isn't ColdFusion, it's Railo, an OS alternative.
- ZoF 13y ago
  He had "railo" highlighted... I think he knows that it's not literally ColdFusion...
rip747 13y ago
pud's latest project is still on the homepage of HN and he wrote it in CFML: https://news.ycombinator.com/item?id=6519743 https://news.ycombinator.com/item?id=6519743 Just because project X is not written in your language of choice, means absolutely nothing. Its all about execution and this project is pretty impressive.

codinghorror 13y ago

Also try http://data.stackexchange.com http://data.stackexchange.com where you can query Stack Overflow and other SE site data in real time using SQL.

jpwagner 13y ago

i still haven't seen the main site, but i found these: http://sqlfiddle.com/about.html http://sqlfiddle.com/about.html https://github.com/jakefeasel/sqlfiddle https://github.com/jakefeasel/sqlfiddle

jfeasel 13y ago

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!

jfeasel 13y ago

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

jfeasel 13y ago

If anyone is interested in how this site gets used, here's an idea: http://stackoverflow.com/search?tab=newest&q=url%3a%22http%3a%2f%2f*sqlfiddle.com%2f*%22 http://stackoverflow.com/search?tab=newest&q=url%3a%22http%3...

neokya 13y ago

The site is up again :)

breckinloggins 13y ago

One thing that would be great here would be autocompletion. I often forget exactly what the syntax of "CREATE TABLE" is or which options I can use. The same goes for infrequently used SQL functions (now is that date_diff or datediff?). You could combine autocompletion with a doc panel that automatically updates to show the "quick reference" for the keyword you're currently typing.

jfeasel 13y ago
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.
- breckinloggins 13y ago
  Awesome, thanks!
jka 13y ago
Slightly off-topic, but one thing that always impressed me about Microsoft's LINQ as an alternative to SQL queries is that they considered autocompletion up-front in the language syntax. For SQL, it's a big challenge - you may type in 'SELECT', but your IDE still has no idea what relation(s) you're going to access, and so it can't reasonably autocomplete the possible fields you might want to use. It's an interesting example of a language that was arguably designed for human readability in the small ('give me this from that cross-referenced with this other thing'), but in some sense became a weakness of sorts later on.
- radiowave 13y ago
  One way to approach it would be to have a grab bag of templates. You drag a template like "SELECT ... FROM ... WHERE ..." out into the editor and then tab through it filling in the blanks. I've always thought that SQL's notion of readability was somewhere between superficial and disingenuous - you can read the query and it sounds like it ought to make sense, but there's so many occasions where you won't actually be able to understand why it isn't working unless you know how to translate in your head from the order in which the clauses are written, to the order in which they're carried out.

shennyg 13y ago

Used this last night to get help debugging an issue on #mysql, worked great. thanks Xgc and jfeasel

wassago 13y ago

Cool but it can't handle traffic like JSFiddle (the originator of all code playgrounds) can.

smsm42 13y ago

Excellent tool, especially for checking if certain set of SQL works on certain platform. I wish they added DB2 too...

dancecodes 13y ago

its cool but slow