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 هو امتداد إطار عمل تطوير fullstack لـ Next.js وواجهة سطر أوامر تستخدم لتمهيد هياكل المشاريع وتنسيق خوادم التطوير المحلية. يدمج منطق الواجهة الأمامية والخلفية في سير عمل واحد لتسهيل إنشاء تطبيقات الويب الكاملة. يستخدم إطار العمل تكامل backend بدون API وطبقة وصول مباشر لقاعدة البيانات، مما يسمح لمكونات الواجهة الأمامية بالاتصال بوظائف serverless وقواعد البيانات دون تعريفات API يدوية. يتميز بمولد نوع قائم على المخطط يقوم تلقائياً بإنشاء تعريفات TypeScript من خلال تحليل مخططات قاعدة بيانات الـ backend لمزامنة نماذج البيانات بين العميل والخادم. يوفر المشروع أدوات للنماذج الأولية السريعة للتطبيقات وسير عمل TypeScript fullstack. تغطي قدراته أوركسترا الخادم متعدد العمليات وتوليد قوالب المشاريع المهيكلة لدمج أنماط تطوير الواجهة الأمامية والخلفية.

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 إلى API RESTful جاهز للإنتاج. تعمل كطبقة وصول لقاعدة البيانات ومحرك استعلام يقوم بتعيين طلبات HTTP مباشرة إلى استعلامات SQL، مما يوفر واجهة منخفضة الكود لتنفيذ عمليات الإنشاء والقراءة والتحديث والحذف دون الحاجة إلى كود أساسي يدوي. يتميز المشروع باستخدام توليد API القائم على المخطط والاكتشاف القائم على البيانات الوصفية لكشف جداول قاعدة البيانات كموارد قابلة للتنقل. يوسع قدرات CRUD القياسية من خلال تنفيذ SQL مخصص وقائم على القوالب، ونظام برمجيات وسيطة قائم على المكونات الإضافية لحقن منطق الأعمال، والقدرة على تحميل مكتبات مشتركة خارجية في وقت التشغيل. يغطي النظام مجموعة واسعة من القدرات بما في ذلك استعلام البيانات المعقد مع انضمامات الجداول، والتجميعات، والبحث بالنص الكامل. ينفذ إطار عمل أمني شاملاً يتميز بالمصادقة القائمة على الرموز، وأذونات دقيقة على مستوى الجدول، وإدارة 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