@supa-pay/adapter-sql

SQL database adapters for SupaPay (PostgreSQL, MySQL, SQLite).

Install

npm install @supa-pay/adapter-sql

And the driver you need:

npm install pg        # PostgreSQL
npm install mysql2    # MySQL
npm install better-sqlite3  # SQLite

Usage

PostgreSQL

import { supaPay } from "@supa-pay/supa-pay";
import { pg } from "@supa-pay/adapter-sql";
import { Pool } from "pg";

const pool = new Pool({ connectionString: process.env.DATABASE_URL });

export const pay = supaPay({
  database: pg(pool),
  providers: [],
});

MySQL

import { mysql } from "@supa-pay/adapter-sql";
import mysql2 from "mysql2/promise";

const connection = await mysql2.createConnection(process.env.DATABASE_URL);

export const pay = supaPay({
  database: mysql(connection),
  providers: [],
});

SQLite

import { sqlite } from "@supa-pay/adapter-sql";
import Database from "better-sqlite3";

const db = new Database("supa-pay.db");

export const pay = supaPay({
  database: sqlite(db),
  providers: [],
});