Contribute Media
A thank you to everyone who makes this possible: Read More

Building effective Django queries with expressions

Translations: en en


This talk was presented at PyBay2019 - 4th annual Bay Area Regional Python conference. See for more details about PyBay and click SHOW MORE for more information about this talk.

Description In Django, we have a powerful tool called ORM to manipulate databases easily. For small queries, it can be quite simple, but what happens when you need to do tricks like nested queries or computed values? One of the answers is query expressions. In this talk, we'll learn how to power-up queries with them by walking through comparisons and examples with a dataset.

Abstract It's known that ORMs are a powerful tool to manipulate databases with ease. In Django, there are a set of out-of-the-box abstractions to help perform queries and shape them through annotations, aggregations, order by, and so on, hence saving one's time. A common solution to filtering when models grow larger over time is creating redundant fields; a better solution is using Django built-in resources called query expressions.

Query expressions are smart yet straightforward functions that one can use to compute values on query execution and do string manipulation, calculations, among others, thus removing the burden of having unnecessary extra columns in our database. Using query expressions effectively can help to generate performant queries, avoiding potential inconsistencies and separating concerns.

This talk focuses on further optimizing Django queries by walking through code comparisons and examples with a dataset, diving into subjects such as custom database functions, conditional expressions, and filtering so to answer questions about the data.

Original slides:

About the speaker I'm a full stack developer at Vinta Software ( and Django Girls organizer at my hometown, Recife. When not coding and working on personal projects, I'm usually cooking and watching Grey's Anatomy.

Sponsor Acknowledgement This and other PyBay2019 videos are via the help of our media partner AlphaVoice (!

#pybay #pybay2019 #python #python3 #gdb


Improve this page