What does encode/databases do?

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.

What are the main features of encode/databases?

The main features of encode/databases are: Database Abstraction Layers, Database Driver Abstractions, Asynchronous Database Drivers, Connection Pooling, Connection Pools, Task-Local, Connection Pool Managers, Database Query Execution.

What are some open-source alternatives to encode/databases?

Open-source alternatives to encode/databases include: codeigniter4/codeigniter4 — CodeIgniter is a PHP web framework built on the Model-View-Controller pattern, designed for building full-stack web… doctrine/dbal — This project is a SQL database abstraction layer that provides a consistent object-oriented interface for interacting… coleifer/peewee — Peewee is a SQL object-relational mapper and query builder that provides an object-oriented interface for mapping… magicstack/asyncpg — asyncpg is an asynchronous database driver and binary protocol client for PostgreSQL. It provides a non-blocking… tortoise/tortoise-orm — Tortoise ORM is an asynchronous object-relational mapper for Python that mirrors Django's model and queryset API while… sqlalchemy/sqlalchemy — SQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for…

Databases - ejecuta consultas SQL asíncronas…

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.

Alternativas open-source a Databases

Proyectos open-source similares, clasificados según cuántas características comparten con Databases.

codeigniter4/codeigniter4
codeigniter4/CodeIgniter4
5,924Ver en GitHub
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
PHPcodeignitercodeigniter4framework-php
Ver en GitHub5,924
doctrine/dbal
doctrine/dbal
9,699Ver en GitHub
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
PHPdatabaseibm-db2mariadb
Ver en GitHub9,699
coleifer/peewee
coleifer/peewee
11,971Ver en GitHub
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.
Pythonasynciodankfastapi
Ver en GitHub11,971
magicstack/asyncpg
MagicStack/asyncpg
7,953Ver en GitHub
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
Pythonasync-programmingasync-pythonasyncio
Ver en GitHub7,953

Ver las 30 alternativas a Databases

Databases - ejecuta consultas SQL asíncronas… | Awesome Repos

encodedatabasesArchived

Databases

Features

Alternativas open-source a Databases

codeigniter4/CodeIgniter4

doctrine/dbal

coleifer/peewee

MagicStack/asyncpg

Frequently asked questions

Historial de estrellas

Alternativas open-source a Databases

codeigniter4/CodeIgniter4

doctrine/dbal

coleifer/peewee

MagicStack/asyncpg

Frequently asked questions