sql-switch - v1.0.1

Public entry point — the fluent API facade.

One API, two engines. db.schema("antinuke").table("settings").key("guild_123") resolves to ./data/databases/antinuke.db (table settings) in local mode, or the Postgres logical schema antinuke.settings in cloud mode. Application code never changes.

Example: Connecting

import { createDAL } from 'sql-switch';

const db = createDAL();
await db.connect({
  db: { mode: 'local', dataDir: './data/databases', wal: true },
  collector: { enabled: true, time: 3000 },
});

Example: Reading & writing

// read
const settings = await db.schema('antinuke').table('settings').key('guild_123').get();

// write (queued to the collector, flushed in bulk)
await db.schema('antinuke').table('settings').key('guild_123').set({ strict: true });

// write immediately, bypassing the collector
await db.schema('antinuke').table('settings').key('guild_123').set({ strict: true }).force();