Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

SQL Fiddle

sqlfiddle.com

Post reply on HN
Print view View original

81–87 of 87 posts

Re: SQL Fiddle

#81

Post by maaaats »

rjbwork wrote: post #72
jka wrote: post #66

Earlier quoted context omitted.

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…

Would you elaborate on the weaknesses of LINQ you mentioned?

SQL has the weakness, not LINQ.

In LINQ, you do "FROM x SELECT y". So the editor can help you autocomplete the y, since it knows the context.

In SQL, you do "SELECT y FROM x". Thus the editor cannot help you with y.

Re: SQL Fiddle

#82

Post by bmj »

carbonmachine wrote: post #38
bmj wrote: post #22

Earlier quoted context omitted.

* 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.

Same here... Want to start a support group?

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.

Re: SQL Fiddle

#83

Post by rip747 »

cfjedimaster wrote: post #43
pbreit wrote: post #30

Earlier quoted context omitted.

Sorry, but choice of language means more than nothing. ColdFusion is pretty dead-end and not a particularly good choice these days for a variety of reasons.

As we (I work for Adobe!) have talked publicly about the next rev of ColdFusion, and have shown features, talked about focus areas, etc, it is certainly not dead-end in terms of active product development.

we need a package manager (aka bundler). just passing that along :)

Re: SQL Fiddle

#84

Post by adw »

wil421 wrote: post #46
timsayshey wrote: post #26

Earlier quoted context omitted.

Lol, no one really. Just a few obscure organizations like NASA, Apple, Pud's DistroKid/Fandalism, Intel, AT&T, and tons of others. Oh and railo is a java framework, who uses java!? Its 2013!

Actually a lot of enterprise applications are built with Java.

The majority of Internet companies operating at scale likely have services running on the JVM. They might be writing Scala – Twitter, LinkedIn, say – but it's still the Java ecosystem.

Re: SQL Fiddle

#85

Post by smsm42 »

maaaats wrote: post #81
rjbwork wrote: post #72

Earlier quoted context omitted.

Would you elaborate on the weaknesses of LINQ you mentioned?

SQL has the weakness, not LINQ. In LINQ, you do "FROM x SELECT y". So the editor can help you autocomplete the y, since it knows the context. In SQL, you do "SELECT y FROM x". Thus the editor cannot help you with y.

Excellent point. I guess when SQL was designed not many autocompleting IDEs were around though...

Re: SQL Fiddle

#87

Post by jvoorhis »

yebyen wrote: post #11
jvoorhis wrote: 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! :)

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.

Post reply on HN