October 2025
-
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🔗Actually doing things in user’s time zone
-
27 Oct 2025🔗Batch updates and advanced inserts in Ecto for Elixir
-
12 Oct 2025🔗Redis is fast - I'll cache in Postgres
-
1 Oct 2025🔗Adding Postgres full text search to an Ash project
September 2025
-
25 Sep 2025🔗UUIDv7 comes to PostgreSQL 18
-
18 Sep 2025🐥Adding an average column to SQL query results with window functions
-
14 Sep 2025🔗Why auto increment is a terrible idea
-
12 Sep 2025🐥Vector embeddings with Ash, OpenAI, and PostgreSQL
-
11 Sep 2025🐥Setting up AshPostgres.Extensions.Vector
-
3 Sep 2025🔗Keyset cursors, not offsets, for Postgres pagination
August 2025
-
29 Aug 2025🐥Granting a user privileges on a PostgreSQL database
-
24 Aug 2025🔗Handling unique indexes on large data in PostgreSQL
-
20 Aug 2025🔗Ecto, on_replace and deferred checks
-
13 Aug 2025🔗Advanced Ecto for Elixir monitoring with AppSignal
-
9 Aug 2025🔗Full text search in the age of MCP
-
4 Aug 2025🔗How to change a field type in an Ecto embedded schema with a migration
-
1 Aug 2025🔗Normalize chart data using Ecto and PostgreSQL
July 2025
-
29 Jul 2025🔗https://github.com/dimamik/torus
-
8 Jul 2025🔗OpenAI: Scaling PostgreSQL to the next Level