import itemdb
# Open the database and make sure there is a table with appopriate indices
db = itemdb.ItemDB(":memory:")
db.ensure_table("persons", "!name", "age")
# Add some items to the db
with db:
    db.put_one("persons", name="Jane", age=22)
    db.put_one("persons", name="John", age=18, fav_number=7)
    db.put("persons", {"name": "Guido"}, {"name": "Anne", "age": 42})
# Update an item
with db:
    db.put_one("persons", name="John", age=19, fav_number=8)
# Query items
db.count_all("persons")  # -> 4
db.select("persons", "age > ?", 20)  # -> list of 2 items

import itemdb
db = await itemdb.AsyncItemDB(":memory:")
await db.ensure_table("persons", "!name", "age")
async with db:
    await db.put_one("persons", name="Jane", age=22)
...

@asycify
def your_db_interaction_logic(...):
    db = ItemDB(filename)
    ...
async def your_async_code(...):
    await your_db_interaction_logic(...)