Struct PgStore 

pub struct PgStore { /* private fields */ }

PostgreSQL-backed implementation of the Store trait.

Uses a single table with (namespace, key) as the composite primary key and stores values as JSONB. Full-text search is supported through a tsvector generated column indexed with GIN, with a LIKE fallback.

Example

use sqlx::postgres::PgPoolOptions;
use synaptic_postgres::{PgStore, PgStoreConfig};

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

let config = PgStoreConfig::new("synaptic_store");
let store = PgStore::new(pool, config);
store.initialize().await?;

Implementations

impl PgStore

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

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

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

Ensure the backing table and indexes exist.

Creates the key-value table, a namespace index, and a tsvector generated column with a GIN index for full-text search. 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) -> &PgStoreConfig

Return a reference to the configuration.

Trait Implementations

impl Store for PgStore

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

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

Get an item by namespace and key.

fn search<'life0, 'life1, 'life2, 'life3, 'async_trait>( &'life0 self, namespace: &'life1 [&'life2 str], query: Option<&'life3 str>, limit: usize, ) -> Pin<Box<dyn Future<Output = Result<Vec<Item>, SynapticError>> + Send + 'async_trait>>

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

Search items within a namespace.

fn put<'life0, 'life1, 'life2, 'life3, 'async_trait>( &'life0 self, namespace: &'life1 [&'life2 str], key: &'life3 str, value: Value, ) -> Pin<Box<dyn Future<Output = Result<(), SynapticError>> + Send + 'async_trait>>

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

Put (upsert) an item.

fn delete<'life0, 'life1, 'life2, 'life3, 'async_trait>( &'life0 self, namespace: &'life1 [&'life2 str], key: &'life3 str, ) -> Pin<Box<dyn Future<Output = Result<(), SynapticError>> + Send + 'async_trait>>

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

Delete an item.

fn list_namespaces<'life0, 'life1, 'life2, 'async_trait>( &'life0 self, prefix: &'life1 [&'life2 str], ) -> Pin<Box<dyn Future<Output = Result<Vec<Vec<String>>, SynapticError>> + Send + 'async_trait>>

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

List all namespaces, optionally filtered by prefix.