onlivfe_db_store

The database storage backend of onlivfe. One ready made option for core's storage backend, utilizing an SQLite database using SQLx.

SQLx CLI (cargo install sqlx-cli --no-default-features --features sqlite) can be very useful when working on this.

Database changes

Generally speaking, you first generate a new migration:

sqlx migrate add NAME_OF_MIGRATION

Then write the SQL changes, and then re-generate the schema by running the migrations:

# Drop DB, recreate it and run all migrations
sqlx database drop && sqlx database create && sqlx migrate run
# Save metadata
cargo sqlx prepare