src/db/client.ts

import { drizzle } from 'drizzle-orm/expo-sqlite';
import { openDatabaseSync } from 'expo-sqlite';
import * as schema from './schema';

// ─── SQLite database connection ─────────────────────────────────────────────────
// We open a single persistent database file.  WAL mode is enabled for better
// concurrent read performance, and foreign-key enforcement is turned on so
// cascading deletes work as expected.

const expoDb = openDatabaseSync('antaram.db');

// Enable WAL mode and foreign keys immediately after opening
expoDb.execSync('PRAGMA journal_mode = WAL;');
expoDb.execSync('PRAGMA foreign_keys = ON;');

export const db = drizzle(expoDb, { schema });