Database utilities

Found under: Settings > Utilities > Database utilities

OpenSongApp encourages you to use OpenSong formatted songs.  When you do this, it builds a database with a reference to every valid file (OpenSong, PDF or image) in your OpenSong/Songs folder when it boots and you allow it to index the songs.  Using the database speeds up dealing with songs and searching when using the app.  This database is referred to as the Temporary database and each time you allow the app to index your songs, the temporary database is recreated.  This database in not usually accessible to users except when using the app.

If you also use PDF/image files as songs, OpenSongApp will also create a Persistent database that can store extra information for these non-editable files to allow you to access some of OpenSongApp's extra features such as MIDI messages, autoscrolling, pads, etc.  This database does not include your PDF files, but simply keeps a reference to them and holds any extra feature information.   This database is then merged with the temporary database when using the app.  This database file can be found at OpenSong/Settings/NonOpenSongSongs.db.  This file is loaded when the app boots up and you allow indexing.  The app does not update this file while you are using the app to avoid multiple file writes, but waits until yourclose the app down.

When you back up you songs, you are recommended to include this persistent database as part of your backup.  You can also export, backup, restore and clean up this database using this page.

These database files are in SQLite3 format and are not easy to read or edit outside of OpenSongApp without specialist software.

Persistent database actions

Temporary database action