Idee e spostamenti che contano per chi progetta, costruisce e gestisce software—una lettura breve per restare al passo col mestiere.
Categoria
There is a kind of database pain that does not arrive dramatically. It arrives quietly. A query runs longer than expected. A session stays occupied. Someone opens another connection just to keep moving. Then another task shows up behind…
We are excited to announce Percona Operator for PostgreSQL 2.9.0! In this release, we bring significant improvements across database lifecycle management, security, backup/restore, and operational observability, making it easier than ever…
Most MongoDB pain isn't a MongoDB problem. It's a workload shape problem that would follow you to Postgres.
Benchmarking MyRocks vs. InnoDB in Memory-Constrained Environments It is a well-known fact in the database world that InnoDB is incredibly fast when the entire database fits into memory. But what happens when your data grows beyond your…
A disclaimer before we start: I'm product management, no longer an engineer. I can read code, I can write it … incredibly slowly. I understand PostgreSQL at a product level, and I know what questions to ask. But the code in this project…
Software engineering is evolving into agentic engineering. According to the Stack Overflow Developer Survey 2025, 84% of respondents use or plan to use AI tools in their development, up from 76% the previous year. At this rate, the tooling…
I have been doing Oracle-to-PostgreSQL migrations for over last decades across enterprises, cloud platforms, and everything in between. I have used commercial tools, cloud-native services, and custom scripts. And when it comes to table DDL…
Patroni is a widely used solution for managing PostgreSQL high availability. It provides a robust framework for automatic failover, cluster management, and operational simplicity in PostgreSQL environments. Patroni offers many powerful…
I’ll be honest with you. I’m old school. My IDE is vim. My PostgreSQL client is psql. I’ve been using it for almost 20 years and I still think it’s the best PostgreSQL client out there. I might be biased. When I joined a new team recently,…
Introduction Most PostgreSQL users use prepared statements as a way to boost performance and prevent SQL injection. Fewer people know that the query planner silently changes the execution plan for prepared statements after exactly five…
From March 23 to March 26, the following contributions were made to PostgreSQL at SREcon26 (Americas): PostgreSQL booth volunteers: Aya Griswold Erika Miller Gabrielle Roth Jennifer Scheuerell Umair Shahid Alex Wood PostgreSQL speakers:…
In my current position as Database Architect at DRW, I talk with end users more than I ever did in my life. Our end users are application developers who look at PostgreSQL from a very utilitarian perspective. Trust me, they do not care…