» Tag

postgresql

46 posts

Jul 21, 20267.50
Transitioning to Desired-State Reference Data in PostgreSQL
Desired-state reference data in PostgreSQL simplifies data model management.
data databases postgresql reference-data
Jul 20, 20267.51
The Challenge of Adding a Column in the Middle of a PostgreSQL Table
Explore the complexities of adding columns in PostgreSQL and its data storage structure.
databases migration performance postgresql
Jul 11, 20267.50
Noisia: Harmful Workload Generator for PostgreSQL
Noisia is designed for PostgreSQL, generating harmful workload scenarios for testing purposes.
database performance postgresql testing
Ad
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.com
Jul 8, 20267.50
Multigres Brings Listen/Notify to Pooled Postgres Connections
Multigres uses a shared listener connection and a two-level fan-out to make Postgres listen/notify scale cleanly across pooled connections.
connection-pooling database-engineering distributed-systems multigres
Jul 7, 20267.50
Microsoft's DocumentDB Reimagines NoSQL on PostgreSQL
Microsoft open-sourced its vCore Cosmos DB engine as DocumentDB, a PostgreSQL-based NoSQL layer with MongoDB-compatible APIs, BSON support, and ambitions to become a NoSQL standard.
azure databases mongodb nosql
Jul 7, 20267.50
pg_stat_ch Streams PostgreSQL Query Telemetry into ClickHouse
pg_stat_ch is an open-source PostgreSQL extension that streams raw per-query telemetry to ClickHouse, offloading analytics from the database engine.
clickhouse database observability postgresql
Jul 7, 20267.50
PostgreSQL Batch UPSERT with CTE: From 90 Seconds to 5
An email sync process with audit history was rewritten from separate queries into a single PostgreSQL CTE, cutting 100k-row processing time from 90 seconds to 5.
backend database-performance go postgresql
Aug 14, 20267.41
Systemic Risks in the Managed PostgreSQL Industry: Extension Risks Are Real
Research reveals critical security vulnerabilities in managed PostgreSQL extensions, emphasizing risks for engineers.
extensions managed-services postgresql security
Aug 12, 20267.40
Sqlfmt: A gofmt-style Formatter for SQL
Sqlfmt is a tool that formats SQL queries in a gofmt style, inspired by PostgreSQL books.
formatting gofmt postgresql sql
Aug 6, 20267.31
PgColumnar: A Columnar Database Extension for PostgreSQL 15
PgColumnar is a column-oriented storage extension for PostgreSQL 15, optimized for analytics and data compression.
analytics columnar database data_storage