Posts tagged with "sql"

February 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

June 2024

• 🐥 Using Laravel to format SQL statements 26 Jun 2024
• 🔗 Modern SQLite 25 Jun 2024
• 🐥 Importing CSV files into SQLite 21 Jun 2024

February 2024

• 🐥 Indexing a JSON field in MySQL 22 Feb 2024

December 2023

• 🔗 Go and SQL: Pitfalls With Existing Libraries (and a Better Solution) 14 Dec 2023