SQLite Database Backend

This module provides the SQLite implementation of the BaseDatabase interface. It is a lightweight, file-based database backend that is suitable for local development and testing.

Overview

The SQLiteDatabase class can be used to create a database connection to a local SQLite file.

Typical usage:

import asyncio
from agentstr.database.sqlite import SQLiteDatabase

# Create a database instance for an in-memory database
db = SQLiteDatabase(conn_str="sqlite://:memory:")

async def main():
    await db.async_init()
    print("Connection to SQLite successful.")
    # ... perform database operations
    await db.close()
    print("Connection closed.")

# To run this, you would typically use:
# if __name__ == "__main__":
#     asyncio.run(main())

Reference

See Also