Show HN: SQLBolt – Learn SQL with simple, interactive examples (opens in new tab)

(sqlbolt.com)

18 pointskgen11y ago15 comments

15 comments

14 comments · 7 top-level

larrykubin11y ago· 3 in thread

This is so well done, I'm kind of sad that it isn't getting more attention. I love the concept. My one bit of feedback is that the SQL query text area should have a button to execute the query, rather than clearing the results table and analyzing the query as I type. In the exercise on updating records, it was difficult for me to write the UPDATE statement because I wanted to look at the rows I was updating. I'd prefer if it left the results from the previous query up until the next query runs. Or if you could just leave the same results up the whole time and you could visually see the update run and highlight the rows/columns that were updated and see the values change in place.

kgenOP11y ago

Thanks for the kind words and feedback! I'll try and make the rows more static for some of the lessons -- it's tricky because I feel like the responsive interactivity is important when learning to write queries, but it just might not make sense for some of the lessons (like the update, as you mentioned). Really appreciate the feedback!

kgenOP11y ago

Ok, I think I've found a good solution on the updating, it should only update when you have a valid query now. Hopefully, it should be a bit more stable. :)

hhandoko11y ago

I love the instant feedback when completing a valid query, but as suggested, it can get in the way when trying to compose a filter. Perhaps use a `tickbox` to toggle the automatic table data update?

Another thing, the invalid / incomplete query alert gets in the way of looking at the last data row. Perhaps you can find a better location to show this alerts?

1 more reply

kgenOP11y ago· 2 in thread

Hey all, I couldn't really find anything like this the last time someone asked me about SQL, so I whipped up this site (SQLBolt) over the last couple months.

It's an interactive tutorial, and I'm looking to add a few more topics along the way. Curious to see what HN thought, and whether you guys might find it useful or have any feedback on it as well. :)

edit: typo

Arcsech11y ago

This looks very neat. I haven't used SQL much and while I'm somewhat familiar with it I'll run through it to brush up a bit, thanks!

Also, it took me a minute to find the table of contents - I was looking for an "Index" link or something at the bottom of the page near the previous/next lesson links. For reference, you have to hover over the "Interactive Tutorial" tab at the top of the page.

kgenOP11y ago

Good point, I'll try and make it more clear that the TOC is in the menu. Thanks!

hawe11y ago· 1 in thread

This looks great! Now we'd also like to know what you used to build this? Just underscore.js?

kgenOP11y ago

Thanks! It's mostly client-side with underscore.js and jquery for core js, highlight.js for syntax highlighting, ace for the editor, and an emscripten compiled SQLite lib for the sql processing.

corentin_11y ago· 1 in thread

What is the SQL javascript framework used there ? This is great !

kgenOP11y ago

That would be SQL.js, from the emscripten guys! Props to them! https://github.com/kripken/sql.js/

corentin_11y ago

From you site and your ideas you can built a great desktop SQL developer tools for developer thanks to atom shell for example: http://electron.atom.io/ and some node.js database drivers.

hhandoko11y ago

This is awesome! Great work :)

I've just finished the Scala koans yesterday, and was wondering if there is something similar for SQL. I've been working with ORM libraries exclusively and had not touched `raw` SQL queries at all the past couple of years :(

ozh11y ago

I'm late into the party but I wanted anyway to say "wow" and "thanks". Super well done, super efficient, perfect for raw SQL noobs like me. Thanks :)

j / k navigate · click thread line to collapse

15 comments

14 comments · 7 top-level

larrykubin11y ago· 3 in thread

kgenOP11y ago

Ok, I think I've found a good solution on the updating, it should only update when you have a valid query now. Hopefully, it should be a bit more stable. :)

hhandoko11y ago

I love the instant feedback when completing a valid query, but as suggested, it can get in the way when trying to compose a filter. Perhaps use a `tickbox` to toggle the automatic table data update?

Another thing, the invalid / incomplete query alert gets in the way of looking at the last data row. Perhaps you can find a better location to show this alerts?

1 more reply

kgenOP11y ago· 2 in thread

Hey all, I couldn't really find anything like this the last time someone asked me about SQL, so I whipped up this site (SQLBolt) over the last couple months.

It's an interactive tutorial, and I'm looking to add a few more topics along the way. Curious to see what HN thought, and whether you guys might find it useful or have any feedback on it as well. :)

edit: typo

Arcsech11y ago

This looks very neat. I haven't used SQL much and while I'm somewhat familiar with it I'll run through it to brush up a bit, thanks!

kgenOP11y ago

Good point, I'll try and make it more clear that the TOC is in the menu. Thanks!

hawe11y ago· 1 in thread

This looks great! Now we'd also like to know what you used to build this? Just underscore.js?

kgenOP11y ago

Thanks! It's mostly client-side with underscore.js and jquery for core js, highlight.js for syntax highlighting, ace for the editor, and an emscripten compiled SQLite lib for the sql processing.

corentin_11y ago· 1 in thread

What is the SQL javascript framework used there ? This is great !

kgenOP11y ago

That would be SQL.js, from the emscripten guys! Props to them! https://github.com/kripken/sql.js/

corentin_11y ago

From you site and your ideas you can built a great desktop SQL developer tools for developer thanks to atom shell for example: http://electron.atom.io/ and some node.js database drivers.

hhandoko11y ago

This is awesome! Great work :)

ozh11y ago

I'm late into the party but I wanted anyway to say "wow" and "thanks". Super well done, super efficient, perfect for raw SQL noobs like me. Thanks :)

j / k navigate · click thread line to collapse