@fedify/postgres: PostgreSQL drivers for Fedify

This package provides Fedify's KvStore and MessageQueue implementations for PostgreSQL:

• PostgresKvStore
• PostgresMessageQueue

import { createFederation } from "@fedify/fedify";
import { PostgresKvStore, PostgresMessageQueue } from "@fedify/postgres";
import postgres from "postgres";

const sql = postgres("postgresql://user:password@localhost/dbname");

const federation = createFederation({
  kv: new PostgresKvStore(sql),
  queue: new PostgresMessageQueue(sql),
});

PostgresKvStore uses a crash-safe logged table by default. For transient data where losing the table contents after a PostgreSQL crash is acceptable, pass { unlogged: true } as its second constructor argument.

When a store created by an earlier version still uses an unlogged table, its next initialization converts that table to logged storage. PostgreSQL rewrites the table and takes an ACCESS EXCLUSIVE lock during this one-time migration, so schedule the upgrade accordingly for a large or busy table.

Installation

deno add jsr:@fedify/postgres  # Deno
npm  add     @fedify/postgres  # npm
pnpm add     @fedify/postgres  # pnpm
yarn add     @fedify/postgres  # Yarn
bun  add     @fedify/postgres  # Bun