PySQLX-Engine with async core #402
Description
First Check
- I added a very descriptive title to this issue.
- I used the GitHub search to find a similar issue and didn't find it.
- I searched the SQLModel documentation, with the integrated search.
- I already searched in Google "How to X in SQLModel" and didn't find any information.
- I already read and followed all the tutorial in the docs and didn't find an answer.
- I already checked if it is not related to SQLModel but to Pydantic.
- I already checked if it is not related to SQLModel but to SQLAlchemy.
Commit to Help
- I commit to help with one of those options 👆
Example Code
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())Description
Check the possibility of using PySQLX-Engine as core to execute raw sql.
Maybe create a wrapper to compile the code in sqlalchemy and run in PySQLX-Engine.
Doc: https://carlos-rian.github.io/pysqlx-engine/
Operating System
Linux, Windows, macOS
Operating System Details
No response
SQLModel Version
v0.0.6
Python Version
^3.8
Additional Context
sqlalchemy currently supports executing sql codes asynchronously on some databases using some drivers.
But not all banks are supported.
PySQLX-Engine was born asynchronous.