February 2025
-
5 Feb 2025🔗Faster similarity search performance with pgvector indexes
-
4 Feb 2025🐥Getting the size of all postgres databases on a server
-
4 Feb 2025🔗TIL Ecto Constraints and Validations
January 2025
-
28 Jan 2025🔗MySQL can do more than you think
-
27 Jan 2025🔗Avoiding the soft delete anti-pattern
-
24 Jan 2025🐥Updating pgvector to the latest version
-
23 Jan 2025🔗SQL NULLs are Weird!
-
22 Jan 2025🔗Eliminate Slow Queries with Ecto Telemetry
-
19 Jan 2025🔗You Don't Need Ecto.Multi
-
10 Jan 2025🔗Collection of Insane and Fun Facts About SQLite
-
10 Jan 2025🔗Databases in 2024: A Year in Review
-
6 Jan 2025🐥Troubleshooting blocked queries in PostgreSQL
December 2024
-
27 Dec 2024🔗Safe Ecto Migrations
-
25 Dec 2024🔗What I Wish Someone Told Me About Postgres
-
25 Dec 2024🔗Storing times for human events
-
24 Dec 2024🔗The Modifications I Make to Every New Phoenix Project
-
22 Dec 2024🔗SQL Best Practices: Don't Compare count(*) with 0
-
21 Dec 2024🔗Don't Do This in PostgreSQL
-
18 Dec 2024🔗Easy totals and subtotals in Postgres with rollup and cube
-
17 Dec 2024🔗Optimizing SQLite for servers
-
9 Dec 2024🔗Modelling `through` relationships with Ash
-
7 Dec 2024🔗UUID, ORM and Strange Deadlocks
-
6 Dec 2024🔗Introduction to Ecto.Multi
-
3 Dec 2024🔗Historized Attributes: Systematic Table Design