The PostgreSQL AnalyticsStore for @byline/analytics. It reuses the host
application's existing pg.Pool and owns its raw-event, salt, aggregate, and
rollup-state tables.
Schema and migrations
The driver follows @byline/search-postgres: numbered SQL files under
migrations/ are the DBA-reviewable source of truth, an embedded byte-matched
copy makes migrate() safe inside Nitro/Rollup server bundles, and
byline_analytics_migrations records applied versions independently of the
application's Drizzle stream.
import { migrate, postgresAnalyticsStore } from '@byline/analytics-postgres'
await migrate(db.pool)
const store = postgresAnalyticsStore({ pool: db.pool })
Production deployments should run migrate() as a deliberate release step.
autoMigrate: true is available for local development.