Live data from Hacker News

SQL Fiddle

sqlfiddle.com

21–28 of 28 posts

Re: SQL Fiddle

#21
post #17
post #10

You sir, if you make this shine as well as jsfiddle, I want you to come into my house and take one of anything. While you're at it, partner up with this guy http://www.tsqltidy.com/ .

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!

Not really an SQL tool, but if you use a lot of SQL then maybe you need to apply DDL and procedures to various environments. I have been working on an installer to manage your DB schema using migration scripts - http://dbgeni.com

Re: SQL Fiddle

#22
post #19
post #14

shoot me up an email if you need help with your project its my handle at gmail, great project I think it has a promising future!

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

Will do, thanks

Re: SQL Fiddle

#23
post #16
post #9

I played with this for a couple of minutes to see where the boundaries were, and I've gotten 'database already exists', 'internal server error', Apache alerts, random hangs and disconnects, and 'command terminated by administrator'. It's a neat concept, but it needs serious polishing before I'd consider going to this even for quick and dirty testing or demo purposes.

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…

Your creation is very cool, kudos. I don't mean to be pedantic, but I think you mean "thanks Hacker News." The people behind YCombinator are certainly responsible for this website, but they are two different things.

Re: SQL Fiddle

#24
post #16
post #9

I played with this for a couple of minutes to see where the boundaries were, and I've gotten 'database already exists', 'internal server error', Apache alerts, random hangs and disconnects, and 'command terminated by administrator'. It's a neat concept, but it needs serious polishing before I'd consider going to this even for quick and dirty testing or demo purposes.

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…

[deleted]

Re: SQL Fiddle

#25
post #23
post #16

Earlier quoted context omitted.

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…

Your creation is very cool, kudos. I don't mean to be pedantic, but I think you mean "thanks Hacker News." The people behind YCombinator are certainly responsible for this website, but they are two different things.

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

/newb

Re: SQL Fiddle

#26
Damn (but jolly well done anyway).

MSSQL: The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.: exec xp_cmdshell

MySQL: Access denied for user 'user_46783'@'localhost' (using password: YES): load data infile '/etc/passwd' into table leet;

Re: SQL Fiddle

#27
post #26

Damn (but jolly well done anyway). MSSQL: The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.: exec xp_cmdshell MySQL: Access denied for user 'user_46783'@'localhost' (using password: YES): load data infile '/etc/passwd' into table leet;

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

Re: SQL Fiddle

#28
Great work, love it!

An idea: Integrate with different ORMs (Python SQLAlchemy, Ruby ActiveRecord etc.) and let users execute code against the schemas.

http://imgur.com/O5PoV

Would obviously require a sandboxed execution environment, like some of the pastebins that allow code execution (for instance http://codepad.org).

Post reply on HN