~postgresweekly | Bookmarks (155)
-
extension-ecosystem-jobs-tools.md
Towards an Ideal Postgres Extension Ecosystem — Tembo hired David Wheeler, creator of PGXN, to work...
-
Load StackOverflow’s StackExchange data in Postgresql®
How to Load Stack Overflow's StackExchange Data into Postgres — It’s an interesting process in itself,...
-
Instant Realtime GraphQL APIs on PostgreSQL database
Instant Realtime GraphQL APIs on PostgreSQL with Hasura — Connect Hasura to your PostgreSQL database and get...
-
Tuning Autovacuum for best Postgres performance
eBook: Tuning Autovacuum for Best Postgres Performance — Learn about tuning settings for scheduling and performance,...
-
One PID to Lock Them All: Finding the Source of... | Crunchy Data Blog
One PID to Lock Them All: Finding the Source of the Lock — One process can...
-
Postgres FM | pgvector
▶ Jonathan Katz on pgvector — Postgres core team member Jonathan Katz went on the Postgres.fm podcast...
-
POSETTE: An Event for Postgres 2024
POSETTE: Citus Con Renames for 2024 — Microsoft has run the virtual Citus Con event for...
-
How to use PostgreSQL® SUBSTRING
🍕 How to Use SUBSTRING — String slicing and dicing.. along with a little pizza, in this case.
-
Apache AGE
Apache AGE 1.5rc: A Graph Extension for Postgres — AGE provides graph database functionality (by way...
-
GitHub - ANXS/postgresql: Fairly full featured Ansible role for Postgresql.
A 'Fairly Full Featured' Ansible Role for Postgres — An Ansible 2.4+ role that installs and...
-
pgmoneta
pgmoneta: A Backup / Restore Solution for Postgres — Formerly a Red Hat project, but now...
-
GitHub - supabase/supa_audit: Generic Table Auditing
supa_audit: Generic Table Auditing for Postgres — A generic solution for tracking changes to tables’ data...
-
GitHub - laurenz/oracle_fdw: PostgreSQL Foreign Data Wrapper for Oracle
oracle_fdw: A Foreign Data Wrapper for Oracle Database — Provides efficient access to Oracle databases, including...
-
GitHub - fabianlindfors/reshape: An easy-to-use, zero-downtime schema migration tool for Postgres
Reshape 0.7: A Zero-Downtime Schema Migration Tool — During a migration, Reshape ensures both the old...
-
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.
-
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...
-
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...
-
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...
-
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...
-
Crunchy Bridge - Managed, Cloud Postgres
❤️ Postgres — You need a database provider that loves Postgres as much as you do. We'll...