~postgresweekly | Bookmarks (34)

pgddl / ddlx: DDL EXtractor Functions — An SQL-only extension that can create SQL DDL (e.g. CREATE TABLE) for system catalogs / table schemas, etc. since using pg_dump doesn’t suit every scenario.

pgvector-remote: A pgvector Fork to Work with Remote Vectors — Pinecone only, for now. There's a blog post introducing the idea.

node-pg-migrate 7.0: Database Migration Management for Postgres — Lots of cleanups and refactoring from the project’s new maintainer, Shinigami, also a core maintainer of Vite.

Postgres + SQLite = pglite? — Not to be confused with the PGlite WASM build of Postgres, this is a quick Go-powered proof of concept to put the Postgres wire protocol in front of SQLite.

trdsql: Tool to Execute SQL Queries Upon Text-Based Data — A CLI tool that can execute SQL queries (in Postgres or MySQL syntax) on CSV, LTSV, JSON, YAML and TBLN files. It can also be used as a library within Go apps.

Vasco: MIC & MINE Statistics Extension — Maximal information coefficient (MIC) and maximal information-based nonparametric exploration (MINE) are statistical measures that can be used to explore multi-dimensional datasets and find important relationships within them.

pgmock: An In-Memory Postgres for Unit/E2E Testing — No external dependencies and runs entirely within WebAssembly on both Node.js and the browser. Here’s how it works.

Slonik v38: The Sophisticated Postgres Client for Node.js — A ‘battle tested’ framework offering strict types, detailed logging, abstracts repeating code patterns, protects against unsafe behavior, as well as a rich debugging experience.

WAL-G 3.0: Database Archive Restoration Tool — A tool for database archival and restoration for Postgres, MySQL/MariaDB, MongoDB, and several other DBMSs – v3.0 introduces failover storage, plus a WAL archiving daemon for Postgres in particular.

pgzx: Create Postgres Extensions using Zig — If you’re familiar with pgrx as a way to build Postgres extensions with Rust, this is a similar idea with Zig, another modern systems language that’s a little more C-like than Rust.

pg_jsonschema 0.3: JSON Schema Validation Extension — Postgres’s support for JSON / JSONB columns is second to none, but what if you want to validate the structure of JSON data? JSON Schema provides a way to define JSON-based formats and this extension lets you verify JSON documents using such schemas. v0.3 completes the extension’s Postgres 16 support.

pg_activity 3.5: htop-Like Activity Monitoring Tool — Much as you might use top or htop to monitor processes and CPU usage, pg_activity gives you a similar look behind the scenes of Postgres with views over running queries, up to date performance stats, and more.

pg_ivm 1.8: Incremental View Maintenance Extension — IVM can update materialized views incrementally, which is more efficient than a full recomputation as REFRESH MATERIALIZED VIEW does.

pg-lock-tracer: An eBPF-Based Lock Tracer — Use eBPF instrumentation to dig into lock-related bottlenecks in Postgres when running on Linux. Unlike with pg_locks, you get a continuous view of the locking activity and timings, and can produce animated views of locks.

PGlite: Postgres in WebAssembly — People have brought Postgres into WebAssembly contexts before, though usually with a Linux VM layer sat in between. PGlite packages a WASM build of Postgres into a TypeScript library that can be run in the browser or on Node.js or Bun and is only 3.7MB gzipped! An exciting development - we look forward to seeing where it goes next.

Schemalint 1.1: A Linter for Postgres Schemas — A linter that lets you raise errors on issues like casing or column types (so think more like ESLint than a basic formatter).

libpqxx 7.9: The Official C++ Client API for Postgres — It’s a pretty big release, says the maintainer, and the last one to support C++17 with libpqxx 8.0 set to demand C++20. Main repo.

IntegreSQL: API to Manage Isolated Postgres Databases for Testing — Provides a RESTful JSON API for managing Postgres templates and spinning up (and managing the pool of) databases for integration testing purposes.

Directus 10.9: Wrap an SQL Database with a Real-Time GraphQL and REST API — A Node.js-based system that can act as a frontend to Postgres, SQLite, MySQL, Oracle, and other databases, providing a modern dashboard, client, and REST and GraphQL APIs. (Note the unusual license that limits production use to below a certain revenue level then reverts to GPL in three years.)

pgenv: Postgres Binary Manger for the Shell — Makes it simpler to build and run different Postgres releases and switching between them to test, etc. It's just gained a status command for getting the status of a specific instance.

PGTera: Extension to Render Tera HTML Templates — Tera is a Jinja2-inspired template engine for Rust, and if you need to return complete, rendered HTML views from your database, it's another option.

pg_show_plans: Show Query Plans of All Running Statements — Lets you get live access via SELECT * FROM pg_show_plans or you can see it joined against pg_stat_activity via the pg_show_plans_q view.