SQLite

npm i @storecraft/database-sqlite

import 'dotenv/config';
import http from "node:http";
import { App } from '@storecraft/core'
import { NodePlatform } from '@storecraft/core/platform/node';
import { NodeLocalStorage } from '@storecraft/core/storage/node'
import { SQLite } from '@storecraft/database-sqlite'
import { migrateToLatest } from '@storecraft/database-sqlite/migrate.js'

const app = new App({
  auth_admins_emails: ['[email protected]'],
})
.withPlatform(new NodePlatform())
.withDatabase(
  new SQLite({ 
    filepath: join(homedir(), 'db.sqlite') 
  })
)
.withStorage(new NodeLocalStorage())
.init();

await migrateToLatest(app.__show_me_everything.db, false);
 
http.createServer(app.handler).listen(
  8000,
  () => {
    app.print_banner('http://localhost:8000');
  }
);

SQLITE_FILEPATH=./data.db

.withDatabase(
  new SQLite()
)

npm run database-sqlite:test