Postgres Database Backend

This module provides the PostgreSQL implementation of the BaseDatabase interface. It is a robust, production-ready database backend.

Overview

The PostgresDatabase class can be used to create a database connection to a PostgreSQL server.

Typical usage:

import asyncio
from agentstr.database.postgres import PostgresDatabase

# Note: To run this example, you need a running PostgreSQL server
# and the 'asyncpg' driver installed.
# pip install asyncpg

# Create a database instance with the connection string
db = PostgresDatabase(conn_str="postgresql://user:password@host/dbname")

async def main():
    await db.async_init()
    print("Connection to PostgreSQL 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