/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 pgdash.io
PostgreSQL Features You May Not Have Tried But Should - pgDash
| | mccue.dev
Life Altering Postgresql Patterns
3.6 parsecs away

Travel
| | [AI summary] Article detailing best practices and patterns for designing efficient Postgres database schemas and queries.
| | coussej.github.io
Listening to generic JSON notifications from PostgreSQL in Go
3.2 parsecs away

Travel
| | Thoughts and Ideas
| | hypirion.com
Implementing System-Versioned Tables in Postgres
4.4 parsecs away

Travel
| | There's no official support for system-versioned tables in Postgres yet, and the temporal extensions aren't supported on Azure/AWS/GCP. Let's implement it ourselves with 3 triggers and an index.
| | www.depesz.com
Variables in psql, how to use them? - select * from depesz;
33.2 parsecs away

Travel
| [AI summary] A technical guide explaining how to use input variables in the psql command-line interface for PostgreSQL, covering setup methods, proper quoting to prevent SQL injection and syntax errors, dynamic variable substitution, and integration with functions.