Announcing the release of Apache AGE 0.3.0

From: Apache AGE via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: Announcing the release of Apache AGE 0.3.0
Date: 2021-02-08 15:19:13
Message-ID: 161279755381.664.7288176540593417111@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

## Apache AGE Team has released version 0.3.0 of Apache AGE.
Apache AGE is a PostgreSQL extension that provides graph database functionality. AGE is an acronym for A Graph Extension, and is inspired by Bitnine's fork of PostgreSQL 10, AgensGraph, which is a multi-model database. The goal of the project is to create single storage that can handle both relational and graph model data so that users can use standard ANSI SQL along with openCypher, the Graph query language.

### Added the following openCypher functions:
- Trigonometric: e, sqrt, exp, log, log10, degrees, radians, pi, sin, cos, tan, asin, acos, atan, & atan2.
- String: replace, split, left, right, substring, rTrim, lTrim, trim, toUpper, toLower, reverse, & toString.
- Numeric: rand, abs, ceil, floor, round, & sign.
### Added user defined functions of the form:
- schema.function
- Currently working on aggregate function support.
- Added the following openCypher aggregate functions:
- min, max, stDev, stDevP, percentileCont, percentileDisc & count.
- avg & sum are added but may need to be reworked.
### Added Exists clause:
- exists(property)
- exists(pattern)
- Property Constraints
- The MATCH clause supports using property constraints.
- Set Clause Added
- Support for updating a single property value
- Multiple SET clauses can be used in a single query
- Supported to work with MATCH, CREATE, and REMOVE clauses
- Remove Clause Added
- Support for removing a single property values
- Multiple REMOVE clauses can be used in a single query
- Supported to work with MATCH, CREATE, and SET clauses
- Define Extension’s Behaviour when dropped
- Added a process to occur when the extension is dropped in Postgres.

Please see the [repository](https://github.com/apache/incubator-age/releases/tag/v0.3.0.rc0-incubating) for details:
https://github.com/apache/incubator-age/releases/tag/v0.3.0.rc0-incubating

Please feel free to use and send us any inquiry/idea about our project to: [Eya](eya(dot)abdisho(at)bitnine(dot)net) (eya(dot)abdisho(at)bitnine(dot)net) (Apache AGE's active Committer)

[Github Issues](https://github.com/apache/incubator-age/issues) : https://github.com/apache/incubator-age/issues

Browse pgsql-announce by date

  From Date Subject
Next Message PWN via PostgreSQL Announce 2021-02-10 14:54:10 PostgreSQL Weekly News - February 7, 2021
Previous Message Postgres Professional via PostgreSQL Announce 2021-02-06 06:04:57 pg_probackup 2.4.9 has been released