Posts tagged with "sql"

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
• 🔗

  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
• 🔗

  Accessing Databases in PhpStorm
  21 Nov 2024
• 🐥

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

October 2024

• 🔗

  Search is not magic with PostgreSQL
  29 Oct 2024
• 🐥

  TIL: Deleting duplicate rows in a database
  14 Oct 2024

July 2024

• 🔗

  An ORDER BY statement improved our query times by 100x
  24 Jul 2024