News for hackers. Stuff that matters.

zckao

Many of the early inmate information is in pdf format. If you want something machine-readable, these have been converted into a csv available here: https://selectstarsql.com/frontmatter.html#dataset
Great job! I'm impressed!
Re:Headquarter Locations of Top 101 Y Combinator Companies on Monday October 29, 2018 @01:49PM (#18329486)
This seems like an instance where visualization confuses more than clarifies. The paragraph at the bottom of the page presented as a table would be more comprehensible.
Re:Show HN: Select Star SQL, an interactive SQL book on Tuesday September 04, 2018 @08:21AM (#17908482)
Thanks Dave! I share many of the sentiments in your writeup, especially about existing tutorials. Admittedly, I have been impressed by the quality of a few of the tutorials that others have suggested here. Will let you know if I think of anything!
Re:Show HN: Select Star SQL, an interactive SQL book on Tuesday September 04, 2018 @12:16AM (#17906595)
Thanks so much for the feedback! Both the typo and the validity-checking bug have been fixed.
Re:Show HN: Select Star SQL, an interactive SQL book on Tuesday September 04, 2018 @12:05AM (#17906557)
Slightly embarrassing -- but the problem may be that the site isn't compatible with FireFox (at least pre-v63 FireFox). The site makes use of custom HTML elements which are not supported by default in pre-v63 FireFox (https://developer.mozilla.org/en-US/docs/Web/Web_Components/...). The good news is that all you need to do is to turn on a flag as set forth in the link provided. The bad news is that many other less tech-savvy people are going to be stymied by this.

edit: the site will now warn you if your browser is incompatible.

Re:Show HN: Select Star SQL, an interactive SQL book on Monday September 03, 2018 @10:32PM (#17906208)
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!