Your data
Everything Alto stores is on your own computer.
- Alto has no accounts, no sync and no analytics.
- Your name is only a label for a profile in a local file.
Where it is
Your practice history, profiles included, is one SQLite file named alto.db:
| System | Location |
|---|---|
| Linux | ~/.local/share/Alto/alto.db |
| macOS | ~/Library/Application Support/Alto/alto.db |
| Windows | C:\Users\<you>\AppData\Roaming\Alto\alto.db |
To keep a second copy of Alto apart, for example one you are changing while you use the installed one to practise, set
ALTO_HOME to a folder. Alto then keeps its history in data/alto.db there and its settings in config/, and leaves the
usual places alone. scripts/dev.sh starts Alto from a clone this way, in ~/.alto-dev.
Your settings (theme, notation style, keyboard style, instrument, exercise options and the last profile you used) are stored separately by Qt, in your usual configuration location.
What the file contains
| Table | Holds |
|---|---|
profiles |
Each profile’s name and when it was created. |
attempts |
One row for every answer: the profile, exercise, question, your answer, whether it was right, the attempt number, how long it took and when. |
items |
What is known about each question: its strain, how often it was answered and missed, its typical time, when it was last seen, and the question itself so it can be asked again. |
Because it is a normal SQLite file, you can open it with any SQLite tool if you want to run your own queries. Close Alto first. Alto’s own database browser is read-only.
Backing up and restoring
Open the menu (☰) and choose Export backup… to save everything Alto keeps to one file: all the profiles, every answer and the record of each question, and every setting (the theme, the notation and keyboard styles, the instrument, each exercise’s options and the profile you used last). Choose Import backup… to read one back.
Importing replaces everything with the backup, so on a clean install, or on another computer, Alto comes up exactly as it
was when the backup was made: same profiles, same history, same settings, and the same profile open. Nothing is merged. What
is there before the import is gone from the app, so Alto saves a backup of it first, next to alto.db in a file named
alto-before-import-<date and time>.altobackup. If you imported the wrong file, import that one to put everything back.
- A backup file ends in
.altobackup. It is a zip file holding the database, the settings and a note of which version of Alto made it, with a checksum of each part. - Before anything is changed, Alto checks the file all the way through. A file that is damaged, is not an Alto backup, or was made by a newer version of Alto is refused with an explanation, and nothing changes. A backup from an older version is brought up to date as it is imported.
- A backup contains your whole practice history, so keep it as private as the history itself.
To move to another computer: install Alto there, start it once (it asks for a first profile), then import the backup.
Copying the files by hand
- Back up the history only: close Alto and copy
alto.dbsomewhere safe. Copy it back to restore it. This leaves out the settings; Export backup… includes them. - Move the history to another computer: copy the file to the same location there.
- Start over: close Alto and delete
alto.db. The next launch asks for a new profile and starts with an empty history.