September 2025
-
πSQL performance improvements: finding the right queries to fix (part 1)
-
π₯Making a copy of a MySQL database
-
πUUIDv7 comes to PostgreSQL 18
-
πUsing select_merge in Ecto for flexible aggregates
-
πMasterclass common table expressions CTEs) in SQL: from theory to practice with Elixir Ecto
-
π₯Adding an average column to SQL query results with window functions
-
πInside ClickHouse full-text search: fast, native, and columnar
-
πCan you use ClickHouse for vector search?
-
πWhy auto increment is a terrible idea
August 2025
-
πWhy I don't use down migrations
-
π₯Granting a user privileges on a PostgreSQL database
-
πHandling unique indexes on large data in PostgreSQL
-
π37 things I learned about information retrieval in two years at a vector database company
-
πHow to change a field type in an Ecto embedded schema with a migration
-
πThe repository pattern, Ecto, and database-less testing
July 2025
-
πhttps://github.com/dimamik/torus
-
πPass a query builder to βwhereinβ to reduce your DB queries
-
πAdvanced inserts with Ecto
-
πUnderstanding consistency in databases: beyond basic ACID
-
πHow to compose and refactor Ecto queries with queries modules
-
πOpenAI: Scaling PostgreSQL to the next Level