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 के लिए एक फुलस्टैक डेवलपमेंट फ्रेमवर्क एक्सटेंशन है और प्रोजेक्ट संरचनाओं को बूटस्ट्रैप करने और स्थानीय विकास सर्वर को ऑर्केस्ट्रेट करने के लिए उपयोग किया जाने वाला एक कमांड लाइन इंटरफ़ेस है। यह पूर्ण वेब अनुप्रयोगों के निर्माण की सुविधा के लिए फ्रंटएंड और बैकएंड लॉजिक को एक ही वर्कफ़्लो में एकीकृत करता है। फ्रेमवर्क एक ज़ीरो-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 is a tool that automatically transforms a PostgreSQL database schema into a production-ready RESTful API. It serves as a database access layer and query engine that maps HTTP requests directly to SQL queries, providing a low-code interface for executing create, read, update, and delete operations without requiring manual boilerplate code. The project distinguishes itself by using schema-driven API generation and metadata-based discovery to expose database tables as navigable resources. It extends standard CRUD capabilities through the execution of custom and templated SQL, a plugin-

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