encode/databasesArchived
Databases
该项目是一个 asyncio 数据库抽象层，为在 Python 中执行非阻塞数据库操作提供了通用接口。它作为一个异步数据库驱动包装器和 SQL 表达式构建器，允许从结构化的 Python 对象构建原始 SQL 字符串。
该库包含一个 asyncio 连接池管理器，利用任务本地存储来处理连接生命周期并减少资源开销。它还作为异步数据库事务管理器，将操作包装在原子事务和保存点中以维护数据完整性。
该系统涵盖了广泛的功能，包括用于处理大数据集而不占用大量内存的异步数据流，以及数据库模式管理。此外，它还通过事务回滚隔离测试数据，为自动化数据库测试提供了工具。
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.
