Posts tagged with "database"

December 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

October 2024

• 🔗

  Search is not magic with PostgreSQL
  29 Oct 2024
• 🔗

  IEx "any" Helper
  26 Oct 2024
• 🔗

  Optimizing Postgres table layout for maximum efficiency
  21 Oct 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
• 🔗

  PostgreSQL: Full text search with the "websearch" syntax
  13 Oct 2024
• 🐥

  Backing up a PostgreSQL database
  11 Oct 2024
• 🔗

  PostgreSQL and UUID as primary key
  11 Oct 2024
• 🔗

  Stop using SERIAL in Postgres
  8 Oct 2024