Posts tagged with "sql"

November 2025

• 🔗

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

October 2025

• 🐥

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

  Actually doing things in user’s time zone
  27 Oct 2025
• 🐥

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

  Why I keep business logic out of SQL
  11 Oct 2025

September 2025

• 🐥

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

  Keyset cursors, not offsets, for Postgres pagination
  3 Sep 2025

August 2025

• 🐥

  Granting a user privileges on a PostgreSQL database
  29 Aug 2025

May 2025

• 🐥

  How to duplicate a table in PostgreSQL
  8 May 2025
• 🔗

  Try PostgreSQL's citext
  3 May 2025

March 2025

• 🔗

  How PostgreSQL's Aggregate FILTER Will Spoil You
  13 Mar 2025

February 2025

• 🔗

  Scalar and binary quantization for pgvector vector search and storage
  25 Feb 2025
• 🔗

  HNSW Indexes with Postgres and pgvector | Crunchy Data Blog
  25 Feb 2025
• 🐥

  Finding the latest version of each record using SQL
  14 Feb 2025
• 🔗

  Don't use NOT IN in PostgreSQL
  9 Feb 2025
• 🐥

  Getting the size of all postgres databases on a server
  4 Feb 2025

January 2025

• 🐥

  Troubleshooting blocked queries in PostgreSQL
  6 Jan 2025

December 2024

• 🔗

  Safe Ecto Migrations
  27 Dec 2024
• 🔗

  Storing times for human events
  25 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
• 🐥

  Pretty-printing SQL using Elixir
  15 Dec 2024
• 🔗

  Historized Attributes: Systematic Table Design
  3 Dec 2024

November 2024

• 🔗

  SQL style guide
  30 Nov 2024