SQLite database migrations directly in the browser, built with WebAssembly

The runtime needs JavaScript. Without it this page is still the schema, the file list and the exact commands — they run on your machine instead.

The page below is already yours to read. Only running a command waits for this.

-- The schema you want the database to have. -- -- Ptah reads this file as the desired state, reads the real catalog out of -- app.db, and works out the difference. You never write ALTER statements here. CREATE TABLE users ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, email TEXT NOT NULL ); CREATE TABLE tasks ( id INTEGER PRIMARY KEY, user_id INTEGER NOT NULL, title TEXT NOT NULL, done INTEGER NOT NULL DEFAULT 0, FOREIGN KEY (user_id) REFERENCES users (id) );

Nothing has been read out of SQLite yet.

This pane only ever shows rows and columns the database actually returned, after a command finished. The list on the left is what the seed will create; it is marked from the seed until the catalog has been read back.

# Scenario A · users + tasks · synthetic data

# The workspace is seeded once the runtime is up; nothing has run yet.