September 2025
-
24 Sep 2025🔗Using select_merge in Ecto for flexible aggregates
-
23 Sep 2025🔗Masterclass common table expressions CTEs) in SQL: from theory to practice with Elixir Ecto
-
18 Sep 2025🐥Adding an average column to SQL query results with window functions
-
17 Sep 2025🔗Inside ClickHouse full-text search: fast, native, and columnar
-
16 Sep 2025🔗Can you use ClickHouse for vector search?
-
14 Sep 2025🔗Why auto increment is a terrible idea
August 2025
-
31 Aug 2025🔗Why I don't use down migrations
-
29 Aug 2025🐥Granting a user privileges on a PostgreSQL database
-
24 Aug 2025🔗Handling unique indexes on large data in PostgreSQL
-
22 Aug 2025🔗37 things I learned about information retrieval in two years at a vector database company
-
4 Aug 2025🔗How to change a field type in an Ecto embedded schema with a migration
-
3 Aug 2025🔗The repository pattern, Ecto, and database-less testing
July 2025
-
29 Jul 2025🔗https://github.com/dimamik/torus
-
27 Jul 2025🔗Pass a query builder to “wherein” to reduce your DB queries
-
19 Jul 2025🔗Advanced inserts with Ecto
-
18 Jul 2025🔗Understanding consistency in databases: beyond basic ACID
-
10 Jul 2025🔗How to compose and refactor Ecto queries with queries modules
-
8 Jul 2025🔗OpenAI: Scaling PostgreSQL to the next Level
June 2025
-
29 Jun 2025🔗PostgreSQL 17 cluster config missing after upgrade on Ubuntu
-
23 Jun 2025🔗Phoenix.Sync
-
21 Jun 2025🔗Elegant transaction error handling in Laravel
-
18 Jun 2025🔗Entity status history using Ecto
-
5 Jun 2025🔗Using database comments to track columns with sensitive data