@loop-engine/adapter-postgres

@loop-engine/adapter-postgres provides schema setup and a concrete PostgreSQL LoopStore for runtime persistence.

Install

1npm install @loop-engine/adapter-postgres pg

Schema bootstrap

1createSchema(pool: PgPoolLike): Promise<void>

createSchema() creates:

• loop_instances
• loop_transitions

1import { Pool } from "pg"
2import { createSchema } from "@loop-engine/adapter-postgres"
3 
4const pool = new Pool({ connectionString: process.env.DATABASE_URL })
5await createSchema(pool)

Store factory

1postgresStore(pool: PgPoolLike): LoopStore

postgresStore() implements all LoopStore methods:

• getInstance
• saveInstance
• getTransitionHistory
• saveTransitionRecord
• listOpenInstances

Production notes

• Use pg connection pooling.
• Keep SSL, idle timeout, and max connection settings explicit in deployment config.
• Run createSchema() during provisioning before serving runtime traffic.