Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6rxP-006gnW-5b for pgsql-announce@arkaria.postgresql.org; Mon, 21 Apr 2025 14:17:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u6rxN-005u5t-5a for pgsql-announce@arkaria.postgresql.org; Mon, 21 Apr 2025 14:17:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6rxL-005u5G-Tb for pgsql-announce@lists.postgresql.org; Mon, 21 Apr 2025 14:17:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u6rxK-001BxO-0h for pgsql-announce@lists.postgresql.org; Mon, 21 Apr 2025 14:17:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=PAZwzJDnr2wdpkhuhGEhKlay1GSnO43Z4GwFrsz0SZE=; b=so6E+Kvhyasjh6cai65EqEfW5E uE7LnbZ6RnUz7vSeCRcsVDYsqAAMqhZ8aCmV88C6HiT0VzoQ6OwuK4O6vXADz0Nv4QVQeqOQAB8rG t3RL0WJsOdIGudvB+aOefu81d1fB9xqI41+AsmXzydlK8AEyWgMOnoVSYuV56U44uwQjXZI4cQcax mjKg2FgDzTc9fmGGV7YWewnBJG14lMhZsGC1/tocxPKn5QnZNGbMZhRfZN8AlXcWIsADjOVLLw//u PD7rE+ywKJ7I3cyg0TCPc10vVwFHPdFPLbHprd10xfig66bQLzwjH93ei1pedb586JCXQIAkPc7aj 3fkFsXxg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6rxH-003PMA-Pq for pgsql-announce@lists.postgresql.org; Mon, 21 Apr 2025 14:17:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u6rxG-008V1K-L5 for pgsql-announce@lists.postgresql.org; Mon, 21 Apr 2025 14:17:03 +0000 Content-Type: multipart/mixed; boundary="===============2417820974241548523==" MIME-Version: 1.0 Subject: Announcing the release of AgensGraph v2.15.0 To: PostgreSQL Announce From: "SKAI Worldwide (formerly Bitnine) via PostgreSQL Announce" Reply-To: marketing@skaiworldwide.com Date: Mon, 21 Apr 2025 14:16:41 +0000 Message-ID: <174524500154.673.9929826974446972978@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: eb90cdd1bd06f5b64265dcb5a4dd1e370c32663cebdedd999e59fb9c939d6954 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2417820974241548523== Content-Type: multipart/alternative; boundary="===============7229952675302920027==" MIME-Version: 1.0 --===============7229952675302920027== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable The AgensGraph Development Team is pleased to announce the release of Agens= Graph v2.15.0 AgensGraph is a new generation multi-model graph database for the modern co= mplex data environment. AgensGraph is a multi-model database, which support= s the relational and graph data model at the same time that enables develop= ers to integrate the legacy relational data model and the flexible graph da= ta model in one database. AgensGraph supports ANSI-SQL and openCypher (). 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, f= ully-featured and ready for enterprise use. AgensGraph is optimized for han= dling complex connected graph data and provides plenty of powerful database= features essential to the enterprise database environment including ACID t= ransactions, multi-version concurrency control, stored procedure, triggers,= constraints, sophisticated monitoring and a flexible data model (JSON). Mo= reover, 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](https://github.com/skaiwo= rldwide-oss/agensgraph/releases/tag/v2.15.0)**.=20 ## 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 se= curity patches. - **Support for SQL/JSON Path Language improvements**: Enhanced SQL/JSON pa= th language support, offering more powerful and flexible JSON data manipula= tion. - **Row and Column Filtering for Logical Replication**: Enhanced logical re= plication capabilities now allow for filtering specific rows and columns, p= roviding more granular control over replicated data. - **MERGE and CONCURRENT operations for COPY command**: The COPY command no= w supports MERGE and CONCURRENT operations, improving data loading performa= nce and flexibility. ###Enhancements: - **CREATE TABLE AS with Cypher Query**: AgensGraph now supports creating t= ables directly from Cypher query results, enabling seamless data integratio= n between relational and graph data. - **graph_exists() Function**: Introduced the graph_exists() function to ch= eck 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 flexibil= ity. - **MERGE Label Creation**: MERGE now correctly creates labels automaticall= y when nodes or edges are created, simplifying graph manipulation. - **Version String Reflection**: The version() string now accurately reflec= ts AgensGraph, providing clear identification of the database system. - **CTEs with Cypher**: AgensGraph now supports Common Table Expressions (C= TEs) with Cypher queries, enabling complex and modular graph queries. - **Tab Completion for Graph Queries in PSQL**: Enhanced PSQL with tab comp= letion 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 re= turn 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 "unrecogni= zed 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 whe= n using the --with-llvm configure option. # # The new version is immediately available for **[download](https://bitnine.n= et/download-graphdatabase/)**. --===============7229952675302920027== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Announcing the release of AgensGraph v2.15.0
 

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 mul= ti-model database, which supports the relational and graph data model at th= e same time that enables developers to integrate the legacy relational data= model and the flexible graph data model in one database. AgensGraph suppor= ts ANSI-SQL and openCypher (http://www.opencypher.org).= SQL queries and Cypher queries can be integrated into a single query in Ag= ensGraph.

AgensGraph is based on the powerful Postgre= SQL RDBMS, and is very robust, fully-featured and ready for enterprise use.= AgensGraph is optimized for handling complex connected graph data and prov= ides plenty of powerful database features essential to the enterprise datab= ase environment including ACID transactions, multi-version concurrency cont= rol, stored procedure, triggers, constraints, sophisticated monitoring and = a flexible data model (JSON). Moreover, AgensGraph leverages the rich eco-s= ystems of PostgreSQL and can be extended with many outstanding external mod= ules, like PostGIS, pgvector and AI extensions.

For more details please see the release notes.

Major Improvements in AgensGrap= h v2.15.0

Upstream Changes:

  • Upstrea= m Merge: AgensGraph is now compatible with PostgreSQL 15 up to the= 15.12 release, incorporating the latest PostgreSQL improvements and securi= ty patches.
  • Support= for SQL/JSON Path Language improvements: Enhanced SQL/JSON path l= anguage support, offering more powerful and flexible JSON data manipulation= .
  • Row and= Column Filtering for Logical Replication: Enhanced logical replic= ation capabilities now allow for filtering specific rows and columns, provi= ding more granular control over replicated data.
  • MERGE a= nd CONCURRENT operations for COPY command: The COPY command now su= pports MERGE and CONCURRENT operations, improving data loading performance = and flexibility.

Enhancements:

  • CREATE = TABLE AS with Cypher Query: AgensGraph now supports creating table= s directly from Cypher query results, enabling seamless data integration be= tween relational and graph data.
  • graph_e= xists() Function: Introduced the graph_exists() function to check = the existence of a graph within the database.
  • Variabl= e Reuse Across Clauses: Fixed an issue that prevented variable reu= se across different clauses in Cypher queries, enhancing query flexibility.=
  • MERGE L= abel Creation: MERGE now correctly creates labels automatically wh= en nodes or edges are created, simplifying graph manipulation.
  • Version= String Reflection: The version() string now accurately reflects A= gensGraph, providing clear identification of the database system.
  • CTEs wi= th Cypher: AgensGraph now supports Common Table Expressions (CTEs)= with Cypher queries, enabling complex and modular graph queries.
  • Tab Com= pletion for Graph Queries in PSQL: Enhanced PSQL with tab completi= on for graph-related keywords and functions, improving user experience and = productivity.
  • start_i= d and end_id for Edge Nodes: Adds start_id and end_id columns to e= dge nodes, providing explicit information about the connected nodes.

Bug Fixes:

  • NULL fo= r Non-Existent Labels in MATCH: MATCH queries now correctly return= NULL for non-existent labels, ensuring predictable query results.
  • Undersc= ore Variable Name Conflict: Resolved a conflict that occurred when= using _ as a variable name in Cypher queries.
  • Unrecog= nized Node Type: 121: Fixed an issue that caused an "unrecognized = node type: 121" error during certain graph operations.
  • Incorre= ct Aggregate Function Results: Corrected an issue that led to inco= rrect results from aggregate functions within Cypher queries.
  • Build I= ssues with --with-llvm: Addressed build issues encountered when us= ing the --with-llvm configure option.

The new version is immediately available fo= r download.
This email was sent to you from SKAI Worldwide (formerly Bitnine). It was d= elivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to SKAI Worldwide (formerly Bitnine).

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============7229952675302920027==-- --===============2417820974241548523==--