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
- Data Type Formatting Functions
- 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
- Join as Little as Possible ()
- Postgres TIL: Multi-Line Copy in psql ()
- Postgres TIL: SECURITY DEFINER ()
- Query this Blog with DuckDB ()
Posts tagged programming
- The Socratic Programmer ()
- Cursed MacOS GUI Programming with Odin ()
- Make your own NeoVim Theme ()
- Building Emacs 31 with Tree-Sitter Support on MacOS ()
- Query this Blog with DuckDB ()
- Write Game UIs like a Caveman ()
- Being a Professional Programmer ()
- Godot Virtual Joystick ()
- Making a Lichess TV Viewer with Hyperscript ()