src/db.ts at main · evbogue.com/ANonAT

evbogue.com / ANonAT

ANProto over ATProto -- using Bluesky PDSes to store ANProto messages and blobs

ANonAT / src / db.ts

at main 454 B view raw

 1import Database from 'better-sqlite3'
 2
 3// A simple SQLite database for persisting sessions and auth state.
 4// In a production environment, you might use PostgreSQL, Redis, or another durable store.
 5export const db = new Database('db.sqlite')
 6
 7db.exec(`
 8  CREATE TABLE IF NOT EXISTS auth_state (
 9    key TEXT PRIMARY KEY,
10    state TEXT NOT NULL
11  );
12  CREATE TABLE IF NOT EXISTS auth_session (
13    key TEXT PRIMARY KEY,
14    session TEXT NOT NULL
15  );
16`)