dpapathanasiou/simple-graph
Simple Graph
Simple Graph es un motor de base de datos de grafos ligero que utiliza SQLite para persistir nodos y aristas. Funciona como un motor de grafos relacional mapeando estructuras de grafos en tablas de base de datos estándar, permitiendo el almacenamiento tanto de datos estructurados como de información flexible sin esquema mediante el embebido de documentos JSON.
El sistema proporciona una utilidad para realizar recorridos de grafos complejos y descubrimiento de rutas aprovechando expresiones de tabla comunes recursivas. Este enfoque permite la exploración de conexiones profundas y secuencias de nodos conectados dentro de la red de datos almacenada.
El proyecto admite operaciones estándar de gestión de datos, incluyendo la creación, actualización y eliminación de registros de grafos. Todas las interacciones se manejan mediante la ejecución de sentencias preparadas para asegurar una manipulación de datos consistente y segura dentro del almacenamiento relacional subyacente.
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.
