apache/age

Features

• Graph Database Queries - Executes openCypher graph traversal queries for pattern matching and path analysis.
• Cypher Engines - Ships a Cypher query engine that runs openCypher graph traversal queries directly within PostgreSQL.
• Graph Pattern Matching - Provides graph pattern matching via the MATCH clause for traversing nodes and relationships.
• Cypher Query Translation - Translates openCypher graph queries into relational algebra and SQL expressions for native execution.
• Graph-Relational Table Joins - Joins graph query results with relational tables using standard SQL JOIN clauses for cross-domain analysis.
• Bulk Data Importers - Loads vertices and edges from CSV files into graph storage transactionally.
• Transactional CSV Loaders - Provides a dedicated transactional CSV import pipeline for loading graph vertices and edges.
• Graph Deletions - Removes a graph and optionally cascades to delete all associated labels and data.
• Relational Graph Modifiers - Provides CREATE, SET, DELETE, and MERGE operations for graph elements within PostgreSQL.
• Relational Property Graph Stores - Persists labeled, directed property graphs using relational tables indexed by graph element identifiers.
• Graph Element Existence Checks - Provides property existence checks on nodes and relationships, a fundamental graph querying capability.
• Graph Element Retrieval - Outputs all vertices, edges, and paths found in a query using a wildcard symbol.
• Graph Namespaces - Stores each graph as a separate schema with internal tables, preventing cross-graph interference.
• Graph Node Deletions - Removes nodes, relationships, or paths from a graph database using the DELETE clause.
• Node Retrieval - Returns full node objects with labels and properties from matched graph patterns.
• Graph Querying - Runs openCypher queries against named graphs within PostgreSQL and returns results as records.
• SQL-Context Graph Query Executions - Runs openCypher graph queries as part of larger SQL statements for combined relational-graph operations.
• SQL-Embedded Graph Queries - Embeds openCypher graph queries inside SQL statements including CTEs, joins, and subqueries.
• SQL-Integrated - Combines graph queries and standard SQL in a single statement for cross-domain joins and subqueries.
• Graph-Relational Databases - Adds graph database capabilities to PostgreSQL, enabling hybrid queries with both SQL and Cypher.
• Hybrid Relational-Graph Queries - Enables hybrid queries that join graph traversal results with relational tables in a single SQL statement.
• Loadable Extension Engines - Ships as a loadable extension that hooks into PostgreSQL's query planner and executor for graph capabilities.
• Edge Retrieval - Returns full edge objects with labels and properties from matched graph patterns.
• Relational Graph Integration - Creates, updates, and deletes graph nodes and edges while joining results with relational tables.
• Hybrid Query Execution - Runs graph traversals and relational joins in a single query plan by embedding Cypher inside SQL.
• Relational-Graph Hybridization - Embeds Cypher graph queries inside SQL statements, including CTEs, joins, and subqueries, for combined analytics.
• Optional Property Access - Returns property values or null for missing properties, handling missing data gracefully.
• Property Extraction - Extracts specific property values from graph elements using dot notation in queries.
• Property Retrieval Operations - Returns all properties of a vertex or edge as a map for inspection in query results.
• PostgreSQL Extensions - Adds openCypher graph capabilities to PostgreSQL as a loadable extension.
• Graph Extensions - Ships as a loadable PostgreSQL extension that manages graph structures alongside relational tables.
• Path Pattern Existence Checks - Provides pattern-based path existence checks, a fundamental graph querying capability.
• Graph Element Accessors - Provides functions to retrieve the start or end node of any edge in a graph query.
• Recursive SQL Path Traversals - Implements variable-length path traversal using recursive SQL constructs for graph patterns.
• Graph Edge Creations - Creates a directed relationship between two existing vertices, optionally with properties, using the openCypher CREATE clause.
• Graph Vertex Creations - Creates one or more vertices in a graph, optionally with labels and properties, using the openCypher CREATE clause.
• Query Result Expressions - Outputs any valid expression including literals, predicates, properties, and function calls in results.
• Regex Pattern Matching - Matches strings against POSIX regular expression patterns with case-sensitive comparison.
• Aggregate Result Sorting - Supports ordering query results by aggregate function values, a standard analytical capability.
• Entity-Based Grouping Keys - Allows grouping query results by vertex or edge entities, a key feature for graph analytics.
• Graph Subquery Filters - Uses Cypher queries as scalar, IN, or EXISTS subqueries in SQL WHERE clauses for graph-based filtering.
• CSV Bulk Importers - Loads graph data from external file formats into the graph database for querying and analysis.
• Detached Node Deletions - Removes a vertex and all its incident edges in one operation using the DETACH DELETE option.
• Path Constructors - Creates a connected sequence of vertices and edges in a single query and assigns the whole pattern to a path variable.
• Multi-Graph Querying - References several named graphs within a single SQL statement and joins their results.
• Ambiguous Grouping Key Resolution - Enforces explicit grouping key resolution in Cypher queries, a standard analytical requirement.
• Grouping Key Suppression - Enables suppressing grouping keys from query output, a standard Cypher aggregation technique.
• Distinct Value Counters in Aggregation - Supports counting distinct values in Cypher aggregation queries, a core analytical capability.
• Graph Query Function Definitions - Extends graph queries with user-defined functions written in PL/pgSQL for custom logic.
• Graph Query Function Registrations - Registers user-defined PL/pgSQL functions as custom Cypher query functions for extensibility.
• Value Comparators - Provides cross-type value comparison with defined ordering rules within Cypher queries.
• Graph Query Parameterizations - Passes parameter maps to Cypher queries for prepared statement reuse and injection prevention.
• Edge-Only Deletions - Removes specific edges from the graph while leaving the connected vertices intact.
• Equality Versus Equivalence Distinctions - Distinguishes between strict equality and equivalence semantics in Cypher queries, a key language feature.
• Multi-Operator String Matching - Matches strings using prefix, suffix, inclusion, or regex operators with defined precedence.
• Prefix Matching - Checks whether a string starts with a given substring using case-sensitive comparison.
• Suffix Matching - Checks whether a string ends with a given substring using case-sensitive comparison.
• Substring Verifications - Checks whether a string contains a given substring using case-sensitive comparison.
• Extensions and Plugins - Adds graph database support and Cypher query capabilities.

Star history