December 2024
-
🔗Optimizing SQLite for servers
-
🔗Modelling `through` relationships with Ash
-
🔗UUID, ORM and Strange Deadlocks
-
🔗Introduction to Ecto.Multi
-
🔗Historized Attributes: Systematic Table Design
November 2024
-
🐥Dynamic order by using Phoenix Ecto
-
🐥Be careful with building delete statements using Laravel Query Builder
-
🔗Choosing the right Postgres indexes | Blog
-
🔗How to do a preload good using Ecto
-
🐥How to add relative percentages to MySQL query results
-
🔗How to Implement a Global Transaction for All Routes in Laravel
-
🐥The Hidden Dangers of Sorting and Pagination in MySQL: Handling Nullable Columns
-
🔗Prevent Destructive Commands From Running in Laravel
October 2024
-
🔗Search is not magic with PostgreSQL
-
🔗IEx "any" Helper
-
🔗Optimizing Postgres table layout for maximum efficiency
-
🐥TIL: Deleting duplicate rows in a database
-
🔗Proposal to make MariaDB the default MySQL variant in Ubuntu 25.04
-
🔗PostgreSQL: Full text search with the "websearch" syntax
-
🐥Backing up a PostgreSQL database
-
🔗PostgreSQL and UUID as primary key
-
🔗Stop using SERIAL in Postgres
-
🔗Building RAG with Postgres
-
🔗Tree hierarchies in Laravel