HNHacker News
TopNewBestAskShowJobs

code007

177 karma · joined September 10, 2020

Author of System Design Interview – An Insider's Guide. Previously Twitter, Apple and Zynga.
submissionscomments
code007··on [dead]
SQL statements are executed by the database system in several steps, including: - Parsing the SQL statement and checking its validity - Transforming the SQL into an internal representation, such as relational algebra - Optimizing the internal representation and creating an execution plan that utilizes index information - Executing the plan and returning the results
code007··on Algorithms you should know before you take system design interviews
Thank you so much for all the suggestions. I'll update the diagram in the next few days.

We plan to go through the whole list with video explanations. So far, we have done two: Consistent hashing: https://www.youtube.com/watch?v=UF9Iqmg94tk Geohash/Quadtree: https://www.youtube.com/watch?v=M4lR_Va97cQ

code007··on Show HN: Code reviews intimidated me, so I built a course on how to master them
In your opinion, what are the most important things to look for in a code review?
code007··on A sad story about self-publishing a tech book and fraud on Amazon
I'm the author of the said book. I spent one year and a half writing full-time to complete the book. Now, most of the copies sold on Amazon are pirated copies. I have filed copyright claims many times and Amazon does nothing. It’s a very sad story. A third-party seller can simply upload a random book or audiobook, and directly link it to your product page is very scary.