Posts tagged with "mysql"

October 2025

• 🔗

  Batch updates and advanced inserts in Ecto for Elixir
  27 Oct 2025
• 🔗

  The hidden cost of MySQL defaults in Laravel apps
  22 Oct 2025
• 🐥

  Speeding up large Eloquent IN queries with temporary tables
  15 Oct 2025

September 2025

• 🔗

  SQL performance improvements: finding the right queries to fix (part 1)
  27 Sep 2025
• 🐥

  Making a copy of a MySQL database
  26 Sep 2025
• 🐥

  Adding an average column to SQL query results with window functions
  18 Sep 2025

June 2025

• 🔗

  Using database comments to track columns with sensitive data
  5 Jun 2025

May 2025

• 🐥

  Fixing MySQL not starting on macOS (Homebrew Installation)
  22 May 2025

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