- 🐥 TIL: Deleting duplicate rows in a database 14 Oct 2024
- 🔗 An ORDER BY statement improved our query times by 100x 24 Jul 2024
- 🐥 Using Laravel to format SQL statements 26 Jun 2024
- 🔗 Modern SQLite 25 Jun 2024
- 🐥 Importing CSV files into SQLite 21 Jun 2024
- 🐥 Indexing a JSON field in MySQL 22 Feb 2024
- 🔗 Go and SQL: Pitfalls With Existing Libraries (and a Better Solution) 14 Dec 2023
- 🐥 PostgreSQL database and table size 9 Nov 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
- 🔗 For each loops with LATERAL Joins 30 Sep 2023
- 🐥 Using a MySQL full text index with Laravel 24 Sep 2023
- 🐥 Using ROW_NUMBER with PARTITION BY in MySQL 16 Sep 2023
- 🔗 SQL join flavors 11 Aug 2023
- 🐥 Logging database queries in Laravel 30 May 2022
- 🐥 Optimising large whereIn queries in Laravel 2 Dec 2021
- 🐥 Enabling SQL logging in Django 8 Nov 2020