Posts tagged with "database"

November 2025

• 🔗

  How we scaled raw GROUP BY to 100 B+ rows in under a second
  5 Nov 2025
• 🐥

  Changing ownership of all objects in a PostgreSQL database
  4 Nov 2025
• 🔗

  Elixir Streams |> 🤩 Ecto's datetime helpers
  4 Nov 2025
• 🔗

  Fixing queries & adding indexes - Laravel in practice EP6
  1 Nov 2025

October 2025

• 🔗

  Full text search with Django and SQLite
  30 Oct 2025
• 🔗

  Get excited about Postgres 18
  29 Oct 2025
• 🐥

  Why indexing foreign key columns matters for cascade deletes in PostgreSQL
  27 Oct 2025
• 🔗

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

  Filtering users without a specific association in SQL
  24 Oct 2025
• 🔗

  Subtleties of SQLite indexes
  23 Oct 2025
• 🔗

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

  Why global scopes in Laravel are a good idea
  17 Oct 2025
• 🔗

  Small data
  16 Oct 2025
• 🐥

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

  Redis is fast - I'll cache in Postgres
  12 Oct 2025
• 🔗

  Why I keep business logic out of SQL
  11 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
• 🔗

  UUIDv7 comes to PostgreSQL 18
  25 Sep 2025
• 🔗

  Using select_merge in Ecto for flexible aggregates
  24 Sep 2025
• 🔗

  Masterclass common table expressions CTEs) in SQL: from theory to practice with Elixir Ecto
  23 Sep 2025
• 🐥

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

  Inside ClickHouse full-text search: fast, native, and columnar
  17 Sep 2025
• 🔗

  Can you use ClickHouse for vector search?
  16 Sep 2025
• 🔗

  Why auto increment is a terrible idea
  14 Sep 2025