Python Async SQL Engines
Project description
PySQLXEngine
PySQLXEngine, a minimalist asynchronous SQL engine
Documentation: https://carlos-rian.github.io/pysqlx-engine/
Source Code: https://github.com/carlos-rian/pysqlx-engine
PySQLXEngine supports the option of sending raw sql to your database.
The PySQLXEngine is a minimalist Async SQL engine. Currently this lib only supports asynchronous programming, you need to code your code using await
in all methods.
Database Support:
SQLite
PostgreSQL
MySQL
Microsoft SQL Server
OS Support:
Linux
Windows
Experimental! Unit tests were not run on Windows.
Installation
PIP
$ pip install pysqlx-engine
Poetry
$ poetry add pysqlx-engine
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.11.tar.gz
(16.2 kB
view hashes)
Built Distribution
Close
Hashes for pysqlx_engine-0.1.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 17737befe464e87c88dcedc263d08276c660161651050162ba16dfc36be5ccd9 |
|
MD5 | 5540ec235644ec5802df1a2cfc082eba |
|
BLAKE2b-256 | c5086ff591a189013dff279e908dea6a21e88c08545c3fe004972670e5ca0f29 |