David optimizes a slow query by splitting up a left join into two calls and using UNION ALL to combine them. The proof is in the pudding.
Which of my applications ran this SQL statement? Use SQL comments to track which application ran which queries.
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
Today we’re excited to introduce support for major PostgreSQL upgrades in PGO v5.1. Using the new PGUpgrade API, you can now seamlessly upgrade your clusters across major versions of PostgreSQL.
We're excited to announce the general availability of version 5.1 of PGO, the open source Postgres Operator from Crunchy Data. In addition to providing a seamless upgrade experience across both PGO and PostgreSQL versions, this feature-packed release also introduces many powerful new capabilities.
With Postgres Container Apps you can, from directly inside Postgres with a simple function call, spin up a container that is running right alongside your Postgres database!
Fun with PostgreSQL! Using the French Wordle list, this post shows you some sql to find out the most often used letters in a table, how to reduce possibilities once you’ve found some letters, and how to solve wordle puzzles using the back end.
New feature release for PGO v5.0.5 Initializing your Postgres database with backups from AWS S3, GCS or Azure.