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

51–60 of 87 posts

Re: SQL Fiddle

#51

Post by harel »

davidgerard wrote: post #40
harel wrote: post #27

Earlier quoted context omitted.

If I remember correctly, F#&@ed Company, pud's old wonder box of startup gossip was also done in ColdFusion (though in those days it was quite a good platform to do web stuff).

No, there just wasn't a less-worse one. Bloody PHP is an improvement on ColdFusion.

I disagree with you here. Although I would not choose ColdFusion for anything these days, in 1998/1999 it was a super fast way to get a web site/app together. Post 2000 it was converted to Java and became a glorified JSP tag library. It was a good platform that didn't stand the test of time.

Re: SQL Fiddle

#52

Post by harel »

pbreit wrote: post #30
rip747 wrote: post #25

Earlier quoted context omitted.

pud's latest project is still on the homepage of HN and he wrote it in CFML: 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.

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.

Let me break it for you, nobody except you and some opinionated programmers on the web, cares what language you wrote website X or web app Y in. If it works, and you are able to maintain it - you won't hear a single word of praise from the 'users' congratulating you on your stellar choice of language. They'll rip you to shreds when it stops working but even then they'll never tell you off for choosing the wrong language.

If it works, and you can maintain it - its all good. Even Cold Fusion, even PHP, even Perl, even Brainf#@k

Re: SQL Fiddle

#53

Post by RussianCow »

aimhb wrote: post #35
nbevans wrote: post #21

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

Can someone explain how leaking a traceback is a security flaw, considering it's a lot less information than just releasing the source code (which we do all the time and don't consider it a security flaw)?

There's nothing inherently insecure about it, it's just more information that a potential attacker has to use against your system. Obviously, if someone breaks into your system from the information in a traceback, it's likely because of a deeper security hole in your system, so hiding tracebacks is just security through obscurity, but given the choices of publicly showing this information vs not, it's better not to.

WRT to open source: in open source software, you theoretically have many benign eyes vetting your code for security issues, whereas with closed source applications, the only people who are looking for security holes are you and attackers. :)

Re: SQL Fiddle

#54

Post by breckinloggins »

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.

Re: SQL Fiddle

#55

Post by jfeasel »

breckinloggins wrote: post #54

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.

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: SQL Fiddle

#56

Post by breckinloggins »

jfeasel wrote: post #55
breckinloggins wrote: post #54

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.

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.

Awesome, thanks!

Re: SQL Fiddle

#57

Post by davidgerard »

harel wrote: post #51
davidgerard wrote: post #40

Earlier quoted context omitted.

No, there just wasn't a less-worse one. Bloody PHP is an improvement on ColdFusion.

I disagree with you here. Although I would not choose ColdFusion for anything these days, in 1998/1999 it was a super fast way to get a web site/app together. Post 2000 it was converted to Java and became a glorified JSP tag library. It was a good platform that didn't stand the test of time.

I remember it being quite horrible around that time. But, as you say, a fast way to get a site together. I maintain that PHP was actually less worse, and I despise PHP with a contempt that would give [INSERT DICTATOR HERE] pause.

Re: SQL Fiddle

#58

Post by buckbova »

goostavos wrote: post #16
buckbova wrote: 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!

Try this quiz. It's based on a quiz I saw posted on HN a while back.

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.

Re: SQL Fiddle

#59

Post by thefreeman »

douglasfshearer wrote: post #47
nbevans wrote: post #21

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

Linode use Coldfusion for their management interface [1] [2]. [1] - http://webpulp.tv/episodes/managing-8-petabytes-and-virtual-... [2] - https://blog.linode.com/2013/04/16/security-incident-update/

Can't tell if sarcastic or not. Seeing how you link to the giant security fiasco caused by a cold fusion 0 day I'm assuming this is not a recommendation.
Post reply on HN