@pdf-annotator/database-adapters

Database adapters for PostgreSQL, MySQL, and MongoDB.

Installation

npm install @pdf-annotator/database-adapters pg
# or
npm install @pdf-annotator/database-adapters mysql2
# or
npm install @pdf-annotator/database-adapters mongoose

Usage

PostgreSQL

import { createPostgresRepositories } from '@pdf-annotator/database-adapters/postgres';

const repositories = createPostgresRepositories(
  'postgresql://user:password@localhost:5432/database'
);

// Use repositories
const annotation = await repositories.annotations.create({
  pdfId: 'pdf-123',
  identifiedProductId: 'SKU-ABC',
  type: 'SKU',
  pageNumber: 1,
  source: 'manual',
});

Running Migrations

# PostgreSQL
npx drizzle-kit push:pg --config=drizzle.config.ts

License

MIT