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 este o extensie de framework de dezvoltare fullstack pentru Next.js și o interfață de linie de comandă utilizată pentru a bootstrap-a structuri de proiect și a orchestra servere de dezvoltare locale. Acesta integrează logica frontend și backend într-un singur flux de lucru pentru a facilita crearea de aplicații web complete. Framework-ul folosește o integrare backend zero-API și un strat de acces direct la baza de date, permițând componentelor frontend să se conecteze la funcții serverless și baze de date fără definiții API manuale. Dispune de un generator de tipuri bazat pe schemă care creează automat definiții TypeScript prin analizarea schemelor bazelor de date backend pentru a sincroniza modelele de date între client și server. Proiectul oferă instrumente pentru prototiparea rapidă a aplicațiilor și un flux de lucru fullstack TypeScript. Capabilitățile sale acoperă orchestrarea serverelor multi-proces și generarea de template-uri de proiect structurate pentru a integra tipare de dezvoltare frontend și backend.

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 este un instrument care transformă automat o schemă de bază de date PostgreSQL într-un API RESTful gata de producție. Servește drept strat de acces la baza de date și motor de interogare care mapează cererile HTTP direct în interogări SQL, oferind o interfață low-code pentru executarea operațiunilor de creare, citire, actualizare și ștergere (CRUD) fără a necesita cod boilerplate manual. Proiectul se distinge prin utilizarea generării de API bazată pe schemă și descoperirea bazată pe metadate pentru a expune tabelele bazei de date ca resurse navigabile. Extinde capabilitățile CRUD standard prin executarea de SQL personalizat și șablonat, un sistem de middleware bazat pe plugin-uri pentru injectarea logicii de business și capacitatea de a încărca biblioteci partajate externe la runtime. Sistemul acoperă o gamă largă de capabilități, inclusiv interogarea complexă a datelor cu join-uri de tabele, agregări și căutare full-text. Implementează un framework de securitate cuprinzător care include autentificare bazată pe token, permisiuni granulare la nivel de tabel și gestionarea CORS. Caracteristicile operaționale suplimentare includ caching-ul local al rezultatelor, monitorizarea stării de sănătate a serverului și conectivitate pentru SQL distribuit și Amazon Redshift. Instalarea este suportată în mai multe medii, inclusiv ca binar independent sau prin șabloane de automatizare Docker Compose și 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