browse/
75 results
databases/the-n-1-query-problem-why-a-page-that-asks-the-database-501-questions.md
The N+1 query problem: why a page that asks the database 501 questions is slow
A page that lists authors and their books can quietly send one query per author. With 500 authors that is 501 trips to the database, and…
computers/fetch-decode-execute-the-three-beat-loop-every-cpu-repeats-billions-of.md
Fetch, decode, execute: the three-beat loop every CPU repeats billions of times a second
A processor looks clever, but at its core it repeats one small loop billions of times a second: fetch an instruction, decode what it asks…
languages/generators-how-a-python-function-can-pause-in-the-middle-and-pick-up-w.md
Generators: how a Python function can pause in the middle and pick up where it left off
A generator is a Python function that can pause halfway, hand you a value, and carry on later from the same line with its variables intact…
security/two-factor-codes-how-your-phone-and-a-website-agree-on-six-digits-with.md
Two-factor codes: how your phone and a website agree on six digits without talking
Your authenticator app shows six digits and the website expects the same six, yet the two never talk. How? Both sides start from the same…
infrastructure/environment-variables-how-the-same-code-talks-to-a-practice-database-o.md
Environment variables: how the same code talks to a practice database on your laptop and the real one online
The same program can talk to a practice database on your laptop and the real one on a live website, without a single edit to its code. The…
computer-science/hash-tables-how-a-computer-finds-one-name-among-thousands-without-chec.md
Hash tables: how a computer finds one name among thousands without checking them all
Your phone finds one contact among thousands without reading them all. The trick is a hash table: a row of numbered slots and a small…
databases/transactions-why-a-money-transfer-must-save-both-changes-or-neither.md
Transactions: why a money transfer must save both changes or neither
Sending £50 between two accounts takes two changes to a database. If the power fails between them, the money vanishes. A transaction groups…
computers/the-call-stack-why-a-function-that-never-stops-crashes-your-program.md
The call stack: why a function that never stops crashes your program
Every time a function is called, the computer puts a small block of memory called a frame on top of a call stack, and removes it when the…
ai/gradient-descent-how-a-computer-learns-a-number-by-rolling-downhill.md
Gradient descent: how a computer learns a number by rolling downhill
How does a computer learn a number? It can't solve for it in one go. It tries a guess, measures how wrong it is, and nudges the guess…
security/sql-injection-how-a-quote-mark-in-a-login-form-can-rewrite-the-databas.md
SQL injection: how a quote mark in a login form can rewrite the database's question
A login form builds a database question out of the words you type. If it glues your text straight into the question, your text can rewrite…
infrastructure/percentiles-why-an-average-response-time-of-235-ms-can-hide-users-wait.md
Percentiles: why an average response time of 235 ms can hide users waiting 3 seconds
Your dashboard says the average response time is 235 milliseconds, yet some users wait three seconds. Both can be true, because an average…
computer-science/stacks-and-queues-why-undo-takes-the-newest-item-and-a-printer-takes-t.md
Stacks and queues: why undo takes the newest item and a printer takes the oldest
Press undo and the last thing you typed disappears first. Send documents to a shared printer and the first one is printed first. Both are…