Building a Database Engine Part 2 - Calm, Clear Coding Tutorial

Build Your Own Tiny Database Index | Autism Friendly Coding Tutorial

In Part 1, we built a tiny database engine from scratch.

In this video, we're making it faster by adding one of the most important performance features used by real databases: indexes.

You'll learn what database indexes are, why they exist, and how they help databases find information without scanning every row in a table.

By the end of this tutorial, you'll understand one of the core ideas behind database performance and you'll have built a simple index yourself using plain JavaScript.

What You'll Learn

* Why table scans become slow
* What a database index actually is
* How indexes improve query performance
* Why indexes use additional memory
* How databases trade memory for speed
* How to build a simple index with JavaScript Maps

## Code Correction

One quick note:

In Part 1, our database engine included persistence using a JSON file.

In this video, I simplified the example to focus on indexing and accidentally omitted the persistence layer from the final code sample.

The index example still demonstrates the core indexing concepts correctly, but the database shown here does **not** save records to disk like the Part 1 version does.

Sorry about the oversight.
Prerequisites

* Basic JavaScript
* Basic Node.js
* Familiarity with the database engine from Part 1 is helpful but not required

Patreon

patreon.com/AutistiCoder

Supporters can access:

* Coding affirmations
* The AutistiCoder reference guide
* Additional resources to support your coding journey

If autism coding and autism friendly coding tutorials like this are helpful, subscribing is a great way to find your way back here.

Видео Building a Database Engine Part 2 - Calm, Clear Coding Tutorial канала AutistiCoder