Posts tagged with "mysql"

November 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
• 🔗 Database Migrations 5 Oct 2023
• 🔗 Demystifying Database Transactions 4 Oct 2023
• 🐥 Combining virtual columns with indexes in Laravel Eloquent 3 Oct 2023

September 2023

• 🔗 For each loops with LATERAL Joins 30 Sep 2023
• 🔗 Upsert in SQL 29 Sep 2023
• 🐥 Using a MySQL full text index with Laravel 24 Sep 2023
• 🐥 Drop column if exists in a Laravel migration 23 Sep 2023