dpapathanasiou/simple-graph
Simple Graph
Simple Graph is a lightweight graph database engine that utilizes SQLite to persist nodes and edges. It functions as a relational graph engine by mapping graph structures into standard database tables, allowing for the storage of both structured data and flexible, schema-less information through JSON document embedding.
The system provides a utility for performing complex graph traversals and path discovery by leveraging recursive common table expressions. This approach enables the exploration of deep connections and sequences of connected nodes within the stored data network.
The project supports standard data management operations, including the creation, updating, and deletion of graph records. All interactions are handled through prepared statement execution to ensure consistent and secure data manipulation within the underlying relational storage.
Features
- SQLite-Backed - Functions as a lightweight graph data store that uses SQLite to persist nodes and edges.
- Graph-Relational Management - Manages connected data structures by mapping graph nodes and relationships into relational tables.
- Recursive Relationship Querying - Retrieves paths and connected objects within the data network using recursive queries.
- Recursive CTE Queries - Implements recursive common table expressions to traverse complex relationship paths within the database.
- Embedded Storage Engines - Utilizes a serverless transactional database engine for persistent and ACID-compliant storage.
- Recursive SQL Path Traversals - Executes recursive traversals to retrieve sequences of connected nodes and paths.
- Data Querying - Retrieves nodes and edges based on specific attributes or traversal paths.
- SQLite Databases - Builds lightweight applications leveraging relational databases for interconnected information structures.
- Record Creations and Updates - Performs create, read, update, and delete operations on graph records using prepared statements.
- Graph Data Modifiers - Provides operations for creating, updating, and deleting nodes and edges within the graph.
- Relational Property Graph Stores - Persists graph structures using JSON objects for nodes and edges within relational tables.
- Graph-Relational Databases - Maps graph nodes and edges into structured relational tables for persistent storage.
- Prepared Statements - Uses pre-compiled SQL templates to ensure secure and efficient data manipulation.
- Embedded Document Columns - Stores node and edge attributes as serialized JSON objects within relational database columns.
