Awesome GitHub RepositoriesEager Loading

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

Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It uses the data mapper and identity map patterns to decouple the in-memory object model from the database schema, allowing developers to manage data persistence without writing manual SQL. The project features a dedicated object-oriented query language and programmatic builder for retrieving data based on entities rather than tables. It implements a unit-of-work system to track object changes during a request and synchronize them via atomic transactions. The capability surface inc

Objection.js is an object-relational mapper for Node.js that maps SQL database tables to classes and rows to model instances. It functions as a high-level abstraction layer built on top of the Knex.js query builder to provide structured model definitions and relational data mapping. The project distinguishes itself through its ability to manage complex object graphs, allowing for the persistence and eager-loading of deeply nested related data in single operations. It incorporates a data integrity layer that uses JSON schema validation to verify model instances before they are persisted to the

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

Bookshelf is a JavaScript ORM for Node.js that provides a structured way to define and interact with database models. It centers on a model-driven approach where developers register models, define their relations, and manage data persistence through a consistent interface. The library distinguishes itself through its comprehensive handling of model relationships and data transformations. It supports defining one-to-one, one-to-many, many-to-many, and polymorphic associations, with the ability to eager load related models in a single query to avoid performance pitfalls. Bookshelf also automate

Sequel is a relational database toolkit for Ruby that provides object-relational mapping, a fluent SQL query builder, and schema migration capabilities. It maps database tables to Ruby classes with support for associations, validations, lifecycle hooks, and eager loading, offering a comprehensive ORM layer for building data-centric applications. Sequel distinguishes itself through a plugin-based extension architecture that allows composable customization of models, databases, and datasets without relying on deep inheritance hierarchies. It includes a thread-safe connection pool with support f

This project is an Eloquent query builder wrapper and REST API query parser for Laravel applications. It translates HTTP request parameters into database queries to provide dynamic filtering, sorting, and relationship loading for API endpoints. The system decouples the external API interface from the storage layer through alias-based schema abstraction, allowing public field names to map to private database columns. It supports the dynamic inclusion of nested relationships and aggregate counts, as well as the execution of custom programmatic logic for filters and sorting via invokable classes

FreeSql هو أداة تعيين كائنات-علاقات (ORM) في .NET وطبقة وصول للبيانات تترجم الكود الموجه للكائنات إلى SQL لمزودي قواعد بيانات علائقية متعددين. يعمل كمنشئ استعلام SQL بأسلوب fluent ومزامن لمخطط قاعدة البيانات، مما يسمح للمطورين بمواءمة هياكل جداول وفهارس قاعدة البيانات مع تعريفات فئات الكيانات. تم تحسين إطار العمل خصيصاً لـ .NET Native AOT لضمان تقليل بصمات الذاكرة وأوقات بدء تشغيل أسرع. يتضمن مديراً لحركة مرور قاعدة البيانات لتوزيع الحمل من خلال تقسيم القراءة والكتابة، وتقسيم الجداول الديناميكي (sharding)، وعزل البيانات القائم على المستأجر. تشمل الإمكانيات الواسعة استيعاب البيانات عالي الأداء باستخدام آليات النسخ المجمع الخاصة بالمزود، والاستعلام المتقدم مع دوال النافذة و CTEs المتكررة، والمراقبة القائمة على AOP لتدقيق تغييرات البيانات. يوفر النظام أيضاً أدوات إدارة المخطط للترحيلات المؤتمتة وأدوات التطوير لتوليد فئات الكيانات من بيانات تعريف قاعدة البيانات.