PostgreSQL 19.0 released, offers interactive browser-based tutorial
PostgreSQL 19.0 was released on 19 November 2026, adding SQL features such as IGNORE NULLS, get-or-create inserts, JSON export, JSONPath transformations and range subtraction, along with planner and replication improvements. A companion sandbox lets users run these features live against real PostgreSQL 19 servers, including logical and physical replication setups.
GoKawiil's interpretation of the reporting above, not reported fact.
Offering a hands-on, browser-based environment could lower the barrier for developers evaluating whether to upgrade, since they can test new SQL behavior and replication changes without setting up their own infrastructure. The emphasis on comparing directly against PostgreSQL 18 suggests the maintainers want adopters to verify performance and behavior claims themselves rather than take benchmarks on faith.
- PostgreSQL 19.0 was released on 19 November 2026 with new SQL capabilities and replication/maintenance updates.
- An interactive sandbox allows users to test features like JSONPath transformations and range subtraction against live servers.
- The tutorial includes logical (port 5433) and physical (port 5434) replication demos alongside a primary instance on 5432.
O'Reilly PostgreSQL: Up and Running — If you're digging into PostgreSQL 19's new SQL features and replication internals, a solid reference guide helps you connect the dots between hands-on experiments and underlying concepts. This book covers administration, querying, and replication fundamentals that remain relevant as the database evolves. It's a handy companion for anyone running real servers and wanting deeper context beyond the release notes.
See O'Reilly PostgreSQL: Up and Running on Amazon → Affiliate link — we may earn a commission on purchases, at no extra cost to you. Product picked by AI based on this article; it is not a tested recommendation.Source: certuvia.com — Nov, 2026-11-20
Published there as: “PostgreSQL 19: A hands-on tour with runnable browser examples”
Read the original report → The summary and analysis above are GoKawiil's own, written from reporting by the source above. Facts and quotes belong to the original publisher.