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 este un sistem de versionare a schemei bazei de date și un instrument de migrare pentru SQLAlchemy. Acesta gestionează actualizările incrementale ale structurilor bazei de date folosind scripturi versionate care suportă atât upgrade-ul, cât și downgrade-ul pentru a menține baza de date și codul sincronizate. Sistemul utilizează un graf aciclic direcționat pentru gestionarea migrării, ceea ce permite versionarea neliniară, inclusiv ramificarea și fuziunea pe mai multe versiuni rădăcină. Include un instrument automat de diffing al schemei care compară schemele bazei de date live cu obiectele de metadate pentru a genera programatic instrucțiuni de migrare. Instrumentul oferă capabilități pentru evoluția tranzacțională a schemei pentru a asigura actualizări atomice și a preveni coruperea parțială a bazei de date. Funcționalitatea suplimentară include traducerea directivelor de migrare în șiruri SQL brute pentru auditare și menținerea urmăririi versiunilor bazate pe scripturi printr-un tabel dedicat al bazei de date.

Hmily este un framework de tranzacționare distribuită și un manager de consistență a datelor conceput pentru a menține starea în mai multe servicii. Operează ca un coordonator care urmărește stările tranzacțiilor prin apeluri de procedură la distanță (RPC) pentru a gestiona operațiunile imbricate și a asigura finalizări atomice. Proiectul implementează tiparul SAGA pentru a orchestra procesele de business de lungă durată printr-o secvență de tranzacții locale și acțiuni compensatorii automate. Se distinge prin automatizarea generării și execuției scripturilor de rollback pentru bazele de date relaționale, pentru a recupera în urma excepțiilor de business și a restabili consistența datelor. Framework-ul acoperă gestionarea tranzacțiilor distribuite folosind tipare de tip try-confirm-cancel și oferă un strat de persistență pentru înregistrarea istoricelor operațiunilor în baze de date relaționale și de documente. Include, de asemenea, o interfață de gestionare pentru monitorizarea ciclului de viață al tranzacțiilor, pentru a audita tranzițiile de stare și a observa starea de sănătate a sistemului.

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

This project is an asyncio database abstraction layer that provides a common interface for performing non-blocking database operations in Python. It functions as an asynchronous database driver wrapper and a SQL expression builder, allowing for the construction of raw SQL strings from structured Python objects. The library includes an asyncio connection pool manager that utilizes task-local storage to handle connection lifecycles and reduce resource overhead. It also serves as an async database transaction manager, wrapping operations in atomic transactions and savepoints to maintain data int

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