Announcing the release of AgensGraph v2.15.0

The AgensGraph Development Team is pleased to announce the release of AgensGraph v2.15.0

AgensGraph is a new generation multi-model graph database for the modern complex data environment. AgensGraph is a multi-model database, which supports the relational and graph data model at the same time that enables developers to integrate the legacy relational data model and the flexible graph data model in one database. AgensGraph supports ANSI-SQL and openCypher (http://www.opencypher.org). SQL queries and Cypher queries can be integrated into a single query in AgensGraph.

AgensGraph is based on the powerful PostgreSQL RDBMS, and is very robust, fully-featured and ready for enterprise use. AgensGraph is optimized for handling complex connected graph data and provides plenty of powerful database features essential to the enterprise database environment including ACID transactions, multi-version concurrency control, stored procedure, triggers, constraints, sophisticated monitoring and a flexible data model (JSON). Moreover, AgensGraph leverages the rich eco-systems of PostgreSQL and can be extended with many outstanding external modules, like PostGIS, pgvector and AI extensions.

For more details please see the release notes.

Major Improvements in AgensGraph v2.15.0

Upstream Changes:

• Upstream Merge: AgensGraph is now compatible with PostgreSQL 15 up to the 15.12 release, incorporating the latest PostgreSQL improvements and security patches.
• Support for SQL/JSON Path Language improvements: Enhanced SQL/JSON path language support, offering more powerful and flexible JSON data manipulation.
• Row and Column Filtering for Logical Replication: Enhanced logical replication capabilities now allow for filtering specific rows and columns, providing more granular control over replicated data.
• MERGE and CONCURRENT operations for COPY command: The COPY command now supports MERGE and CONCURRENT operations, improving data loading performance and flexibility.

Enhancements:

• CREATE TABLE AS with Cypher Query: AgensGraph now supports creating tables directly from Cypher query results, enabling seamless data integration between relational and graph data.
• graph_exists() Function: Introduced the graph_exists() function to check the existence of a graph within the database.
• Variable Reuse Across Clauses: Fixed an issue that prevented variable reuse across different clauses in Cypher queries, enhancing query flexibility.
• MERGE Label Creation: MERGE now correctly creates labels automatically when nodes or edges are created, simplifying graph manipulation.
• Version String Reflection: The version() string now accurately reflects AgensGraph, providing clear identification of the database system.
• CTEs with Cypher: AgensGraph now supports Common Table Expressions (CTEs) with Cypher queries, enabling complex and modular graph queries.
• Tab Completion for Graph Queries in PSQL: Enhanced PSQL with tab completion for graph-related keywords and functions, improving user experience and productivity.
• start_id and end_id for Edge Nodes: Adds start_id and end_id columns to edge nodes, providing explicit information about the connected nodes.

Bug Fixes:

• NULL for Non-Existent Labels in MATCH: MATCH queries now correctly return NULL for non-existent labels, ensuring predictable query results.
• Underscore Variable Name Conflict: Resolved a conflict that occurred when using _ as a variable name in Cypher queries.
• Unrecognized Node Type: 121: Fixed an issue that caused an "unrecognized node type: 121" error during certain graph operations.
• Incorrect Aggregate Function Results: Corrected an issue that led to incorrect results from aggregate functions within Cypher queries.
• Build Issues with --with-llvm: Addressed build issues encountered when using the --with-llvm configure option.

The new version is immediately available for download.