Resources on SQL
Last updated
Websites
- All you need is PostgreSQL
- modern-sql.com — Markus Winand
- Postgres Weekly
- Row Level Security — Bennie Swart (Postgres Conference 2019 slides)
- Simplify: move code into database functions
- Use the Index, Luke! — Markus Winand (also available as SQL Performance Explained)
- www.craigkerstiens.com — Craig Kerstiens
Books
- Database in Depth — C.J. Date
- SQL for Smarties — Joe Celko
- SQL Performance Explained — Markus Winand
Documentation
- Postgres
- JSON Functions and Operators
- PL/pgSQL — SQL Procedural Language
- PL/pgSQL is very useful for writing complex migrations or pushing business logic into your database.
- Postgres Wiki
- Window Function Calls
- Windowing in SQL is great for analytical queries and it offers more options for whenever basic
GROUP BYs and aggregate functions break down.
- Windowing in SQL is great for analytical queries and it offers more options for whenever basic
- psql (PostgreSQL interactive terminal)
- A few psql tricks (
\ito run SQL from a local file,\oto route output to a local file,\copyfor… copying) can go a long way. - If you use vim-dadbod to connect to Postgres from Vim/NeoVim, all the features in psql are suddenly available directly in your editor.
- A few psql tricks (
Resources tagged sql
Resources tagged programming
Posts tagged sql
- Postgres TIL: Multi-Line Copy in psql ()
- Postgres TIL: SECURITY DEFINER ()
- Query this Blog with DuckDB ()