SQLiteStateStore

SQLiteStateStore provides a State Store using local SQLite databases with support for multiple SQLite engines including Bun SQLite, better-sqlite3, and libSQL.

Note

See the SQLiteStateStore documentation for more details.

1. Configure SQLiteStateStore

   Update your alchemy.run.ts to use local SQLite state storage:

   import alchemy from "alchemy";
   import { SQLiteStateStore } from "alchemy/sqlite";
   
   const app = await alchemy("my-app", {
     stateStore: (scope) => new SQLiteStateStore(scope)
   });
   
   // Your resources here...
   
   await app.finalize();

2. Run your app

   Execute your Alchemy script to initialize the SQLite state store:

   bun

   bun ./alchemy.run.ts

   npm

   npx tsx ./alchemy.run.ts

   pnpm

   pnpm tsx ./alchemy.run.ts

   yarn

   yarn tsx ./alchemy.run.ts

   Alchemy automatically creates a SQLite database at .alchemy/state.sqlite.

3. Verify the state store

   Check that the database file was created:

   ls -la .alchemy/
   # You should see state.sqlite

4. View in your editor

   Most IDEs can view the SQLite database file directly.