HNHacker News
TopNewBestAskShowJobs

zckao

317 karma · joined May 16, 2013

website: kaomorphism.com
submissionscomments
zckao··on Texas Records All Inmates Last Words Before Execution And Puts Them All Online
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
zckao··on Show HN: My 7th Grade Young Entrepreneur Project -- interactive holiday cards
Great job! I'm impressed!
zckao··on Headquarter Locations of Top 101 Y Combinator Companies
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.
zckao··on Show HN: Select Star SQL, an interactive SQL book
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!
zckao··on Show HN: Select Star SQL, an interactive SQL book
Thanks so much for the feedback! Both the typo and the validity-checking bug have been fixed.
zckao··on Show HN: Select Star SQL, an interactive SQL book
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.

zckao··on Show HN: Select Star SQL, an interactive SQL book
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!