code007
Joined 6 years ago
Karma
177
Submissions
8
Member since
Sep 10
Author of System Design Interview – An Insider's Guide. Previously Twitter, Apple and Zynga.
View on Hacker NewsRecent submissions
Comment · 3 years ago
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
Comment · 4 years ago
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
Comment · 4 years ago
In your opinion, what are the most important things to look for in a code review?
Comment · 4 years ago
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.