zckao
Re:Texas Records All Inmates Last Words Before Execution And Puts Them...
on Monday January 09, 2023 @05:24PM (#34317205)
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
Re:Show HN: My 7th Grade Young Entrepreneur Project -- interactive hol...
on Sunday December 16, 2018 @04:21PM (#18695320)
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!