~postgresweekly | Bookmarks (149)
-
✂️ Use Cases for Merging and Splitting Partitions With Minimal Locking in PostgreSQL 17
Use Cases for Merging and Splitting Partitions with Minimal Locking in Postgres 17 — Some interesting...
-
GitHub - noborus/trdsql: CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
trdsql: Tool to Execute SQL Queries Upon Text-Based Data — A CLI tool that can execute...
-
Postgres Roles and Privileges
Postgres Roles and Privileges — A follow along, tutorial style, guide to understanding how roles and...
-
GitHub - viggy28/pglite: postgres + sqlite = pglite
Postgres + SQLite = pglite? — Not to be confused with the PGlite WASM build of...
-
PostgreSQL 17 features I am most waiting for
The Postgres 17 Features I'm Most Waiting for — It’s still several months away, but Postgres...
-
Ten years of improvements in PostgreSQL's optimizer · Ryan Marcus
📊 Ten Years of Improvements in Postgres's Optimizer — “I decided to run the join order benchmark...
-
Optimize Your PostgreSQL Database | OtterTune
Improve Postgres Performance and Reduce Costs with OtterTune — Automatically tune and optimize knobs, plus get...
-
General Availability | Supabase
Supabase Declares 'General Availability' — I hadn’t noticed Supabase has been rocking ‘beta’ all this time,...
-
GitHub - Florents-Tselai/vasco: vasco: MIC & MINE statistics for Postgres
Vasco: MIC & MINE Statistics Extension — Maximal information coefficient (MIC) and maximal information-based nonparametric exploration...
-
Improved query cancellation in PostgreSQL 17 and Psycopg 3.2
Improved Query Cancellation in Postgres 17 and Psycopg 3.2 — Postgres 17 will gain some improved...
-
GitHub - stackframe-projects/pgmock: In-memory Postgres for unit/E2E tests
pgmock: An In-Memory Postgres for Unit/E2E Testing — No external dependencies and runs entirely within WebAssembly...
-
Awesome Postgres
Awesome Postgres: A Curated List of 200+ Libraries, Tools, and Resources — A handy, curated resource...
-
PostgreSQL Stories: A simple query with a big problem | Render Blog
A Simple Query with a Big Problem — “Most of the time, PostgreSQL invisibly optimizes our...
-
POSETTE: An Event for Postgres 2024
Save the Date for POSETTE: An Event for Postgres — Wondering who will be speaking at...
-
Protect Your PostgreSQL Database with pg_tde: Safe and Secure
Protect Your Database with pg_tde (Transparent Data Encryption) — A tech preview release of an extension...
-
Compiling PostgreSQL on macOS To Test Documentation and Patches
Compiling Postgres on macOS to Test Documentation and Patches — One developer’s experience compiling and installing...
-
Building the Best PostgreSQL GUI: PopSQL Joins Timescale
Building the Best Postgres GUI? PopSQL Joins Timescale — The team behind the PopSQL collaborative SQL...
-
Announcing pl/dotnet, version 0.99 (beta)
Announcing PL/.NET 0.99: A Public Beta Release — pl/dotnet adds full support for C# and F#...
-
Berkubernetus (@fuzzychef@m6n.io)
R.I.P. Postgres Maintainer Simon Riggs — It’s with much sadness we share the news that Postgres...
-
Best pg_basebackup compression settings for v15 and above
Best pg_basebackup Compression Settings for v15+
-
Building a Managed Postgres Service in Rust: Part 1 | Tembo
Building a Managed Postgres Service in Rust: Part 1 — A little peek behind the scenes...
-
Real-time text translation using the azure_ai extension in Azure Database for PostgreSQL
Real-Time Text Translation using the azure_ai Extension in Azure Database for PostgreSQL
-
journald and syslog logging in PostgreSQL
journald and Syslog Logging in Postgres — Using journald and syslog logging with Postgres isn’t a...
-
Taming PostgreSQL WAL File Growth - pgDash
Taming WAL File Growth — A quick introduction to the Write Ahead Log subsystem in Postgres,...