5 Best SQL Games To Master Database Skills In 2025
- Hristo Bogoev tl;dr: “Instead of grinding through another dry tutorial, you can learn SQL by solving crimes, escaping islands, or competing with other programmers. These 5 SQL games actually make database learning fun - and they work better than traditional methods.”featured in #624
The Art Of SQL Query Optimization
- Jan Nidzwetzki tl;dr: “In a few evenings of vibe coding, I implemented the plan explorer for PostgreSQL. It iterates over a search space and generates visualizations that show when the plan changes and how many tuples are expected versus the actual number returned. This blog post examines the “art” of query optimization. It discusses the plan explorer tool, the images the tool generates, and the insights the tool provides into the decisions made by the PostgreSQL query optimizer.”featured in #622
featured in #620
Leadership Power Tools: SQL And Statistics
- Matt Blewitt tl;dr: “A common pattern I’ve seen over the years have been folks in engineering leadership positions that are not super comfortable with extracting and interpreting data from stores, be it databases, CSV files in an object store, or even just a spreadsheet. We’re going to cover SQL & DuckDB, then some useful statistical tools: summary stats, distributions, confidence intervals and Bayesian reasoning.”featured in #578
featured in #568
featured in #554
featured in #553
featured in #546
How SQL Query Works? SQL Query Execution Order For Tech Interview
tl;dr: “While SQL queries are written in a declarative, human-readable format, there is a complex process that occurs behind the scenes to execute these queries and retrieve the desired results. In this article, we'll delve into the inner workings of SQL queries, breaking down the process step by step.”featured in #529
How We Built Text-to-SQL At Pinterest
tl;dr: “We took the rise in availability of LLMs as an opportunity to explore whether we could assist our data users with this task by developing a Text-to-SQL feature which transforms these analytical questions directly into code.” The authors describe the tools evolution and implementation.featured in #507