Reading up on sql
6 deep · digging since jan 25
- Statistics that live in your SQL
the-stats-duck v0.6.0 adds OLS regression, bootstrap, expanded distributions, and a Vega-Lite plot grammar to DuckDB SQL.
- Free SQL→ER diagram tool, runs in the browser, nothing uploaded
A developer built a free, open-source browser-based tool that converts SQL CREATE TABLE statements into interactive ER diagrams without uploading data to any server.
- Full-Text Search with DuckDB
DuckDB's full-text search extension offers BM25 scoring, stemming, and stop-word removal but lacks result highlighting and phrase queries.
- Drunk post: Things I've learned as a senior engineer (2021)
A senior engineer's drunken list of candid career advice criticizes interview processes, praises dynamic languages, and emphasizes documentation and financial planning.
- Visualize MySQL query execution plans as interactive FlameGraphs
Myflames converts MySQL EXPLAIN ANALYZE JSON into interactive flamegraph SVGs and a compact text digest that reduces LLM input tokens by 75% for query diagnosis.
- Show HN: repere – Local-first SQL data explorer using DuckDB WASM
Repere is a local-first SQL data explorer that runs entirely in the browser via DuckDB WASM, enabling private, serverless spreadsheet-style querying and transformation of CSV, JSON, Parquet, or Excel files.