Awesome GitHub RepositoriesNested Transactions

Seata is a distributed transaction coordinator designed to ensure data consistency and atomicity across microservices. It provides a centralized framework for managing global transactions, preventing partial data updates across different databases and services. The project implements multiple transaction modes to balance consistency and performance. This includes an automatic mode that uses rollback logs to coordinate compensation without modifying business logic, a try-confirm-cancel pattern for resources lacking native ACID support, and a saga orchestration engine for managing long-lived bu

Crystal is a statically typed, compiled programming language designed for high performance and memory safety. It leverages an LLVM-based compiler to translate source code into optimized machine-executable binaries, while its type-inference-based static analysis enforces strict safety rules during the build process. The language distinguishes itself through a fiber-based concurrent runtime that manages lightweight execution units for asynchronous input and output without blocking the main process. It also features a powerful compile-time macro system that allows for the inspection and transfor

Solana is a high-performance blockchain platform designed for decentralized applications and global financial systems. It provides a distributed ledger infrastructure that utilizes proof-of-stake consensus to maintain network integrity and secure digital assets. The platform includes a specialized runtime environment for executing smart contracts and a framework for developing programs in Rust. The system distinguishes itself through a suite of architectural components that enable high-throughput transaction processing. It employs a cryptographic clock mechanism to sequence transactions befor

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

This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting with multiple relational database systems. It includes a driver wrapper to standardize connections and result sets, a fluent query builder for constructing portable SQL statements, and a type mapper for converting database-specific data types into native application types and vice versa. The library enables programmatic schema management through a schema manager that can introspect database metadata, model structures as objects, and generate the SQL required to migrate between

Atlas is a SQL database schema management tool and database infrastructure as code framework. It provides a declarative database migration engine that computes the difference between a desired schema state and the current database state to automatically generate the necessary SQL for transitions. The project distinguishes itself through a comprehensive suite of analysis and visualization tools, including a database schema linter that detects destructive changes and data loss risks. It also features a SQL schema visualization tool capable of generating entity-relationship diagrams from extract

asyncpg is an asynchronous database driver and binary protocol client for PostgreSQL. It provides a non-blocking interface for executing SQL statements, streaming result sets, and managing data transfer between an application and a PostgreSQL database. The driver implements the PostgreSQL binary protocol directly to facilitate efficient data transfer and type conversion. It includes a connection pool to maintain and reuse open database connections, reducing the latency associated with repeated handshakes. The project covers a broad range of database integration capabilities, including atomic

CodeIgniter is a PHP web framework built on the Model-View-Controller pattern, designed for building full-stack web applications. It provides a lightweight toolkit with minimal configuration, organizing application logic into controllers, models, and views for clean separation of concerns. The framework includes a fluent query builder for constructing SQL statements programmatically, PSR-4 autoloading with namespace mapping, and a service-based dependency injection container for managing shared class instances. The framework distinguishes itself through its comprehensive set of built-in tools

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

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

Alembic ist ein Datenbankschema-Versionierungssystem und Migrationstool für SQLAlchemy. Es verwaltet inkrementelle Updates von Datenbankstrukturen mithilfe versionierter Skripte, die sowohl Upgrades als auch Downgrades unterstützen, um Datenbank und Code synchron zu halten. Das System nutzt einen gerichteten azyklischen Graphen für das Migrationsmanagement, was nicht-lineare Versionierung ermöglicht, einschließlich Branching und Merging über mehrere Root-Versionen hinweg. Es enthält ein automatisiertes Schema-Diffing-Tool, das Live-Datenbankschemata mit Metadatenobjekten vergleicht, um programmatisch Migrationsanweisungen zu generieren. Das Tool bietet Funktionen für transaktionale Schema-Evolution, um atomare Updates sicherzustellen und partielle Datenbankkorruption zu verhindern. Zusätzliche Funktionalität umfasst die Übersetzung von Migrationsdirektiven in rohe SQL-Strings für Audits und die Aufrechterhaltung einer skriptbasierten Versionsverfolgung über eine dedizierte Datenbanktabelle.

Hmily ist ein Framework für verteilte Transaktionen und ein Manager für Datenkonsistenz, der darauf ausgelegt ist, den Zustand über mehrere Services hinweg aufrechtzuerhalten. Es arbeitet als Koordinator, der Transaktionszustände über Remote Procedure Calls hinweg verfolgt, um verschachtelte Operationen zu verwalten und atomare Abschlüsse sicherzustellen. Das Projekt implementiert das SAGA-Muster, um langlebige Geschäftsprozesse durch eine Sequenz lokaler Transaktionen und automatisierter kompensierender Aktionen zu orchestrieren. Es zeichnet sich dadurch aus, dass es die Generierung und Ausführung von Rollback-Skripten für relationale Datenbanken automatisiert, um sich von geschäftlichen Ausnahmen zu erholen und die Datenkonsistenz wiederherzustellen. Das Framework deckt das Management verteilter Transaktionen unter Verwendung von Try-Confirm-Cancel-Mustern ab und bietet eine Persistenzschicht zur Aufzeichnung von Operationshistorien über relationale und Dokumentendatenbanken hinweg. Es beinhaltet zudem eine Management-Schnittstelle zur Überwachung des Transaktions-Lifecycles, um Zustandsübergänge zu auditieren und den Systemzustand zu beobachten.

Memgraph is an in-memory, distributed graph database designed for high-performance labeled property graph management. It utilizes a Cypher query engine for declarative data retrieval and manipulation, providing a scalable knowledge graph backend that integrates vector search and graph traversals. The system distinguishes itself as a real-time graph analytics platform, employing native C++ and CUDA implementations to execute complex network analysis and dynamic community detection on streaming data. It provides specialized support for AI integration, including GraphRAG capabilities, the constr

Dieses Projekt ist eine asyncio-Datenbank-Abstraktionsschicht, die eine gemeinsame Schnittstelle für die Durchführung nicht-blockierender Datenbankoperationen in Python bietet. Es fungiert als asynchroner Datenbank-Treiber-Wrapper und SQL-Ausdrucks-Builder, der die Konstruktion von rohen SQL-Strings aus strukturierten Python-Objekten ermöglicht. Die Bibliothek enthält einen asyncio-Connection-Pool-Manager, der Task-lokalen Speicher nutzt, um Verbindungslebenszyklen zu handhaben und den Ressourcenaufwand zu reduzieren. Sie dient zudem als asynchroner Datenbank-Transaktionsmanager, der Operationen in atomaren Transaktionen und Savepoints kapselt, um die Datenintegrität zu wahren. Das System deckt breite Funktionen ab, einschließlich asynchronem Daten-Streaming zur Verarbeitung großer Ergebnismengen ohne hohen Speicherverbrauch sowie der Verwaltung von Datenbankschemata. Darüber hinaus bietet es Tools für automatisierte Datenbanktests durch die Isolierung von Testdaten mittels Transaktions-Rollbacks.

Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database tables to classes and execute SQL queries with build-time validation. It functions as a type-safe query builder and a wrapper for SQLite and PostgreSQL, eliminating manual result set parsing by binding query outputs to native objects. The project distinguishes itself through a build-time code generation system that produces type-safe APIs and validates raw SQL statements against database versions before execution. It features reactive query streaming, which transforms SQL queries