Awesome GitHub RepositoriesRecursive Graph Queries

This project is a human resources management system built using Spring Boot and Vue. It serves as a platform for managing employee records, professional titles, and organizational hierarchies. The system features a role-based access control framework that maps users to specific roles and resources to secure API endpoints and user interface elements. It includes a real-time communication hub utilizing WebSockets for internal corporate chat and system notifications, as well as a dedicated manager for defining and modifying nested organizational department structures. Additional capabilities co

Materialize is a streaming SQL database that continuously ingests live data from sources such as Kafka, Redpanda, PostgreSQL, and MySQL, and incrementally maintains materialized views. It provides a PostgreSQL-compatible query engine that accepts standard SQL over the PostgreSQL wire protocol, enabling any existing SQL client or BI tool to query real-time data. The system also includes a Model Context Protocol (MCP) server that exposes live materialized view data to AI agents, providing fresh context without polling. Materialize distinguishes itself through its ability to offer configurable c

Titan is a distributed graph database and computing engine designed for storing and querying massive datasets of interconnected nodes and edges across multi-machine clusters. It functions as a scalable graph storage layer and transactional store, providing a framework for executing large-scale graph processing jobs and deep traversals. The system is distinguished by its pluggable storage backend, which decouples the graph engine from the physical persistence layer. It utilizes vertex-cut data partitioning to balance processing loads and a set-cardinality property model that allows single prop

deployd 是一个实时 API 框架和 MongoDB 后端即服务 (BaaS)，允许创建在客户端和服务器之间同步数据和事件的网络化接口。它作为一个 JavaScript API 中间件，可以与 HTTP 服务器集成，以提供身份验证、请求拦截器和实时功能。 该项目具有一个自托管的 API 管理仪表板，用于通过 Web 界面配置资源设置、管理数据集合和监控服务器状态。它包括一个实时数据同步引擎，使用 Socket 将实时数据库更新推送到连接的客户端。 该系统涵盖了具有模式验证和递归查询的后端数据管理，以及跨无状态请求和持久连接跟踪会话的用户身份验证工作流。它还提供实时事件广播、通过模块扩展自定义 API 中间件以及管理访问控制的功能。 该项目包含一个用于引导新项目和运行开发服务器的 CLI。

H2 是一个用 Java 编写的 JDBC 兼容关系型数据库管理系统。它作为一个可嵌入的 SQL 数据库，可以直接在应用程序进程内运行以消除网络延迟，或者作为内存数据库用于高性能的易失性存储。它还包含一个基于 Web 的控制台，用于执行 SQL 命令和管理模式。 该系统的特点是其灵活的部署模式，包括用于远程 TCP/IP 访问的独立服务器模式，以及用于同时进行本地和远程连接的混合模式。它具有方言模拟层和兼容模式，允许其模仿其他数据库系统的行为和语法。 该引擎提供了一套广泛的功能，涵盖具有多版本并发控制（MVCC）的 ACID 事务、地理空间和 JSON 数据支持，以及高级分析窗口函数。它包括通过压缩备份、SQL 脚本恢复和堆外内存管理来处理大数据集的数据保护工具。 该数据库使用标准的 Java 数据库连接驱动程序和连接 URL 与应用程序集成。

FreeSql 是一个 .NET 对象关系映射器（ORM）和数据访问层，可将面向对象的代码转换为适用于多种关系型数据库提供程序的 SQL。它作为一个流畅的 SQL 查询构建器和数据库架构同步器，允许开发者将数据库表和索引结构与实体类定义保持一致。 该框架专门针对 .NET Native AOT 进行了优化，以确保更小的内存占用和更快的启动时间。它包含一个数据库流量管理器，通过读写分离、动态分表和基于租户的数据隔离来分配负载。 其广泛的功能包括使用特定于提供程序的批量复制机制实现高性能数据摄入，利用窗口函数和递归 CTE 进行高级查询，以及基于 AOP 的数据变更审计监控。该系统还提供用于自动迁移的架构管理工具，以及用于从数据库元数据生成实体类的开发实用程序。

TypeDB 是一款强类型图数据库和知识图谱管理系统。它作为多模型数据存储，将关系、文档和图结构统一到一个环境中，既充当 ACID 兼容数据库，又充当声明式查询引擎。 该系统通过使用 n 元超图建模和多态类型层级脱颖而出。它采用强类型模式来强制执行结构规则并验证数据完整性，允许在查询执行期间自动解析复杂关系的基于类型的多态推理和基于角色的接口多态性。 该平台涵盖了广泛的功能，包括通过制表（tabling）计算递归关系、快照隔离事务和声明式数据检索。它还通过基于共识的集群复制、基于角色的访问控制以及与 AI 代理的集成以进行结构化数据检索，支持高可用性。 管理通过命令行界面支持，系统提供用于可视化图模式和审计管理活动的工具。

Helix DB is a distributed graph database and knowledge graph platform that persists nodes and edges on object storage for durable and unlimited scaling. It operates as an ACID-compliant system, ensuring data consistency through serializable snapshot isolation during concurrent operations. The project distinguishes itself by combining a vector search engine and a property graph, utilizing hybrid vector and full-text search to locate entry points for graph traversals. It enables dynamic graph querying through a domain-specific language, allowing complex logic and recursive queries to be execute

Jet is a schema-driven code generation tool and type-safe SQL builder for Go. It introspects database schemas to automatically generate builders and data models, enabling compile-time type checking for table and column references to prevent runtime errors. The project distinguishes itself through a fluent interface that mirrors native SQL syntax, allowing for the orchestration of complex queries including common table expressions, recursive queries, and nested JSON structures. It further optimizes data retrieval by binding query outputs directly into generated Go structures or raw byte slices

linq2db is a type-safe object-relational mapper that translates LINQ expressions into optimized SQL queries for multiple database providers. It functions as a database mapper that links classes to tables and includes a SQL query builder and a command-line schema tool for generating data classes from existing databases. The project provides high-performance bulk data processing for inserting and loading large volumes of records via batch or binary copy methods. It also supports advanced SQL operations, including window functions, common table expressions for recursive hierarchical querying, an

Memary is a memory-augmented agent framework that stores and retrieves contextual information from a knowledge graph to personalize responses and maintain long-term memory across interactions. It automatically captures all agent interactions and stores them as structured memories without requiring explicit instrumentation, then injects top-ranked user entities and themes into the active context window to tailor agent responses dynamically. The framework distinguishes itself through a multi-retriever memory search that combines COLBERT reranking with recursive graph queries across databases, e

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 su