pysqlx-engine 0.1.7

Python Async SQL Engines

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)]