Live data from Hacker News

SQL Fiddle

sqlfiddle.com

11–20 of 87 posts

Re: SQL Fiddle

#11
post #7

Is the site slow?

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! :)

Re: SQL Fiddle

#12
post #11
post #7

Is the site slow?

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! :)

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.

Re: SQL Fiddle

#13
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.

Re: SQL Fiddle

#15

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

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

Re: SQL Fiddle

#16
post #6

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

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!

Re: SQL Fiddle

#19

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

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(UD…

Probably don't need it pasted here...

Re: SQL Fiddle

#20
post #6

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

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!

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.

Post reply on HN