encode/databasesArchived
Databases
Este proyecto es una capa de abstracción de base de datos asyncio que proporciona una interfaz común para realizar operaciones de base de datos no bloqueantes en Python. Funciona como un wrapper de driver de base de datos asíncrono y un constructor de expresiones SQL, permitiendo la construcción de cadenas SQL crudas a partir de objetos estructurados de Python.
La biblioteca incluye un gestor de pool de conexiones asyncio que utiliza almacenamiento local de tareas para manejar los ciclos de vida de las conexiones y reducir la sobrecarga de recursos. También sirve como gestor de transacciones de base de datos asíncrono, envolviendo operaciones en transacciones atómicas y puntos de guardado (savepoints) para mantener la integridad de los datos.
El sistema cubre capacidades amplias, incluyendo streaming de datos asíncrono para procesar grandes conjuntos de resultados sin un alto uso de memoria y la gestión de esquemas de base de datos. Además, proporciona herramientas para pruebas automatizadas de bases de datos aislando los datos de prueba mediante rollbacks de transacciones.
Features
- Database Abstraction Layers - Provides a unified asyncio interface for performing non-blocking database operations across multiple drivers.
- Database Driver Abstractions - Provides a common abstraction layer that wraps multiple asynchronous database drivers for a consistent API.
- Asynchronous Database Drivers - Provides non-blocking database operations via asynchronous drivers and structured query expressions.
- Connection Pooling - Implements an asynchronous connection pooling system to optimize resource efficiency across Python tasks.
- Connection Pools - Maintains a cache of reusable database connections to improve efficiency across asynchronous tasks.
- Task-Local - Utilizes task-local storage in its connection pool manager to ensure connection reuse throughout specific asynchronous chains.
- Connection Pool Managers - Automatically manages the lifecycle of database connections to optimize resource utilization.
- Database Query Execution - Enables execution of SQL queries for data retrieval and schema modification through a common interface.
- Database Transaction Management - Manages database transaction boundaries and savepoints to ensure atomic changes and data integrity.
- Database Transactions - Ensures data consistency by wrapping multiple operations in ACID-compliant transactions and savepoints.
- SQL Expression Builders - Ships a SQL expression builder that translates structured Python objects into raw SQL strings for execution.
- Query Result Fetching - Offers asynchronous methods to retrieve single values, individual rows, or complete result sets.
- Non-Blocking Event Loops - Implements a non-blocking event loop architecture to execute database I/O without pausing the Python main thread.
- Cursor-Based Result Streamers - Provides asynchronous cursors to stream large database result sets incrementally and minimize memory usage.
- Nested Transactions - Supports nested transactions and savepoints to group multiple database operations into atomic units.
- Row-Based Result Streaming - Iterates through database records sequentially using asynchronous cursors to prevent high memory consumption.
- SQL Query Builders - Offers a programmatic builder to construct raw SQL strings from structured Python objects.
- Asynchronous Database Result Streams - Processes large database result sets by iterating over rows one by one to avoid high memory usage.
- Transaction-Based Test Isolation - Provides automated database testing by isolating test data through mandatory transaction rollbacks.
- Test Data Isolation - Isolates test data by wrapping each test case in a transaction that is rolled back upon completion.
- Database Clients - Async database support.
- Database Drivers - Async database access layer for SQLAlchemy core.
- Query Builders - Async SQL query builder for SQLAlchemy Core.
