@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),
});

Installation

Deno

deno add @fedify/postgres

Node.js

npm install @fedify/postgres

Bun

bun add @fedify/postgres

Changelog

Version 0.3.0

To be released.

Version 0.2.2

Released on November 18, 2024.

• Fixed a bug where binding parameters have not been properly escaped with some settings of Postgres.js.

Version 0.2.1

Released on November 3, 2024.

• Fixed a bug where some scalar values have failed to be stored in the database.

Version 0.2.0

Released on November 3, 2024.

• Fixed a bug where JSON values are double-quoted in the database. Since it's a breaking change data-wise, the default values of the following options are also changed:

  • PostgresKvStoreOptions.tableName defaults to "fedify_kv_v2".
  • PostgresMessageQueueOptions.tableName defaults to "fedify_message_v2".

Version 0.1.0

Initial release. Released on September 26, 2024.