petermillspaugh

copy-sqlite-table

Copy database tables from account-scoped to val-scoped SQLite

Public

Val Town is a collaborative website to build and scale JavaScript apps.

Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.

Code

README.md

…

Viewing readonly version of main branch: v9

View latest version

README.md

SQLite table migration

Generic script to migrate one table from your Val Town account-based (global) database to a val-scoped database.

You can copy-paste the migrate.ts file into any val you'd like to migrate. Does not handle:

Multiple tables
Indexes
Triggers
Views

Townie (Normal mode, Claude Sonnet 4.6) was quite helpful in building this does-one-thing migrator, so I bet it would be straightforward to remix this val to handle any of the above.