SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#1

Post by jfeasel » Mon, Mar 19, 2012, 7:16 PM UTC

SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js
sqlfiddle.com

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#2

Post by jfeasel » Mon, Mar 19, 2012, 7:18 PM UTC

Thanks to Hacker News for the feedback I received earlier! I have been able to incorporate many of your ideas, and still look forward to hearing more.

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#3

Post by jfeasel » Mon, Mar 19, 2012, 7:29 PM UTC

jfeasel wrote: post #2

Thanks to Hacker News for the feedback I received earlier! I have been able to incorporate many of your ideas, and still look forward to hearing more.

Also, a shout out to mrpollo (http://news.ycombinator.com/user?id=mrpollo) who helped me with the redesigned UI, after seeing the first post here on Hacker News. Thanks Ramon!

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#4

Post by Qweef » Mon, Mar 19, 2012, 7:31 PM UTC

It's awesome!!

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#5

Post by RollAHardSix » Mon, Mar 19, 2012, 8:22 PM UTC

1st, I agree. It's awesome!!

2nd, it was a bit confusing at first not having to 'create' a database and instead jumping right into commands. Maybe add this note somewhere for clarification? It was just a bit of a dummy moment when the very first thing that happens is you run a create command, and then are looking at an error message.

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#6

Post by jfeasel » Mon, Mar 19, 2012, 8:30 PM UTC

RollAHardSix wrote: post #5

1st, I agree. It's awesome!! 2nd, it was a bit confusing at first not having to 'create' a database and instead jumping right into commands. Maybe add this note somewhere for clarification? It was just a bit of a dummy moment when the very first thing that happens is you run a create command, and then are looking at an error message.

Good point. I plan on building some help tips that explain how it works a bit better (beyond simply the examples which I have now) and that sounds like something worth including.

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#7

Post by spacesuit » Mon, Mar 19, 2012, 8:44 PM UTC

Very cool. Tools like this are unbelievably useful for self-study, as they allow for quick experimentation. Which (at least in my case) helps cement new concepts.

Another, similar tool is jsFiddle (http://jsfiddle.net/).

Anyone know of any others like this?

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#8

Post by azakai » Mon, Mar 19, 2012, 8:50 PM UTC

Very nice! And very happy people are finding sql.js useful. Let me know if there are any improvements that would be useful for this project (or others).

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#9

Post by jfeasel » Mon, Mar 19, 2012, 9:00 PM UTC

azakai wrote: post #8

Very nice! And very happy people are finding sql.js useful. Let me know if there are any improvements that would be useful for this project (or others).

Thanks for your work, azakai! I was very pleased when I learned about it. A perfect fit for my site, and a cool way of implementing a new "back"-end.

Re: SQLFiddle 2.0: Execution Plans, Better UI, client-side SQLite via sql.js

#10

Post by j0k3r » Mon, Mar 19, 2012, 10:10 PM UTC

spacesuit wrote: post #7

Very cool. Tools like this are unbelievably useful for self-study, as they allow for quick experimentation. Which (at least in my case) helps cement new concepts. Another, similar tool is jsFiddle ( http://jsfiddle.net/ ). Anyone know of any others like this?

There is also : - http://rubyfiddle.com/ - http://pythonfiddle.com/