Fringe Division

Appearance

SQLite ​

bash
.tables
.schema $TABLE

Backup ​

bash
sqlite3 my_database.db ".dump table1 table2 table3" > table_backup.sql
sqlite3 my_database.db < table_backup.sql

If there are relations

bash
ATTACH DATABASE 'habits.sqlite.bak' AS old_db;

INSERT INTO main.habit SELECT * FROM old_db.habit;
INSERT INTO main.activity SELECT * FROM old_db.activity;