proomt

Search

Search posts, papers, and topics

All posts

NeonSavannah Longoria6 min readrelease notesintermediate

Introducing Neon Labs

Read on neon.com

Summary

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,…

  • Upgrade Assessment reads pg_catalog/info_schema of a live Neon DB, matches findings against version‑specific rules, and classifies each as blocker, warning, or clear.
  • Migration Assistant picks one of three paths: Import Data Assistant (<10 GB), pg_dump/pg_restore (10‑200 GB), or logical replication (>200 GB) and automates the complex steps for the latter.
  • Logical‑replication automation includes schema copy, publication/subscription creation, WAL lag monitoring, sequence drift correction, pre‑cutover ANALYZE, and safe teardown.
  • Known migration pain points (sequence drift, missing stats, unsupported extensions, event‑trigger re‑fires, etc.) are explicitly handled or highlighted.

Major PostgreSQL upgrades (e.g., 14→19) are error‑prone due to schema changes, extension compatibility, and data‑size constraints. Neon Labs codifies the checklist and migration plumbing, turning a manual, ad‑hoc process into a repeatable, observable workflow—valuable for teams on Neon and potentia…

5/10
devopsarchitecturedatabasespostgresmigration

Related reading

  1. Neon is now available in Grok Bot

    Neon released a Grok Bot plugin that lets the AI assistant manage Neon PostgreSQL databases. After a one‑time auth, the bot can create projects, spin up isolated branches, run SQL, list databases, and set up usage‑summary routines directly from chat.

    Neonneon.com1 min

  2. Neon Functions: backend logic next to your data

    Neon Functions are server‑less Node.js 24 compute that run on the same branch and region as Neon’s Lakebase Postgres, giving low‑latency DB access, long‑running connections for agents/WebSockets, automatic credential injection, and branch‑aware deployment via neon.ts. They’re meant for data‑adjacent backend logic, not full‑stack hosting, and future plans include native cron and event triggers.

    Neonneon.com5 min

  3. WAL + S3: Lakebase storage for the era of agents

    Neon's Lakebase Postgres redefines database storage by making the WAL the source of truth, stored on S3, rather than data files. This transaction-centric approach enables instant branching, time travel, and scalable, decoupled compute and storage for Postgres.

    Neonneon.com14 minHN4

  4. Electric is joining team Neon at Databricks

    Databricks announced that the Electric team, creators of the WASM‑compiled Postgres engine PGlite and a real‑time sync layer, is joining Neon. The integration adds an embedded Postgres database and continuous sync primitive to Neon’s platform, aiming to lower compute costs for small, agent‑driven apps.

    Neonneon.com3 minHN82

  5. Just landed in the Neon CLI

    Neon renamed its CLI to `neon` and added a suite of commands for agent onboarding, branch‑first development, diagnostics, credential management, schema diffing, API fallback, snapshots, auth, Data API, and a built‑in psql client. The post lists usage examples and flags for each new feature.

    Neonneon.com5 minrelease

  6. Query Neon backend logs

    Neon has introduced new capabilities to query backend logs for Neon Functions and Object Storage outside of the console. This includes a new CLI, API, SDK, and direct Loki endpoint access, allowing unified log inspection across different backend services on a branch.

    Neonneon.com3 min