Awesome GitHub RepositoriesDatabase ORMs

Django is a full-stack web framework designed for rapid backend development. It provides an integrated environment for building data-driven applications by combining an object-relational mapping layer for database management with a modular request-response pipeline for handling HTTP traffic. The framework emphasizes security and maintainability, offering a suite of tools to protect against common web vulnerabilities while decoupling site structure from implementation through a centralized URL routing system. A defining characteristic of the framework is its ability to generate production-read

Prisma is a database toolkit that provides a unified access layer for interacting with relational and document databases. It centers on a declarative schema modeling approach, where developers define their data structures in a human-readable language. This schema serves as the single source of truth, from which the toolkit automatically generates type-safe database clients that provide compile-time validation and editor autocomplete for all data operations. The project distinguishes itself through a high-performance, Rust-based query engine that handles query planning and connection pooling o

TypeORM is an object-relational mapper for TypeScript and JavaScript that bridges the gap between object-oriented application code and relational database tables. It provides a comprehensive data persistence layer that allows developers to define database entities using class decorators or configuration objects, enabling seamless interaction with data through object-oriented patterns. The project distinguishes itself through a flexible architecture that supports both the data mapper and repository patterns, alongside a fluent query builder that translates high-level method calls into platform

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-

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.

SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for interacting with relational databases. It serves as a foundational layer for database connectivity, offering both a high-level object-oriented interface for data persistence and a programmatic SQL expression language for constructing complex, dialect-agnostic queries. The project distinguishes itself through its sophisticated unit of work persistence, which coordinates atomic transactions and tracks object state changes to minimize redundant database operations. It provides a

Mikro-ORM is a TypeScript-based object-relational mapping system that provides a unified persistence layer for Node.js applications. It translates TypeScript entities into relational or document-based database schemas, supporting a variety of engines including PostgreSQL, MySQL, MariaDB, MS SQL Server, SQLite, and MongoDB. The project implements the data mapper pattern to decouple in-memory domain models from the database persistence layer. It utilizes a unit of work pattern to track entity changes in memory and commit them in a single coordinated database transaction. The library covers com

Tortoise ORM is an asynchronous object-relational mapper for Python that mirrors Django's model and queryset API while running on asyncio. It defines database tables as Python classes with typed fields and supports foreign key, many-to-many, and one-to-one relations, providing a chainable query API for filtering, annotating, grouping, and prefetching related objects without blocking the event loop. The ORM includes a built-in migration engine that detects model changes, generates migration files, and applies or reverts schema changes through a command-line tool. It connects to PostgreSQL, MyS

Dieses Projekt ist eine SQL-Datenzugriffsschicht und ein Schema-Generator, der das Lesen und Schreiben von Datensätzen in relationalen Datenbanken ermöglicht, indem Tabellen als einfache Datenstrukturen behandelt werden. Es fungiert als automatischer Schema-Generator, der Datenbanktabellen und Spalten basierend auf der Struktur der eingehenden Daten im laufenden Betrieb erstellt. Das Tool bietet einen hochperformanten Bulk-Loader, der große Datensätze unter Verwendung gruppierter atomarer Transaktionen importiert, um Datenkonsistenz zu gewährleisten. Es enthält zudem einen Record-Upsert-Mechanismus, der basierend auf eindeutigen Identifikatoren bestimmt, ob eine bestehende Zeile aktualisiert oder eine neue eingefügt werden soll. Das System deckt dynamisches Schema-Management ab, einschließlich impliziter Spaltenauflösung und Tabellenbereitstellung. Es bietet zudem eine sammlungsbasierte Abfrageschnittstelle zum Abrufen von Datensätzen oder Extrahieren eindeutiger Werte, ohne manuelle Abfragen schreiben zu müssen.

MongoEngine ist ein Python-Object-Document-Mapper, der Datenbankeinträge in Objekte übersetzt, um eine objektorientierte Schnittstelle für die Datenpersistenz bereitzustellen. Er dient als Dokument-Manager und Schema-Validator für MongoDB und bildet Klassen auf Dokumente ab, um Datentypen und Validierungsregeln durchzusetzen. Das Projekt bietet ein Lazy-Loaded-Queryset-System zum Filtern, Sortieren und Aggregieren von Sammlungen unter Verwendung einer Python-Syntax. Es verwaltet komplexe Datenstrukturen durch Funktionen wie Dokumentenvererbung, rekursive Handhabung eingebetteter Dokumente und referenzbasierte Objektverknüpfung. Die Bibliothek deckt breite Funktionen ab, einschließlich Schema-Migration, Volltextsuche und die Verwaltung großer Binärdateien über das GridFS-Dateisystem. Sie enthält zudem Tools zur Optimierung von Datenbankindizes, zur Profilierung der Abfrageleistung und signalbasierte Lifecycle-Hooks, um Logik während Dokumentenereignissen zu automatisieren.

Pony is a Python object-relational mapper that maps classes to relational database tables using an object-oriented interface. It serves as a relational database toolkit providing the means to manage database transactions, identity mapping, and the lazy loading of related records. The project is distinguished by a SQL query translator that converts Python generator expressions into optimized SQL queries by analyzing the abstract syntax tree. It also includes a visual database schema designer for creating entity-relationship diagrams to automatically generate and synchronize relational database

Full-stack CRUD, simplified, with SSOT TypeScript entities

A curated list of awesome tools for SQLAlchemy

Asynchronous Python ODM for MongoDB

A pythonic interface to Amazon's DynamoDB

⚡️ Neuledge streamlines database modeling with clear data entity definitions, customizable validation, and advanced business-logic representation.

Node.js ORM written in TypeScript for type lovers.