Step 2: a real database¶

The application needs the PostgreSQL driver, and a new DATABASE_URL. The database and its user must exist; the migrations create the tables:

$ uv add 'myxo[postgresql]'
$ export DATABASE_URL=postgresql://guestbook@db.example.org/guestbook
$ myxo migrate layouts/app.toml
$ myxo up layouts/app.toml

Book's entries and the framework's events are now in PostgreSQL. On PostgreSQL, NOTIFY wakes moderation as an event commits; on SQLite it looks every 50 ms. The installation starts with an empty database: what SQLite holds stays in its file. Myxo has no tool yet to move it.

Next, read step 3, on a platform.