One line, and the rows stay
Rows in memory are lost at every restart, so we add SQLite with one line in sources. The app then refuses to start until the table exists, and fougere migrate creates it.
Install
$ npm install @fougere/adapter-sql better-sqlite3fougere.config.ts
1
import '@fougere/adapter-rest';+
import '@fougere/adapter-sql';3
import { defineFougere } from '@fougere/core';4
5
export default defineFougere({6
protocols: { rest: {} },+
sources: { main: { type: 'sqlite', path: '.data/blog.db' } },a b c8
fronds: { '@fougere/log': {} },9
});point at a lettered line, or tap it, to see what grows from it
0 line changed under fronds/
The handler asks for its rows as before. Where they live is a line of config.
Try it
$ npx fougere migrate --latest --apply ◇ create posts ◆ 1 change(s) applied.
On Postgres it is { type: 'pg', url: process.env.DATABASE_URL }, and nothing else in the project changes.