@filepack/adapter-drizzle

Transactional PostgreSQL implementation of Filepack's FileRecordStore using Drizzle ORM.

import { drizzle } from "drizzle-orm/postgres-js";
import {
  drizzleAdapter,
  filepackRecordsSchema,
} from "@filepack/adapter-drizzle";

const db = drizzle(postgresClient, { schema: filepackRecordsSchema });
const records = drizzleAdapter(db);

Apply the exported migrationSql through the host migration system before startup. The adapter never creates or changes tables automatically. Existing M2 installations can apply the additive d028MigrationSql instead. It adds cleanup deadlines and durable marker state. Installations already on D-028 can apply d031MigrationSql. It adds multipart attempt fields, durable part receipts, and cleanup session IDs.

See the repository migration guide for the upgrade and deployment sequence. The host owns backups, migration history, and rollback.