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