Awesome GitHub RepositoriesObject Relational Mappings

json-server is a development toolset used to simulate a full REST API from a JSON file. It functions as a customizable mock API server that allows for the simulation of CRUD operations and resource relationships without the need to write backend code. The project enables rapid prototyping by generating a fake backend that persists data changes back to a local JSON file. It distinguishes itself by providing a static asset file server to deliver local documents, images, and stylesheets alongside the mock API endpoints. The server includes capabilities for data querying, such as parameter-based

Vapor is a comprehensive server-side web framework designed for building scalable, high-performance applications and APIs in Swift. It provides a non-blocking, event-loop-based runtime that manages concurrent task processing, background job queues, and asynchronous request handling. The framework is built around a dependency injection container that manages the lifecycle and resolution of services, configurations, and database connections throughout the request pipeline. The framework distinguishes itself through a protocol-oriented design that emphasizes type safety across all layers of the

This project provides a structured dataset of the administrative divisions of China, covering five levels from provinces down to villages. It delivers this geographical information in a standardized JSON format designed for data exchange and integration. The dataset is organized as a hierarchical source specifically for building cascading address selectors and region pickers. It uses linked data to enable sequential filtering from higher-level provinces down to village-level boundaries. The project covers geographic data management and regional data normalization. It provides the necessary m

Wagtail is an open-source content management system built on the Django web framework. It provides a structured, tree-based approach to content modeling, allowing developers to define custom page types and reusable content components that are managed through a highly customizable administrative interface. The platform distinguishes itself through its flexible, block-based content composition system, which enables editors to assemble complex page layouts dynamically. It also offers robust support for multi-site and multi-lingual environments, allowing organizations to manage distinct websites

SQLModel is a type-safe object-relational mapping library for Python that integrates database schema definitions with data validation logic. By combining these two roles into a single class, it allows developers to manage relational data structures and enforce data integrity for web APIs simultaneously. The framework is built to support asynchronous database operations, enabling high-performance applications to execute queries and transactions without blocking the main execution thread. The library distinguishes itself by leveraging Python type hints to provide IDE autocompletion and compile-

Sourcetrail is an interactive source code explorer and visualizer designed for indexing and navigating relationships between symbols and structures across large, multi-language codebases. It functions as a static analysis indexer and code dependency visualizer that maps calls and dependencies between source files to help reveal project architecture. The tool enables multi-language project analysis by using a language-agnostic indexing system to track symbols across different programming languages within a single interface. It allows for the discovery of software architecture and the explorati

Snipe-IT is an IT asset management system and inventory manager designed to track hardware, equipment, and software licenses. It provides a central platform for monitoring ownership, location, and status of assets across an organization. The system includes a dedicated manager for software licenses to track entitlements and expiration dates for legal compliance. It also functions as an inventory manager for consumable supplies, featuring stock level monitoring and automated alerts when supplies fall below defined thresholds. The platform exposes a REST API for reading and writing inventory d

Drogon is a high-performance, cross-platform C++ framework designed for building asynchronous web services and server-side applications. It functions as a multi-threaded, event-driven server engine that manages concurrent network traffic and WebSocket connections with minimal latency. By leveraging non-blocking input/output and native code compilation, the framework provides a foundation for scalable applications that operate efficiently across diverse hardware architectures. The framework distinguishes itself through its compile-time template rendering, which transforms dynamic HTML views in

This project is a comprehensive guide to architectural standards and coding patterns for developing maintainable applications within the Laravel framework. It focuses on clean code standards, applying the single responsibility and DRY principles to ensure codebase predictability and consistency. The guide emphasizes decoupling components by moving business logic into service layers and shifting input validation into dedicated request classes to keep controllers lean. It advocates for the use of a service container and dependency injection to reduce class coupling and improve testability. The

Peewee is a SQL object-relational mapper and query builder that provides an object-oriented interface for mapping application classes to relational database tables. It functions as a relational database toolkit for managing schemas, executing migrations, and handling complex table relationships. The project distinguishes itself by providing an asyncio database driver for non-blocking database operations, ensuring event loop responsiveness. It also supports semi-structured data storage, allowing the storage and querying of flexible JSON documents within traditional relational database systems.

Sea-ORM is an asynchronous SQL object-relational mapper and database toolkit for mapping relational tables to strongly typed objects. It provides a relational database mapper for performing CRUD operations across MySQL, PostgreSQL, and SQLite, and includes a programmatic dynamic query builder for constructing complex SQL statements. The project distinguishes itself by providing a GraphQL schema generator that transforms database entities into typed schemas with built-in pagination and filters. It also features a dedicated database migration tool for defining and applying versioned schema chan

CakePHP ist ein PHP-Webframework, das für die schnelle Entwicklung voll ausgestatteter Webanwendungen konzipiert ist. Es nutzt eine Model-View-Controller-Architektur, um Geschäftslogik, Datenmodelle und Benutzeroberflächen voneinander zu trennen. Das Framework enthält einen integrierten Object-Relational Mapper (ORM), der das Abrufen und Speichern relationaler Daten ermöglicht, ohne rohe SQL-Abfragen schreiben zu müssen. Es verfolgt einen „Convention-over-Configuration“-Ansatz, um Boilerplate-Code zu reduzieren, indem es standardisierte Namensschemata für Dateien und Datenbanktabellen voraussetzt. Das Projekt bietet Werkzeuge zur Implementierung von Webformularen mit integrierter Validierungs- und Verarbeitungslogik. Seine Architektur integriert einen Dependency-Injection-Container zur Verwaltung von Anwendungsdiensten sowie eine Middleware-basierte Request-Pipeline zur Verarbeitung eingehender HTTP-Anfragen.

hello-sql is a collection of educational resources and practical guides designed for mastering relational database design, SQL query writing, and schema mapping. It provides a set of lessons and exercises for practicing the creation and manipulation of data within relational databases. The project includes a database schema workbook for designing tables and mapping relationships, alongside a dedicated SQL query guide for writing selection, filtering, and aggregation statements. These resources are delivered through a relational database tutorial and a broader SQL learning resource. The mater

Crater is an open-source invoicing and expense tracking software designed for individuals and small businesses. It serves as a self-hosted billing platform that allows users to monitor the overall financial health of a business by recording professional services rendered and tracking outgoing costs. The system functions as a payment gateway integrator, connecting to third-party providers such as Stripe to process secure transactions for issued invoices. It provides specialized tools for freelance invoice management, including the generation of professional billing documents and cost estimates

This project is a MongoDB Eloquent ORM and NoSQL query builder for the Laravel framework. It provides an active record implementation that maps MongoDB collections and documents to programmable models for data manipulation. The system enables schemaless data management, allowing applications to handle dynamic data structures without the need for rigid database migrations or predefined tables. It integrates MongoDB into Laravel applications to store and retrieve flexible document data using standard PHP patterns. The library covers document store querying and Eloquent model mapping, utilizing

This project is a MongoDB database driver and object-relational mapper that brings MongoDB support to the Laravel Eloquent model and query builder. It provides a NoSQL model mapper that allows MongoDB collections to be mapped to object-oriented models using the Active Record pattern. The integration enables the use of a fluent query builder for constructing queries and aggregation pipelines without writing raw database syntax. It supports schema-less model integration, allowing applications to manage unstructured data while maintaining compatibility with standard object-oriented patterns. Th

sqlboiler is a database-first ORM generator for Go that analyzes an existing database schema to produce strongly typed structures and query helpers. It functions as a schema-driven code generator, transforming database tables and relationships into executable Go source code. The project distinguishes itself through a type-safe query builder that uses chainable modifiers to construct SQL statements, eliminating the need for raw string concatenation. It utilizes customizable text templates to generate source code, allowing for the aliasing of schema entities and the creation of custom templates

Larastan is a static analysis extension and type inference engine for PHP designed to detect bugs and type errors in Laravel applications. It extends PHPStan to resolve framework-specific patterns and magic methods, providing a rule-based scanning engine to audit code quality without executing the application. The tool specializes in Eloquent analysis, verifying that model properties, casts, and relationships align with database schemas and migrations. It tracks types across Eloquent collections, custom builders, and model factories to ensure type safety during database operations and iterati

Laravel Boilerplate is a pre-built admin panel and application scaffolding for Laravel that provides a complete backend foundation including user management, role-based permissions, and a CoreUI interface. It serves as a starting point for web application development by bundling essential administrative features into a single, ready-to-use package. The project distinguishes itself through a comprehensive identity management system that combines multi-language support across over 20 locales with two-factor authentication and user impersonation capabilities. Its role-based access control system

Waterline ist eine adapterbasierte Datenbankbibliothek und ein Object-Relational-Mapper für Node.js. Sie dient als Multi-Datenbank-Persistenzschicht, die Standard-Methodenaufrufe in spezifische Abfragen für SQL- und NoSQL-Datenbanken übersetzt. Die Bibliothek bietet eine einheitliche Schnittstelle zur Verwaltung von Daten über verschiedene Speicher hinweg, darunter MySQL, PostgreSQL, MongoDB und Microsoft SQL Server. Diese Architektur ermöglicht die Integration mehrerer Datenbank-Backends innerhalb einer einzigen Anwendung und erleichtert den Wechsel des Datenbankanbieters durch den Austausch von Adaptern, ohne die Geschäftslogik ändern zu müssen. Das Projekt deckt relationale und dokumentenbasierte Mappings ab und bietet eine konsistente Syntax zum Speichern und Abrufen von Daten. Es nutzt schema-gesteuertes Object-Mapping, um die Lücke zwischen Datenbanktabellen oder -sammlungen und JavaScript-Objekten zu schließen.