← back to Wine Finder Next

lib/db.ts

14 lines

// lib/db.ts
import Database from 'better-sqlite3';
import path from 'path';

let db: Database.Database | null = null;

export function getDb() {
  if (!db) {
    const dbPath = path.join(process.cwd(), 'data', 'wine_engine.db');
    db = new Database(dbPath);
    db.pragma('foreign_keys = ON');
  }
  return db;
}