Posts tagged with "sql"

December 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

November 2023

• 🐥 PostgreSQL database and table size 9 Nov 2023

October 2023

• 🔗 dsq: Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more 19 Oct 2023
• 🔗 Go database driver overhead on insert-heavy workloads 19 Oct 2023
• 🔗 'Talk' to your SQL database using LangChain and Azure OpenAI 14 Oct 2023
• 🐥 Loading database query results into a Pandas DataFrame in Python 10 Oct 2023
• 🐥 Combining virtual columns with indexes in Laravel Eloquent 3 Oct 2023

September 2023

• 🔗 For each loops with LATERAL Joins 30 Sep 2023