Posts tagged with "database"

January 2025

• 🔗

  Eliminate Slow Queries with Ecto Telemetry
  22 Jan 2025
• 🔗

  You Don't Need Ecto.Multi
  19 Jan 2025
• 🔗

  Collection of Insane and Fun Facts About SQLite
  10 Jan 2025
• 🔗

  Databases in 2024: A Year in Review
  10 Jan 2025
• 🐥

  Troubleshooting blocked queries in PostgreSQL
  6 Jan 2025

December 2024

• 🔗

  Safe Ecto Migrations
  27 Dec 2024
• 🔗

  What I Wish Someone Told Me About Postgres
  25 Dec 2024
• 🔗

  Storing times for human events
  25 Dec 2024
• 🔗

  The Modifications I Make to Every New Phoenix Project
  24 Dec 2024
• 🔗

  SQL Best Practices: Don't Compare count(*) with 0
  22 Dec 2024
• 🔗

  Don't Do This in PostgreSQL
  21 Dec 2024
• 🔗

  Easy totals and subtotals in Postgres with rollup and cube
  18 Dec 2024
• 🔗

  Optimizing SQLite for servers
  17 Dec 2024
• 🔗

  Modelling `through` relationships with Ash
  9 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

• 🐥

  Dynamic order by using Phoenix Ecto
  27 Nov 2024
• 🐥

  Be careful with building delete statements using Laravel Query Builder
  26 Nov 2024
• 🔗

  Choosing the right Postgres indexes | Blog
  26 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
• 🔗

  How to Implement a Global Transaction for All Routes in Laravel
  20 Nov 2024
• 🐥

  The Hidden Dangers of Sorting and Pagination in MySQL: Handling Nullable Columns
  18 Nov 2024
• 🔗

  Prevent Destructive Commands From Running in Laravel
  3 Nov 2024