[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_28":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"routes/_store+/_readers+/email_author.$slug/route",{"_9":10,"_11":-5},"book",{"_12":13,"_14":15,"_16":17,"_18":19,"_20":21,"_22":23},"currentUser","id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvODAzNjY","title","My Database as a Developer","state","published","contactAuthorMethod","email","aboutText","

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.

","authors",[24],{"_12":25,"_26":27,"_28":29},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci84NTkyNw","name","Esther Agboniro","user",{"_30":31},"avatar",{"_32":33,"_34":35,"_36":37},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/3739945/medium/avatar.jpg?1782239069","styleName","medium","exists",true,"shoppingCartId","shoppingCart",{"_12":71,"_72":73,"_74":37,"_75":76,"_77":78,"_79":80,"_81":37},"locale","en","readerTheme","light","constants",{"_69":70},"publishers",{"_65":66,"_67":68},"learnerOrganizations",[],"needsLocaleCookieSync",false,"announcements",{"_59":60,"_61":-5},"sentryEnvironment","production","sentryRelease","cce21d19a0d9612afdbced29947de1d8868e588b","announcement_store",{"_62":52,"_63":64},"announcement_authors","flag","text","

Kick off your book project, get started with GhostAI, get better at marketing, or spend the day doing all three! Free live workshops on Zoom. Saturday, June 27, 2026.

\n","companies",[],"universities",[],"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","no-cart","count",0,"free","updatedAt","","paymentGateway","STRIPE","cartItems",[],"loading"]

Email the Author