Posts tagged with "mysql"

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
• 🔗 René Roth | Composite indexes in Laravel & MySQL 6 Mar 2024

February 2024

• 🐥 Indexing a JSON field in MySQL 22 Feb 2024

December 2023

• 🔗 Go and SQL: Pitfalls With Existing Libraries (and a Better Solution) 14 Dec 2023
• 🔗 Bulk Update Multiple Records with Separate Data with Laravel 7 Dec 2023

November 2023

• 🔗 What does INT(11) mean in MySQL? 1 Nov 2023

October 2023

• 🐥 Loading database query results into a Pandas DataFrame in Python 10 Oct 2023