SQL Queries For Git Repositories
tl;dr: "A command-line tool for running SQL queries on git repositories meant for ad-hoc querying of git repositories on disk through a common interface (SQL)."featured in #199
Some SQL Tricks of an Application DBA
- Haki Benita tl;dr: Haki shares "non-trivial tips" around database development with explanations, such as (1) update only what needs updating (2) disable constraints and indexes during bulk loads, and morefeatured in #196
SQL Queries Don't Start With SELECT
tl;dr: Having written thousands of queries, Julia realized she didn't know the exact order a query ran. She notes the order and runs through how DB engines optimize queries.featured in #155
10 Ways to Tweak Slow SQL Queries
- Helen Anderson tl;dr: Useful tips and checklist to ensure your SQL queries are optimized and well written.featured in #153