Efficient PostgreSQL Query Writing: Avoiding Common Anti-Patterns and ORM Pitfalls
Presented by:
Haonan Wang
No video of the event yet, sorry!
As PostgreSQL continues to grow in popularity, it's important for developers to write efficient queries that can handle large amounts of data without sacrificing performance. In this talk, we'll explore some of the most common anti-patterns in query writing and discuss how to avoid them when working with PostgreSQL. Additionally, we'll focus on how using an ORM to develop applications, specifically Django's ORM, can lead to inefficient database queries. We'll show some common anti-patterns in our customers' queries using real-world examples. We'll also discuss how to write Django code that generates efficient PostgreSQL queries, highlighting the functions and methods that should be used to optimize query performance. We'll provide tips and best practices for addressing common issues and improving your PostgreSQL database performance when writing queries and using Django's ORM.
- Date:
- 2023 April 21 11:10 PDT
- Duration:
- 20 min
- Room:
- Santa Clara, Lvl C
- Conference:
- Silicon Valley 2023
- Language:
- Track:
- Dev
- Difficulty:
- Medium