- fix login textedit
- Ensure that
.cargo/config.tomlholds the correct url to the database- (needed for compile-time query checking by sqlx)
- RPi: username:
pi, password:piuser4 - Software
- Sqlitestudio
bacon clippy
- Add rustup target for ARM architecutre
- config in
.cargo/config.toml rustup target add aarch64-unknown-linux-gnu
- config in
- setting effective user id (euid) in main to 1000 (user) to not mess things up accidentally
- new spawned processes (mount / umount) will inherit uid=0
- rust std functions will require manually setting euid to 0
ssh <user>@<ip>
On the host machine:
ssh-keygen -t rsassh-copy-id -i ~/.ssh/id_rsa.pub <user>@<ip>
-
Run setup script
sqlite3 database.db < db_scripts/setup.sql(bash-specific)
or:sqlite> .read db_scripts/setup.sql
-
Load Data (optional)
db_scripts/examples.sql(for testing)db_scripts/default.sql(for production)- process is the same as setup
-
Verify Setup
sqlite> .tablessqlite> .schemasqlite> SELECT * FROM <table>