May 2025
March 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
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