Bookmarks (593)

Use Open Datasets & Open Source Tools to Chart the Spread of COVID-19 — Follow this step-by-step tutorial to run queries against COVID-19 case reports, use Grafana to plot your results on a world map, and share your findings.

A Tale About Migrating a Postgres Database Between Providers — A story from the folks at Percona about migrating a production Postgres database between two DBaaS platforms by using an intermediate server.

Stolon: A Cloud Native Manager for Postgres High Availability — The architecture document might help you understand how it operates.

A Tour of a Postgres Schema Design Process — This is aimed at users of PostGraphile, a Node.js-based tool for exposing Postgres databases via GraphQL, but it has value for anyone who’s designing a Postgres schema and covers tables, functions, triggers, roles, and some basic modelling.

pg_show_plans: Watching Execution Plans, Live — pg_show_plans is an extension that hooks into Postgres to give you a live view of all active query plans.

Amazon RDS Now Supports PostgreSQL 12 — We covered the launch of Postgres 12 last October and have linked to a lot of articles about all its neat new features since then, so if you’re an AWS user, you might be keen to know RDS now fully supports it, along with PostGIS 3.0.

Useful Queries for Postgres Index Maintenance — Basic and useful queries for index maintenance and how to use the catalog tables in writing such queries.

Postgres 13 to Enable BEFORE Row-Level Triggers for Partitioned Tables — Trigger support on partitioned tables will continue to get better.

Performance Differences Between Normal and Generic Audit Triggers — Triggers are useful for tracking changes in audit situations, but there are different approaches with different performance characteristics to consider.

Announcing an APT Package Archive for Postgres — apt-archive.postgresql.org is a new official archive of old Postgres packages covering versions back to 8.2.23 and Debian and Ubuntu versions back to around 2010.

Troubleshoot Postgres Performance with Datadog — Collect Postgres metrics and correlate them with related traces and logs for fast troubleshooting. Optimize performance with Datadog.

The Big Difference Between HAVING and WHERE Clauses — This is from the docs, but I saw it doing the rounds as an article that someone merely copied and pasted elsewhere (!) and found it useful nonetheless. In short, WHERE selects input rows before groups and aggregates are computed whereas HAVING selects group rows after groups and aggregates are computed.

Building and Testing a REST API in Go(lang) with Gorilla Mux and Postgres — A thorough walkthrough of how to build a simple and well-tested REST API backed by a Postgres database using Gorilla/Mux, a popular Go request router.

PGSync: Sync Postgres Data Between Databases — Fast, aims to provide good security, and you can sync partial tables or groups of tables. The README shows off some interesting examples. Written in Ruby.