SQLite: connection manager

Operating procedure

The connection manager allows you to set up persistent connections to SQLite databases for later use in the query editor

Database list

List of previously saved SQLite database connections.

The indicator displays the availability of the database (physical access to the file)

Create a new connection

Attach as - alias under which the database will be connected
Database file - path to the SQLite database file.

If the database is encrypted,

Mode - encryption protocol
Database password - database password

The program implements the ability to backup SQLite databases from the program interface after connecting it to the sheet, to use the functionality, fill in the fields:

Specify the path to the backup file in the "Backup file" field

If you need to encrypt a backup:

Mode (bkp) - encryption mode
Database password (bkp) - password
Save the connection by clicking the "Save" button

Attach datadase SQLite

Manager for connecting saved databases to the current sheet.

By default, there are 4 program databases in the list

ASH - storage of information on the activity of sessions in the database, the work of which is monitored by the main core of the program
CONNECT - storage, for tables with connection data with different DBMS, the work with which the program supports
CORE - the main base of the program
EXIST - a database that stores information on monitoring the operation of databases through the mechanism for monitoring the operation of the "Cloud"

You can connect to any number of bases at the same time

Check the boxes next to the required bases
Press the " Attach " button