SQLite

import { createServer } from 'experimental-a2/server'
import { sqlite } from 'experimental-a2/store-sqlite'
import { orders } from '@/contracts'

export const ordersServer = createServer({
  contract: orders,
  store: sqlite({ path: '.a2/orders.db' }),
  handlers: {
    /* ... */
  },
})

In development, a server without a store uses SQLite at .a2/dev.db, so your sessions survive next dev restarts. Pass it yourself to pick another file.

It runs on node:sqlite, with no dependencies, and creates its tables when it opens the file. It's for development: a serverless filesystem doesn't last or share one file across instances, so production needs another store.

Options