proomt

Search

Search posts, papers, and topics

All posts

PostgreSQLPostgresCompare3 min readrelease notesintermediate

PostgresCompare 2.2.0 Released

Read on postgresql.org

Summary

PostgresCompare 2.2.0 is a major rewrite (Electron → Tauri) that adds pipelines, quick compare, data‑change scripting, an MCP server for AI‑driven migrations, parallel connections, and a CLI for schema export. UI is restyled, multilingual, and self‑updating. Supports PostgreSQL 9.2‑18 on Windows, macOS, Linux.

  • Rebuilt on Tauri: smaller binary, lower RAM, automatic updates.
  • New UI: modern theme, list view, spotlight search, keyboard navigation, six language translations.
  • Pipelines let you model env chains (dev‑test‑stage‑prod) as a graph; comparisons are edges with results displayed on the canvas.
  • Quick compare for ad‑hoc diff without a saved project; demo DB for first‑run walkthrough.

The rewrite reduces resource usage and adds self‑update, which matters for developers running multiple local DB instances. Pipelines and the MCP server enable automated CI/CD and AI‑assisted schema management, addressing drift detection and migration generation at scale. Parallel connections and di…

5/10
cliautomationaidatabasespostgres

Related reading

  1. Introducing Neon Labs

    Neon Labs is a new experimental web app (Next.js + TypeScript) that offers two PostgreSQL upgrade tools: a live‑catalog Upgrade Assessment that flags version‑specific blockers, and a Migration Assistant that auto‑generates import, pg_dump/restore, or logical‑replication pipelines based on DB size and downtime needs. The tools run read‑only against a Neon project, never expose connection strings,…

    Neonneon.com6 minrelease

  2. pgAssistant 3.8.0 : continuous improvement loop for Postgres

    pgAssistant 3.8.0 expands from a tuning advisor to a continuous PostgreSQL improvement platform, adding a Collector that records historical workload and environment data. It lets teams run an Observe‑Diagnose‑Prioritize‑Plan‑Implement‑Measure loop, compare consecutive snapshots, and measure the impact of applied recommendations.

    PostgreSQLpostgresql.org1 minrelease

  3. SQL Manager for PostgreSQL 7.0: meet the AI Assistant

    SQL Manager for PostgreSQL 7.0 adds an AI Assistant that can generate, explain, fix, and optimize SQL, produce migration scripts from schema diffs or business requirements, and lets users control how much schema is sent to the model. It supports multiple LLM providers and local Ollama deployments.

    PostgreSQLpostgresql.org1 minrelease

  4. Postgres week in the Netherlands: PGDay Lowlands & Percona Live 2026

    The author recaps two Dutch conferences where they presented ClickHouse‑Postgres extensions and discussed PostgreSQL 19 monitoring enhancements. The post explains how pg_clickhouse provides transparent query push‑down to ClickHouse and how pg_stat_ch streams per‑query metrics, plus new logging defaults and system views in PG 19.

    ClickHouseclickhouse.com7 min

  5. Introducing TIN: full-text search for Postgres

    PlanetScale’s TIN is a new PostgreSQL extension that implements a full‑text search index supporting Boolean, phrase, span, fuzzy, wildcard, regex, case/accent folding, COUNT(*) and BM25 top‑k queries. In a suite of benchmarks on an i7i.8xlarge EC2 instance (8 vCPU, 32 GB RAM), TIN built in 8 min 10 s (50.7 GB index) and outperformed ParadeDB, pg_textsearch and the built‑in GIN index by large marg…

    PlanetScaleplanetscale.com15 minHN20175

  6. Postgres on NVMe: performance and the convergence of transactions and analytics

    Local NVMe storage cuts Postgres I/O latency from ms to µs, yielding ~9× higher TPS and 10× lower transaction latency on a 482 GiB pgbench workload. The gain comes from reduced IO wait, not more CPU work. To retain durability, combine NVMe with quorum synchronous replication and continuous WAL archiving (WAL‑G). For analytics, offload scans to ClickHouse via WAL‑based CDC (pg_clickhouse or the ne…

    ClickHouseclickhouse.com8 min