Python Async SQL Engines
Project description
PySQLXEngine
PySQLXEngine, a minimalist SQL engine
Documentation: https://carlos-rian.github.io/pysqlx-engine/
Source Code: https://github.com/carlos-rian/pysqlx-engine
I'm writing a new version with native support between Rust and Python using the Pyo3 lib, making this lib smaller and extremely faster, in some tests it's even 10x faster than the current version!
The version 1.0.0 may have some changes in the type core, but it will become very friendly, but there will be a break in compatibility between version zero and 1.0.0!
PySQLXEngine supports the option of sending raw sql to your database.
The PySQLXEngine is a minimalist Async SQL engine. Currently this lib only supports async and sync programming.
Database Support:
SQLite
PostgreSQL
MySQL
Microsoft SQL Server
OS Support:
Linux
MacOS
Windows
Installation
PIP
$ pip install pysqlx-engine
Poetry
$ poetry add pysqlx-engine
Async Example
- Create
main.py
file.
import asyncio
from sqlx_engine import SQLXEngine
uri = "file:./db.db"
db = SQLXEngine(provider="sqlite", uri=uri)
async def main():
await db.connect()
rows = await db.query(query="select 1 as number")
print(rows)
asyncio.run(main())
- Run it
$ python3 main.py
[BaseRow(number=1)]
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pysqlx_engine-0.1.23.tar.gz
(19.5 kB
view hashes)
Built Distribution
Close
Hashes for pysqlx_engine-0.1.23-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 63065903936086e621810a62e425e7483be80e5824dc160ea2550ae49ab84ba4 |
|
MD5 | f340d16b276038460830da5a1814ddc9 |
|
BLAKE2b-256 | 9ea1f17672da70ec779cdc00156beaaa1f2d3a04404105ffe428b907df6f157b |