My Database as a Developer

You can write a query. But do you know what happens after you press Enter?

My Database as a Developer takes you behind the SQL — into the storage engine, the query optimizer, the concurrency layer, and the system that has to stay alive when a thousand users hit it at once.

Across 8 chapters and a final synthesis, this book covers:

→ How databases physically store data using pages, buffer pools, and B-Trees

→ How to design schemas, choose data types, and avoid the mistakes that cost you months later

→ How queries are actually executed — parsed, planned, and run — and why some are fast and others destroy performance

→ How indexes work internally and the common patterns that silently break them

→ How concurrency, isolation levels, locking, and MVCC protect data when many operations run at once

→ How systems fail under load — and the patterns that keep them stable

Every chapter ends with a real engineering incident conversation showing the concepts in a production context, not a classroom.

This book is for software engineers, backend developers, DBAs, data engineers, technical leads, and self-learners who want to understand databases from the inside out.

No CS degree required. Real experience required.