~postgresweekly | Issue 538 - A new monster of an SQL query (11)
-
Happy New Year: GPT in 500 lines of SQL - EXPLAIN EXTENDED
Implementing GPT in 500 Lines of SQL — When an article pitches itself as demonstrating ‘a...
-
Waiting for PostgreSQL 17 – ALTER TABLE command to change generation expression – select * from depesz;
Postgres 17's ALTER TABLE Command to Change Generation Expressions — When you CREATE a table, you can...
-
Crunchy Bridge - Managed, Cloud Postgres
❤️ Postgres — You need a database provider that loves Postgres as much as you do. We'll...
-
Introducing pg_query for Postgres 16 - Parsing SQL/JSON, Windows support, PL/pgSQL parse mode & more
Introducing pg_query for Postgres 16 — pg_query is a long standing standalone library (with Ruby, Rust...
-
Optimizing PostgreSQL functions with preloaded libraries
Optimizing Postgres Functions with Preloaded Libraries — Thanks to extensions, it’s possible to write Postgres functions...
-
Waiting for Postgres 17: Incremental base backups
▶ Waiting for Postgres 17: Incremental Base Backups — Walking through the incremental backup feature committed to...
-
Postgres password encryption without leaking credentials
Password Encryption Without Leaking Credentials — Logs and proxies can sometimes open up unexpected holes into...
-
Postgres Postmaster File Explained | Crunchy Data Blog
The postmaster.pid File Explained — A short file with a long history.
-
Procrastinate documentation
Procrastinate 1.1: Postgres-Based Task Queue for Python — A distributed task processing library for Python 3.8+...
-
Steampipe | select * from cloud;
Steampipe: Query Your Cloud Services with SQL — Use SQL to query and even join across...
-
GitHub - orgrim/pg_back: Simple backup tool for PostgreSQL
pg_back 2.2.0: A Simple, Thorough Backup Tool for Postgres — A tool for dumping your databases...