December 2025
-
9 Dec 2025🐥Upgrading PostgreSQL from 16 to 18 on Ubuntu
-
9 Dec 2025🔗Optimizing filtered vector queries from tens of seconds to single-digit milliseconds in PostgreSQL
-
9 Dec 2025🔗Dependency management in database design
-
8 Dec 2025🔗Ecto types in Elixir: a hidden feature that simplifies your code
-
1 Dec 2025🔗Do you really need tsvector column?
November 2025
-
29 Nov 2025🔗Granting read only access to a Postgres database on DigitalOcean
-
27 Nov 2025🔗Cleaner Eloquent relationship queries in Laravel 12 with withFiltered()
-
27 Nov 2025🔗Function-based indexes - database tip
-
21 Nov 2025🔗Tips for efficient data queries in ASP.NET Core
-
20 Nov 2025🔗We re-built our integration service using Postgres and Go
-
18 Nov 2025🔗Strategic pagination patterns for .NET APIs
-
17 Nov 2025🔗Pipelining in psql (PostgreSQL 18)
-
14 Nov 2025🔗SQL anti-patterns you should avoid
-
13 Nov 2025🔗Why UUIDs won't protect your secrets
-
8 Nov 2025🔗PostgreSQL 18 new features
-
5 Nov 2025🔗How we scaled raw GROUP BY to 100 B+ rows in under a second
-
4 Nov 2025🐥Changing ownership of all objects in a PostgreSQL database
-
4 Nov 2025🔗Elixir Streams |> 🤩 Ecto's datetime helpers
-
1 Nov 2025🔗Fixing queries & adding indexes - Laravel in practice EP6
October 2025
-
30 Oct 2025🔗Full text search with Django and SQLite
-
29 Oct 2025🔗Get excited about Postgres 18
-
27 Oct 2025🐥Why indexing foreign key columns matters for cascade deletes in PostgreSQL
-
27 Oct 2025🔗Batch updates and advanced inserts in Ecto for Elixir
-
24 Oct 2025🐥Filtering users without a specific association in SQL
-
23 Oct 2025🔗Subtleties of SQLite indexes