Hacker News Reader

Comment by dawie | Hacker News Reader

I really like your explanations. I have never been able to wrap my head around joins.

You say that: "Programming is best learned by doing", but I am struggling to do anything...

It would be great if there was some online area like SQL Fiddle with the data loaded, so I can run queries and see results in my browser without having to set anything up or am I missing something.

View on HN

(self plug) pgexercises.com provides something like this.

The code is open source, anyone is welcome to fork and populate with new data like this.

I learned SQL mostly by using your site, thank you for making it!

Me too! Thanks Alisdair!

pleasure, glad you both found it useful :-)

One option is to learn on bigquery (a google cloud service) - its "pre-loaded" with all kinds of public datasets that you can just start querying, with a web interface for doing sql.

Its pretty easy to stay within the free tier (1TB of data per month)

All the blue boxes are actually interactive code editors. You can run arbitrary queries against the dataset in them. I changed some of the wording to make it clearer. Hopefully that helps!

I was wondering what you were talking about. What blue boxes? Then I saw the problem. The boxes showed up in Chromium but not Firefox.

Same here - the front matter page mentions web components - perhaps the support is different /disabled in Firefox?

The <sql-exercise data-question...> elements aren't visible in Firefox at all.

My favorite version of sqlfiddle is dbfiddle.uk. Lots of databases and generally fast.

sqlzoo.net might be something you would like.

Reply on news.ycombinator.com