August 2025
-
π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
June 2025
-
πPostgreSQL 17 cluster config missing after upgrade on Ubuntu
-
πPhoenix.Sync
-
πElegant transaction error handling in Laravel
-
πEntity status history using Ecto
-
πUsing database comments to track columns with sensitive data
May 2025
-
π₯Tuning PostgreSQL query planning with SET STATISTICS
-
πPostgreSQL JSONB - Powerful Storage for Semi-Structured Data
-
π₯Fixing MySQL not starting on macOS (Homebrew Installation)
-
πElixir DBConnection pooling deep dive
-
π₯Checking the Redis server version of a running instance
-
π₯How to duplicate a table in PostgreSQL