Jayson Falkner gave a talk at a recent Django Meetup in San Francisco on the advanced use of Django’s QuerySet API based on lessons learned at Counsyl.
Below are the slides and audio.
You’ll learn how to debug, optimize and use the QuerySet API efficiently. The main examples focus on demystifying how QuerySet maps to SQL and how seemingly simple Python code, presumably fast O(1) queries, can result in unacceptably long runtime and often O(N) or worse queries. Solutions are provided for keeping your Python code simple and RDMS use performant.
Jayson’s code can be found on GitHub.
Jayson Falker is a software developer for Counsyl. He has an EEN/CS degree and a PhD in Bioinformatics. He is a long-time open-source Linux/Java/Web developer, book author, and presenter. He has focused on proteomics and genomics research since the mid-2000’s, including working for a few years at startups and for Dow AgroSciences. Jayson is quick to get his geek on and also loves to build ridiculous side-projects, including a 6′ tall Jenga set that weighs 300lbs and mobile apps that give you awesome virtual mustaches.
September 22, 2020
Honoring Evan’s Memory: Raising Awareness About Tay-Sachs Disease
When I gave birth to my first child, Evan, in August of 1994, my husband Jeff and I were elated. After nine long…Read more about Honoring Evan’s Memory: Raising Awareness About Tay-Sachs Disease
August 26, 2020
New York Photographer’s Connection to Breast Cancer Helps Shape Myriad’s New Message of Human Understanding
Meet Katie McCurdy*. She is a talented photographer who has traveled the world to create vibrant, expressive images that capture authentic and intimate moments. She is also the…Read more about New York Photographer’s Connection to Breast Cancer Helps Shape Myriad’s New Message of Human Understanding
June 16, 2020
Remote Solutions to Assess Reproductive Risk
In March, ASRM recommended that fertility care providers delay any but the most urgent reproductive care cases to mitigate the…Read more about Remote Solutions to Assess Reproductive Risk