Posts tagged with "mysql"

April 2025

• 🔗 Why are database columns 191 characters? 20 Apr 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

• 🔗 MySQL can do more than you think 28 Jan 2025
• 🔗 SQL NULLs are Weird! 23 Jan 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

• 🔗 MySQL ORDER BY with nulls first or last (at bottom or top) 29 Sep 2024

August 2024

• 🔗 Add columns with custom types in Laravel Migrations 8 Aug 2024

June 2024

• 🔗 Database Design for Google Calendar: a tutorial 10 Jun 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

March 2024

• 🔗 Laravel Read / Write Connections use multi-database 27 Mar 2024
• 🔗 Offload the majority of requests to your database with our newest update to Standby Nodes 27 Mar 2024