Awesome GitHub RepositoriesDatabase Access Layers

Payload is a headless content management system and application framework that uses a code-first approach to define data schemas and administrative interfaces. By utilizing a centralized, type-safe configuration object, it automatically generates database schemas, API endpoints, and a fully customizable admin panel. The system is built on a database-agnostic architecture, allowing it to interface with various storage engines while providing a unified, type-safe API for server-side operations, REST, and GraphQL. What distinguishes Payload is its deep extensibility and developer-centric design.

GORM is a developer-focused object-relational mapping library for Go that provides a comprehensive data persistence framework. It serves as a database access layer, allowing developers to map application structures to database tables and perform CRUD operations using a fluent, type-safe query builder instead of writing raw SQL. The library distinguishes itself through its association-aware persistence, which automatically tracks and synchronizes complex entity relationships during database operations. It utilizes a driver-agnostic interface to maintain consistent behavior across various stora

Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.

Sequelize is an object-relational mapping library that provides a unified interface for managing relational data through code. By implementing the Active Record pattern, it maps database tables to application objects, allowing developers to perform standard create, read, update, and delete operations using high-level method calls. The library abstracts complex database interactions by translating these calls into optimized, engine-specific SQL statements, ensuring consistent behavior across different database systems. The project distinguishes itself through a comprehensive suite of tools for

Litemall is an open-source e-commerce platform built on Java and Spring Boot that provides a complete retail environment. It includes both a customer-facing storefront and a centralized administrative dashboard, enabling businesses to manage product catalogs, order lifecycles, and member accounts from a single system. The platform distinguishes itself through deep integration with the WeChat ecosystem, offering a mobile-optimized storefront and social authentication for streamlined user access. It utilizes a modular architecture that combines automated database access layers with custom SQL m

This project is a Spring Boot reference implementation and learning resource designed to demonstrate the core features and architectural patterns of the Spring framework. It serves as a Java enterprise application template and boilerplate for building RESTful APIs, providing a structured codebase for practicing application development. The repository provides practical examples of microservices architecture orchestration, including the use of service discovery and inter-service communication to coordinate distributed services. It also implements reference patterns for RESTful API design with

Entity Framework Core is an object-relational mapper that enables developers to interact with database systems using strongly-typed code. It serves as a comprehensive data access framework, providing a unified interface for mapping application objects to relational and non-relational database schemas while managing the lifecycle of data operations through a central context. The project distinguishes itself through a provider-based architecture that decouples core data access logic from specific database engines, allowing for consistent interaction across diverse storage systems. It features a

Blitz 是一个用于 Next.js 的全栈开发框架扩展，以及一个用于引导项目结构和编排本地开发服务器的命令行界面。它将前端和后端逻辑集成到一个工作流中，以促进完整 Web 应用程序的创建。 该框架采用零 API 后端集成和直接数据库访问层，允许前端组件连接到无服务器函数和数据库，而无需手动定义 API。它具有一个模式驱动的类型生成器，通过分析后端数据库模式自动创建 TypeScript 定义，以同步客户端和服务器之间的数据模型。 该项目提供用于快速应用程序原型设计和 TypeScript 全栈工作流的工具。其能力涵盖多进程服务器编排和生成结构化项目模板，以集成前端和后端开发模式。

Oatpp is a high-performance C++ web framework and API development kit used for building REST APIs and web services. It functions as an asynchronous HTTP server that utilizes coroutines to handle thousands of simultaneous connections without blocking threads. The toolkit includes a native C++ object-relational mapping layer for executing SQL queries and transforming database results into data objects. It also provides a WebSocket communication library for establishing full-duplex channels to support real-time data streaming and live media. The framework covers a broad range of capabilities, i

PostgREST 是一个自动将 PostgreSQL 数据库模式转换为生产就绪 RESTful API 的工具。它作为一个数据库访问层和查询引擎，将 HTTP 请求直接映射到 SQL 查询，提供了一个低代码接口，用于执行创建、读取、更新和删除操作，而无需手动编写样板代码。 该项目通过使用模式驱动的 API 生成和基于元数据的发现，将数据库表公开为可导航资源，从而脱颖而出。它通过执行自定义和模板化 SQL、用于注入业务逻辑的基于插件的中间件系统，以及在运行时加载外部共享库的能力，扩展了标准的 CRUD 功能。 该系统涵盖了广泛的功能，包括具有表连接、聚合和全文搜索的复杂数据查询。它实现了一个全面的安全框架，具有基于令牌的身份验证、细粒度的表级权限和 CORS 管理。其他操作功能包括本地结果缓存、服务器健康监控以及对分布式 SQL 和 Amazon Redshift 的连接支持。 安装支持多种环境，包括作为独立二进制文件或通过 Docker Compose 和 Heroku 自动化模板。

Gorp is a lightweight object-relational mapper for Go that binds structs to relational database tables. It functions as a relational data mapper and SQL dialect abstraction layer, automating the translation between application data and relational rows. The project provides a translation layer that generates vendor-specific SQL for PostgreSQL, MySQL, SQLite, Oracle, and SQL Server. It distinguishes itself by implementing optimistic locking via version columns to prevent concurrent update conflicts and providing a database schema generator to create tables and indexes from object definitions.

Jailer is a suite of specialized tools for AI-assisted SQL management, referential integrity preservation, and relational data browsing. It provides a system for generating referentially intact database subsets, allowing users to extract consistent slices of relational data while preserving foreign key constraints and dependencies. The project features an AI-driven SQL assistant that uses natural language to generate, optimize, and refactor queries based on database schemas. It also includes a data migration tool that analyzes SQL patterns to reverse engineer models and map associations betwe