Posts tagged with "database"

December 2025

• 🔗

  Do you really need tsvector column?
  1 Dec 2025

November 2025

• 🔗

  Granting read only access to a Postgres database on DigitalOcean
  29 Nov 2025
• 🔗

  Cleaner Eloquent relationship queries in Laravel 12 with withFiltered()
  27 Nov 2025
• 🔗

  Function-based indexes - database tip
  27 Nov 2025
• 🔗

  Tips for efficient data queries in ASP.NET Core
  21 Nov 2025
• 🔗

  We re-built our integration service using Postgres and Go
  20 Nov 2025
• 🔗

  Strategic pagination patterns for .NET APIs
  18 Nov 2025
• 🔗

  Pipelining in psql (PostgreSQL 18)
  17 Nov 2025
• 🔗

  SQL anti-patterns you should avoid
  14 Nov 2025
• 🔗

  Why UUIDs won't protect your secrets
  13 Nov 2025
• 🔗

  PostgreSQL 18 new features
  8 Nov 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