📊PostgreSQL 19 Beta 3 Adds Property Graphs and More
PostgreSQL 19 brings property graphs and new query features
TL;DR
PostgreSQL 19 beta 3 introduces property graphs, ON CONFLICT DO SELECT, and FOR PORTION OF. Developers can now query property graphs using pattern matching and leverage new query features for more efficient data manipulation.
PostgreSQL 19 beta 3 introduces property graphs, ON CONFLICT DO SELECT, and FOR PORTION OF. Property graphs allow developers to query complex relationships without writing joins, making data manipulation more efficient. ON CONFLICT DO SELECT lets you query existing rows without modifying them, while FOR PORTION OF enables trimming or splitting rows based on range columns. If you're working with complex data relationships or need precise control over updates, PostgreSQL 19's new features will streamline your workflows. PostgreSQL 19 beta 3 was released on August 13, 2026, with general availability expected around September or October 2026.
Key Points
PostgreSQL 19 beta 3 released on August 13, 2026, with general availability expected around September or October 2026.
Property graphs can be declared over existing tables using the CREATE PROPERTY GRAPH command, allowing pattern matching queries.
ON CONFLICT DO SELECT returns existing rows without modifying them, useful for locking and decision-making.
FOR PORTION OF enables trimming or splitting rows based on a range column, offering precise control over updates.
PostgreSQL 19 implements SQL/PGQ, the property-graph part of SQL:2023, enhancing query capabilities.
Why It Matters
If you're working with complex data relationships in PostgreSQL, property graphs simplify querying without joins. ON CONFLICT DO SELECT and FOR PORTION OF offer precise control over updates and locking. These features streamline workflows for developers managing complex data structures.
Frequently Asked Questions
Why does this matter?
If you're working with complex data relationships in PostgreSQL, property graphs simplify querying without joins. ON CONFLICT DO SELECT and FOR PORTION OF offer precise control over updates and locking. These features streamline workflows for developers managing complex data structures.
What happened?
PostgreSQL 19 beta 3 introduces property graphs, ON CONFLICT DO SELECT, and FOR PORTION OF. Developers can now query property graphs using pattern matching and leverage new query features for more efficient data manipulation.
Comments
Be the first to comment
Enjoyed this article?
Get it daily. 7am. Free. Reads in 5 minutes.
Join 3,470 builders reading daily.