[Ebook] Andrew Brookins - The Temple of Django Database Performance

The Temple of Django Database Performance​

This book is a blueprint for becoming a senior Django developer who can jump into any Django project, profile slow pages and APIs, and tune the underlying database queries.

And this is not just another boring technical tome: it’s a mashup of deep technical content and fantasy table-top gaming, filled with full-color maps, characters, and creatures.

Master Django Performance​

Explore deadly ruins while learning to make Django apps blazing fast. Veteran Python developer Andrew Brookins guides you through dangers in this book on database performance tuning.​

About the Book​

Want to be an expert Django developer? Master performance. An expert can jump into any Django project, profile slow pages and APIs, and tune the underlying database queries.
Caching can only take you so far. You need to go deeper, to the source. And most performance problems in Django start in the same place. The database.
But database performance tuning in Django involves a dizzying number of ORM API methods. And all this rests on top of the already complex machinery of SQL queries and indexes.
To fully master database performance with Django, reading through API documentation is not enough. You need to become an expert. Here are some examples of what an expert knows that this book will teach you:

• How to use profiling and measurement tools like New Relic, Django Debug Toolbar, and database query plans to see exactly how badly a query performs in production
• How to eyeball a query and know exactly the right index to speed it up (a covering index with INCLUDE? a partial index? a GIN index? You’re going to tell me by the end of the book because YOU will be the expert)
• How to use advanced techniques like server-side cursors with iterator(), custom Func() expressions, and keyset pagination with row comparisons to churn through millions of rows of data with ease

You will learn all this and more through over 160 pages, 60 examples, and 30 quiz questions. By the end, you won’t ever think of a Django ORM query the same again: it will exist simultaneously in your mind as an operational metric, ORM syntax, generated SQL, and a database execution plan. Because you will be an expert.
I can teach this because I have over ten years of experience working with Django and relational databases, both as an application developer and a platform engineer building databases as a service for Compose.com and IBM Cloud.
And did I mention that you’re going to have fun? Yes, you read that right. This book is chock full of awesome fantasy art including a map of each chapter’s core concepts. Why fantasy art? Because I play tabletop role-playing games and I require books to be fun.
So, gaze upon the Sacrificial Cliff of Profiling. Get lost in the Labyrinth of Indexing. Ransack the Crypt of Querying. Then get back to kicking ass and saving the world from unbounded queries!

About the Author​

Andrew Brookins​

---

I have over ten years of experience working with Django and relational databases. That experience spans DevOps, application development, and platform engineering.
I've worked on ecommerce sites, mobile APIs, comic book readers, particle simulation systems, learning and volunteering apps, and Databases as a Service. Today I'm a Software Engineer at Redis Labs.
The constant across all of these domains? Databases and application performance are always intertwined! Time and again, I've applied the knowledge from this book to solve performance problems in Django applications by focusing my attention on profiling, indexes, and querying techniques.
Here's what I ask of you: let me share this experience, so that someone other than my employers and me can benefit from it. I'll rest easier knowing that I've successfully passed the Torch of Performance-Tuning.