SQLite

Remote Desktop Manager's SQLite data source is ideal for single user and stand-alone situations. More powerful and more flexible than the XML file format, it also supports a few of the Advanced Data Source options like Logs and Attachments.

Highlights

  • Full connection log and attachments support.

Key points to consider:

  • All passwords are encrypted by default by Remote Desktop Manager. You can specify a custom password to fully encrypt the content of the SQLite database.

  • Password recovery is not possible, the data will be unrecoverable if you cannot authenticate. Please ensure you backup the password in a safe place.

  • SQLite supports an unlimited number of simultaneous readers, but will only allow one writer at any instant in time. For this reason Remote Desktop Manager does not support sharing a SQLite data source between several users by storing it on a network drive. If you want to share your data and work in a team environment with your colleagues, please use one of the advanced data sources. Please consult SQLite.org for more information.

Master key management

You can specify a master key to further encrypt your data. Specify it at creation time. If the data source already exists, you can modify the master key in File – Manage master key.

Settings

General

SQLite - General Tab
SQLite - General Tab
OPTION DESCRIPTION
Name Name of the data source.
Database Indicate the filename of the SQLite database (.db).
Set master key Add an additional layer of security by encrypting your data source with a master key.
Always ask master key Always prompts for the master key when connecting to the data source.
Multifactor Enable multifactor authentication to access your data source.
Test Connection Test the current database path and password for connection.

Backup

SQLite - Backup tab
SQLite - Backup tab
OPTIONDESCRIPTION
BackupSelect between:
  • None: No backup of your data source will be created.

  • File backup: Your backup will be saved to a chosen file.

Folder

Select the folder in which you want the backup to be saved.

Filename

Specify the backup name.

Master key

Encrypt your backup with a master key.

Switch to the Triggers tab to define when the backups should occur.

Triggers tab
Triggers tab
OPTIONDESCRIPTION
On entry modificationCreate a backup each time you edit an entry in the data source.

Before switching data source

Backs up automatically when you switch from one data source to another.

On application close

Create a backup whenever you close Remote Desktop Manager.

Backup interval

Schedule backups at a regular time interval (for example, every 10 minutes).

VPN

Open a VPN to access your data prior to connecting to your SQLite.SQLite - VPN Tab

OPTIONDESCRIPTION

Type

Determine when the VPN should be launched.

RDM File

Specify the path to a VPN configuration file.

Override credentials

Set custom credentials that will be used for the VPN connection.

Advanced

SQLite - Advanced Tab
SQLite - Advanced Tab
OPTION DESCRIPTION
Auto refresh Set the interval for the automatic refresh.
Disable reveal password Disable the reveal password feature when a user accesses this data source.
Disable caching Entries will be reloaded in Simple mode in the data source. See Caching for more information.
Command timeout Waiting time before a command timeout.
Manage file Contain multiple SQLite commands to facilitate managing. You should usually only access these when our customer support teams demands it.
More settings Use to directly modify the connection string value.

Connection

SQLite - Connection tab
SQLite - Connection tab
OPTION DESCRIPTION
Name Name of the data source.
Database Indicates the filename of the SQLite database (.db).
Password Specify a password to further encrypt your data source.
Secure with password Secure the data source with a password. This is used to encrypt the database content and it cannot be recovered if lost.
Always ask password Always ask for the password when connecting to the data source.
Two Factor Enable the 2-Factor Authentication to access your data source.

Backup

SQLite - Backup tab
SQLite - Backup tab
OPTIONDESCRIPTION
BackupSelect between:
  • None: No backup of your data source will be created.

  • Save to file: Your backup will be saved to a chosen file but will not automatically do backup every 30 seconds.

Backup nameSpecify the backup name that will allow you to automatically save your sessions in a safe online storage space and restore them in the event of problems.

Advanced

SQLite - Advanced tab
SQLite - Advanced tab
OPTION DESCRIPTION
Auto refresh Set the interval for the automatic refresh.
Command timeout Waiting time before a command timeout.
Disable reveal password Disable the reveal password feature when a user access this data source.
Disable caching Entries will be reload in Simple mode in the data source. See Caching Mode for more information.
Advanced Settings Use to directly modify the connection string value.

Maintenance

SQLite - Maintenance tab
SQLite - Maintenance tab
OPTION DESCRIPTION
Manage SQLite File Manage all your SQLite file to analyse, vacuum, repair or delete them.
Vacuum Used to compress and clean up the current database file.
Devolutions Forum logo Give us Feedback