#vr-chat #rest #vrc #api

yanked onlivfe_db_store

A database storage backed for onlivfe

0.0.0-alpha.0 Mar 4, 2023

#11 in #vr-chat


215 lines


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


The DB storage backend that can be used to power onlivfe.

Very WIP.


~1.5M SLoC