Loading...

Tag trends are in beta. Feedback? Thoughts? Email me at [email protected]

How to Get or Create in PostgreSQL

Fastest Way to Read Excel in Python

The surprising impact of medium-size texts on PostgreSQL performance (2020)

Lesser Known Postgres Features (2021)

An unexpected find that freed 20GB of unused index space (2021)

Outliers can trick the optimizer into the wrong plan

The many faces of DISTINCT in Postgres (2017)

Future Proofing SQL with Carefully Placed Errors

Handling Concurrency Without Locks

Lesser Known PostgreSQL Features

One Database Transaction Too Many

Practical SQL for Data Analysis

Exciting New Features in Django 3.2

The Unexpected Find That Freed 20GB of Unused Index Space in PostgreSQL

Simple Anomaly Detection Using Plain SQL

Re-Introducing Hash Indexes in PostgreSQL

Exhaustiveness Checking with Mypy

The Surprising Impact of Medium-Size Texts on PostgreSQL Performance

Simple Anomaly Detection Using Plain SQL

Some SQL Tricks of an Application DBA

Practical Dependency Injection in Python

Using Markdown in Django

Understand Group by in Django with SQL

Common Mistakes and Missed Optimization Opportunities in SQL

How "Export to Excel" Almost Killed Our System

How to Get the First or Last Value in a Group Using Group By in SQL

Fastest Way to Load Data into PostgreSQL Using Python

Improve Serialization Performance in Django Rest Framework

How to Let Google Know of Other Languages in Your Django Site

How to Use Grouping Sets in Django

More →