Are you tired of the hassle of setting up complex databases for small scale applications and personal projects? Designed to streamline monotony, AIODesa makes managing asynchronous database access easy. Perfect for smaller-scale applications where extensive database operations are not a priority.
A straightforward and 100% Python interface for managing asynchronous database API's by leveraging Python's built-ins and standard library. It wraps around AioSqlite, providing a hassle-free experience to define, generate, and commit data effortlessly, thanks to shared objects for tables and records.
AIODesa is specifically crafted for simpler projects where database IO is minimal. It's not intended for heavy production use but rather serves as an excellent choice for personal projects that require SQL structured data persistence without the complexity of a full-scale database setup. SQLite is leveraged here, meaning youre free to use other SQLite drivers to consume and transform the data if your project outgrows AIODesa.
Install via pip
pip install aiodesa
Sample API usage:
from aiodesa import Db
import asyncio
from dataclasses import dataclass
from aiodesa.utils.tables import ForeignKey, UniqueKey, PrimaryKey, set_key
async def main():
# Define structure for both tables and records
# Easily define key types
@dataclass
@set_key(PrimaryKey("username"), UniqueKey("id"), ForeignKey("username", "anothertable"))
class UserEcon:
username: str
credits: int | None = None
points: int | None = None
id: str | None = None
table_name: str = "user_economy"
async with Db("database.sqlite3") as db:
# Create table from UserEcon class
await db.read_table_schemas(UserEcon)
# Insert a record
record = db.insert(UserEcon)
await record('sockheadrps', id="fffff")
# Update a record
record = db.update(UserEcon, column_identifier="username")
await record('sockheadrps', points=2330, id="1234")
asyncio.run(main())Ensure poetry is installed:
pip install poetry
Install project using poetry
poetry add git+https://github.com/sockheadrps/AIODesa.git
poetry install
create a python file for using AIODesa and activate poetry virtual env to run it
poetry shell
poetry run python main.py