May 2025
April 2025
February 2025
-
🐥Updating the enum values of a database column definition
-
🐥Finding the latest version of each record using SQL
-
🔗Articles - High Performance SQLite
January 2025
December 2024
-
🔗Safe Ecto Migrations
-
🔗UUID, ORM and Strange Deadlocks
-
🔗Introduction to Ecto.Multi
-
🔗Historized Attributes: Systematic Table Design
November 2024
-
🔗SQL style guide
-
🔗How to do a preload good using Ecto
-
🐥How to add relative percentages to MySQL query results
-
🔗Accessing Databases in PhpStorm
-
🐥The Hidden Dangers of Sorting and Pagination in MySQL: Handling Nullable Columns
October 2024
-
🐥TIL: Deleting duplicate rows in a database
-
🔗Proposal to make MariaDB the default MySQL variant in Ubuntu 25.04
September 2024
August 2024
June 2024
May 2024
-
🐥Using Laravel migration with different databases
-
🐥Purging the MySQL binlogs
-
🐥Caveat with MySQL full-text search and testing