SQL Optimization: a comprehensive developer’s guide
A SQL optimization guide for developers. With best practices, warnings, pro tips to speed up your SQL optimization.
Tag: sql
How to print Prisma raw SQL query and optimize it
In modern application development, we often abstract direct access to the database layer from the application layer using an ORM. This allows us to worry less about exactly how the data is retrieved using SQL, and more about writing our application. That said: there are scenarios where it’s useful to examine and optimize the underlying… Continue reading How to print Prisma raw SQL query and optimize it
5 Ways to implement NOT EXISTS in PostgreSQL
When building an application, usually we query our database to retrieve the things we already know: what orders a client made or, more generally, what steps in the app flow have already been taken. However, to correctly address the user journey, it is often more important to query the database and retrieve data that informs… Continue reading 5 Ways to implement NOT EXISTS in PostgreSQL