Data & SQL
TOMLOct 22, 2026pyproject with Ruff and pytest
Official Bits example. A compact pyproject.toml with project metadata, Ruff formatting rules and pytest defaults.
tomlpythontoolingpackaging
001
PythonOct 22, 2026Read CSV into dictionaries
Official Bits example. Parse a CSV file into a list of dictionaries using the standard library and explicit UTF-8 handling.
datacsvpythonfiles
001
JuliaOct 22, 2026Grouped totals with a Dict
Official Bits example. Accumulate grouped totals in plain Julia, then print them in deterministic key order.
datascriptingjuliaaggregation
001
SQLOct 22, 2026
PostgreSQL upsert
Official Bits example. Insert a row or update selected columns on conflict, then return the stored values in one statement.
constraintsupsertpostgresqlsql
000
SQLOct 22, 2026
Recursive CTE for a tree
Official Bits example. Walk an adjacency-list category tree from its roots and track depth with a recursive CTE.
recursive-ctepostgresqltreessql
000