Struct PgCache 

pub struct PgCache { /* private fields */ }

PostgreSQL-backed implementation of the LlmCache trait.

Stores serialized ChatResponse values in a PostgreSQL table with optional TTL expiration. Call initialize once after construction to create the backing table (idempotent).

Example

use sqlx::postgres::PgPoolOptions;
use synaptic_postgres::{PgCache, PgCacheConfig};

let pool = PgPoolOptions::new()
    .max_connections(5)
    .connect("postgres://user:pass@localhost/mydb")
    .await?;

let config = PgCacheConfig::new("llm_cache").with_ttl(3600);
let cache = PgCache::new(pool, config);
cache.initialize().await?;

Implementations

impl PgCache

pub fn new(pool: PgPool, config: PgCacheConfig) -> Self

Create a new PgCache from an existing connection pool and config.

pub async fn initialize(&self) -> Result<(), SynapticError>

Ensure the backing table exists.

This is idempotent and safe to call on every application startup.

pub fn pool(&self) -> &PgPool

Return a reference to the underlying connection pool.

pub fn config(&self) -> &PgCacheConfig

Return a reference to the configuration.

Trait Implementations

impl LlmCache for PgCache

fn get<'life0, 'life1, 'async_trait>( &'life0 self, key: &'life1 str, ) -> Pin<Box<dyn Future<Output = Result<Option<ChatResponse>, SynapticError>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait,

Look up a cached response by cache key.

fn put<'life0, 'life1, 'life2, 'async_trait>( &'life0 self, key: &'life1 str, response: &'life2 ChatResponse, ) -> Pin<Box<dyn Future<Output = Result<(), SynapticError>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait, 'life1: 'async_trait, 'life2: 'async_trait,

Store a response in the cache.

fn clear<'life0, 'async_trait>( &'life0 self, ) -> Pin<Box<dyn Future<Output = Result<(), SynapticError>> + Send + 'async_trait>>

where Self: 'async_trait, 'life0: 'async_trait,

Clear all entries from the cache.