Reliable PostgreSQL Backup & Restore
Backups are limited. These days, pgbackrest is the go-to backup solution for PostgreSQL, and having used it I am very impressed so far. It provides full backups, differential, and incremental, as well as archiving of WAL segments for point in time recovery. It allows great flexibility in schedules and destinations for backups, how long to keep backups for, how many full backups. For example, you can have backups made to a local disk, and other backups to an external S3-compatible bucket, each with their own settings and schedules (e.g., scheduled via cron).
Build Postgres Extensions with Rust! (by tcdi)
Now we move to some of the other reasons why I lean away from managed databases overall. The first (but not most important) on the list is extensions. As part of my recent efforts to master my craft, including databases, I've become interested in the possibilities of extending the database. That includes using third party extensions, as well as developing my own. This is a theoretical criticism for now, as I have not yet had a need for this, but I can definitely foresee it as a possibility.
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
Show HN: pg_idkit, a Postgres extension for generating exotic UUIDs
3 projects | news.ycombinator.com | 11 Sep 2022
Introducing pg_idkit: an extension for generating lexicographically sortable UUIDs (UUIDv6-8, CUID, Timeflake) in Postgres
2 projects | reddit.com/r/PostgreSQL | 9 Sep 2022
GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation
2 projects | reddit.com/r/PostgreSQL | 23 Jul 2022
Creating a Postgres Foreign Data Wrapper
2 projects | news.ycombinator.com | 26 Jan 2022
Introducing Tuple Tricks
2 projects | reddit.com/r/rust | 22 Dec 2021