code007
Re:Visualizing a SQL Query
on Wednesday March 08, 2023 @01:38PM (#35072980)
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
Data Structures That Power Your Databases. Which one should we pick?
How to Choose the Right Database?
Re:Algorithms you should know before you take system design interviews
on Thursday August 11, 2022 @09:50PM (#32433961)
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
Algorithms you should know before you take system design interviews
Re:Show HN: Code reviews intimidated me, so I built a course on how to...
on Wednesday March 30, 2022 @01:45PM (#30858449)
In your opinion, what are the most important things to look for in a code review?
Re:A sad story about self-publishing a tech book and fraud on Amazon
on Wednesday January 26, 2022 @11:55AM (#30088010)
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.