This week’s system design refresher:
-
Cloud-native vs. Cloud computing (Youtube video)
-
Visualizing a SQL question
-
Evolution of programming languages
-
Linux Storage Stack Diagram
-
Job openings
Dev Interrupted is the No. 1 supply for what the neatest minds in growth are fascinated by, investing in & engaged on.
Hear career-changing knowledge by leaders from corporations like Slack, Stripe, and Shopify delivered to your inbox each week. These are insights you’ll be able to’t Google.
SQL statements are executed by the database system in a number of steps, together with:
-
Parsing the SQL assertion and checking its validity
-
Reworking the SQL into an inner illustration, reminiscent of relational algebra
-
Optimizing the interior illustration and creating an execution plan that makes use of index info
-
Executing the plan and returning the outcomes
The execution of SQL is extremely advanced and entails many issues, reminiscent of:
Over to you: what’s your favourite SQL assertion?
C, C++, Java, Javascript, Typescript, Golang, Rust…
How do programming languages evolve over the previous 70 years?
The diagram beneath reveals a short historical past of programming languages.
-
Perforated playing cards have been the primary era of programming languages. Meeting languages, that are machine-oriented, are the second era of programming language. Third-generation languages, that are human-oriented, have been round since 1957.
-
Early languages like Fortran and LISP proposed rubbish assortment, recursion, exceptions. These options nonetheless exist in fashionable programming languages.
-
In 1972, two influential languages have been born:…
