Online Help > Data Sources > Data Sources Types

SQLite Data Source

Description

 

DataSourceSQLiteLarge

Password Vault Manager SQLite data source is ideal for single user 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

The Online Backup Service is available for this data source

 

ShieldInfo48x48

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

 

BadgeWarning48x48

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

 

Information48x48

SQLite supports an unlimited number of simultaneous readers, but will only allow one writer at any instant in time. For this reason Password Vault 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.

 

Password management

 

You can specify a password to further encrypt your data. Specify it at creation time. If the data source already exists you can modify the password by using the File - Manage Password dialog.

 

Change or clear the password of an SQLite data source.

 

Manage Data Source password

Manage Data Source password

 

Settings

 

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

Password used to access the data source.

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

SQLite - Backup

 

Option

Description

Backup

Select between:

None: No data source backup will be created.

Online Backup: An Online Backup (using Online Backup Service) will automatically be created.

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

Backup name

Specify the backup name that will allow you to automatically save your sessions in a safe online storage space and easily restore it if encountering any issues.

 

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 reloaded in Simple mode in the data source.

Advanced Settings

Use to directly modify the connection string value.

 

Maintenance

 

SQLite - Maintenance tab

SQLite - Maintenance tab

 

Option

Description

Manage SQLite File

Allows you to analyze, clean or repair your SQLite file.

Vacuum

Used to compress and clean up the current database file.