Lesser Known PostgreSQL Features
A list of useful features you already have, but may not know about! In this article I share lesser known features of PostgreSQL.
-
-
One Database Transaction Too Many
A story about how I ended up sending hundreds of users messages saying they got paid when they didn't! In the process we've learned a valuable lesson about nested transactions and Django signals.
-
Practical SQL for Data Analysis
Pandas is by far the most popular tool for data analysis. It's packed with useful features, it's battle tested and widely accepted. However, pandas comes at a cost which is often overlooked. SQL databases has been around since the 1970s. They contain many features that most developers never heard of, and I want to bring some of them to light.
-
Exciting New Features in Django 3.2
Django 3.2 is just around the corner and it's packed with new features. Django versions are usually not that exciting (it's a good thing!), but this time many features were added to the ORM, so I find it especially interesting!
-
The Unexpected Find That Freed 20GB of Unused Index Space
In this article I describe the process we took to identify potential free space, and one surprising find that helped up clear up ~10GB of unused indexed values!
-
Re-Introducing Hash Indexes in PostgreSQL
There is a type of index you are probably not using, and may have never even heard of. It is wildly unpopular, and until a few PostgreSQL versions ago it was highly discouraged and borderline unusable, but under some circumstances it can out-perform even a B-Tree index.
-
Exhaustiveness Checking with Mypy
What if mypy could warn you about possible problems at "compile time"? In this article I share a little trick to get mypy to fail when a value in an enumeration type is left unhandled.
-
The Surprising Impact of Medium-Size Texts on PostgreSQL Performance
Any database schema is likely to have plenty of text fields. In this article I demonstrate the surprising impact of medium-size texts on query performance.
-
Simple Anomaly Detection Using Plain SQL
Many developers think that having a critical bug in their code is the worse thing that can happen. Well, there is something much worst than that: Having a critical bug in your code and not knowing about it! Using some high school level statistics and a fair knowledge of SQL, I implemented a very simple anomaly detection system.
-
Some SQL Tricks of an Application DBA
Some tips and misconceptions about database development I gathered along the way.
-
