Posts tagged with "database"

January 2026

• 🔗

  How to run PostgreSQL in Docker
  24 Jan 2026
• 🔗

  Building a RAG server with PostgreSQL - part 1: loading your content
  23 Jan 2026
• 🔗

  It's a match!
  23 Jan 2026
• 🔗

  From dev to production for a small Phoenix project
  23 Jan 2026
• 🔗

  Ordering database queries by relationship columns in Laravel
  22 Jan 2026
• 🔗

  What is better: a lookup table or an enum type?
  21 Jan 2026
• 🐥

  Extracting unique IDs from JSON arrays in MySQL
  20 Jan 2026
• 🔗

  How SQLite is tested
  17 Jan 2026
• 🔗

  Building a double-entry payment system in Elixir
  11 Jan 2026
• 🔗

  SQLite as an application file format
  10 Jan 2026
• 🔗

  A modern guide to SQL JOINs
  8 Jan 2026
• 🐥

  Sorting case insensitive in SQLite with COLLATE NOCASE
  6 Jan 2026
• 🔗

  What I learned building a vector database on object storage
  6 Jan 2026
• 🔗

  Virtual fields in Ecto: Eliminating N + 1 queries
  2 Jan 2026

December 2025

• 🔗

  PostgreSQL: filtering with COUNT()
  28 Dec 2025
• 🔗

  Building a simple search engine that actually works
  26 Dec 2025
• 🔗

  Stop loading large Ecto fields by default
  25 Dec 2025
• 🔗

  Postgres internals hiding in plain sight
  21 Dec 2025
• 🔗

  Mnesia tips for Elixir developers
  20 Dec 2025
• 🔗

  Ash framework: calculations and uncertainty
  19 Dec 2025
• 🔗

  Scaling HNSWs
  17 Dec 2025
• 🔗

  Laravel Tip: cleaner OR queries using whereAny()
  16 Dec 2025
• 🔗

  Delete your old migrations, today
  16 Dec 2025
• 🔗

  Unique indexes with some rows excluded
  15 Dec 2025
• 🔗

  Cursor Pagination for PostgreSQL & MySQL: Complete Developer Guide 2025
  11 Dec 2025