Database Files Management

DBCompass for SQLite has 2 mode to manage files: - Local: database files are within the app on the device and manually decide when upload and download a copy to iCloud; - iCloud: direct access to the iCloud app special folder called SQLite Mobile without the worry of synchronization which occurs automatically.

MS Access files import

This application does not import or modify directly database in MS Access file format. It is however possible to import/copy MS Access database tables into an SQLite database. This feature is available after opening the database alongside other imports file types (CSV, NDJson and SQLite).

Local

In the Local section, database files have this blue database icon that prefix the name.

Right side icons Description
The database is present in iCloud and has not difference with the local version
The iCloud database is newer than local version
The local database is newer than iCloud version

Plus Menu (+) - Local

New SQLite database

This action allows to create a new empty SQLite database. A name is required and it will appear on the Local section.

Import SQLite database (from Files)

This action allows to import a copy of a database file into the Local section from any of the Files sources.

Import iCloud database

This action allows to import one or more database files from the iCloud section of SQLite App. A blue cloud icon will appear next to the database files imported.

Database file context menu

Export

This action allows to export/share the database file using the system share panel.

Update from iCloud

This action download a more updated version of the database file from iCloud.

Save to iCloud

This action allows to copy the database file to the iCloud section of SQLite App.
After this action, a blue cloud icon will appear next to the database name.

iCloud

In the iCloud section, database files have this blue cloud icon that prefix the name.

Right side icons Description
The iCloud file is offloaded
The iCloud file is not uploaded to the iCloud server
The iCloud file is being uploaded to the iCloud server

Plus Menu (+) - iCloud

New SQLite database

This action allows to create a new empty SQLite database. A name is required and it will appear on the iCloud section.

Import SQLite database (from Files)

This action allows to import a copy of a database file into the iCloud folder SQLite Mobile from any of the Files sources.

Synchronization and conflicts

Upload to iCloud are performed after the database is correctly closed.

Conflicts

If a new version of the database file becomes available after you have opened and modified it, a conflict arises that must be resolved manually, choosing which file to keep (a merge operation is not possible) or creating a copy and keeping both.