PinnedInLevel Up CodingbyAndreas Sujono·Jul 27Mastering Databases, Part 3: Nobody Reads a Single RowYou asked for one row. Your database read 8,192 bytes. It did not do that because it is wasteful — it did that because reading one byte and…
PinnedInLevel Up CodingbyAndreas Sujono·Jul 18Mastering Databases, Part 2: A Table Is Not a SpreadsheetIt looks like a spreadsheet. It has rows, it has columns, you can sort it and scroll it. But a database table is a mathematical object with…
PinnedInLevel Up CodingbyAndreas Sujono·Jul 13Mastering Databases, Part 1: A Database Is Not a FileEvery app you have ever used sits on top of a database, and almost every developer treats it as a magic box: you send SELECT, rows come…
PinnedAndreas Sujono·Dec 17, 2022Top 10 Tricky Javascript Questions often asked by InterviewersTop 10 tricky Javascript questions often asked by interviewers. Make sure you know all of them!A response icon7A response icon7
PinnedInLevel Up CodingbyAndreas Sujono·Sep 17, 2022Ace Your Next React Interview16 most important React questions that you need to knowA response icon1A response icon1
Andreas Sujono·Aug 31Database University: Zero to HeroMost database knowledge arrives as scattered tips. Add an index here, avoid SELECT * there, and nobody ever shows you the machine those…
InLevel Up CodingbyAndreas Sujono·Aug 22Mastering Databases, Part 8: When the Disk Stops MatteringEvery article in this series has rested on one assumption: the disk is the bottleneck. That assumption is correct, it is how every database…
Andreas Sujono·Aug 11Mastering Databases, Part 7: One Machine Is Not EnoughSix parts ago we started with a text file. We now have a database that stores bytes efficiently, finds any row instantly, plans queries…
InLevel Up CodingbyAndreas Sujono·Aug 8Mastering Databases, Part 6: A Concurrent Queries and One Power CutEverything so far has quietly assumed your query is alone in the world. It is not. A thousand queries are running right now, reading and…
InLevel Up CodingbyAndreas Sujono·Aug 4Mastering Databases, Part 5: You Never Wrote the Query That RanThe SQL you typed is not the program that ran. Before a single byte was read, the database took your query apart, rewrote it into something…