SQLite is a relational database engine that "is the most used database engine in the world." SQLite is in the
public domain but CSPro uses the
SQLite Encryption Extension (SEE), an add-on that allows CSPro to interact with encrypted databases. CSPro uses SQLite for a variety of reasons, including:
Because SQLite is such a popular format, there are many free viewers for SQLite that allow you to access unencrypted databases outside of CSPro.
Within CSPro, there are several ways to interact with SQLite databases:
- Perform a variety of operations on SQLite databases using the actions in the Sqlite namespace, part of the Action Invoker.
- Execute a SQL query using the CSPro logic functions sqlquery and paradata.
- Run SQL queries on paradata logs using the Paradata Viewer.
When working with an encrypted SQLite database in CSPro, the database is opened using "AES-256 in OFB mode." In instances when a password is used to open the database, the specified password is not used as the key input to SEE but is instead
hashed to create a 256-byte key that is used to encrypt the file. A fixed salt is used for Encrypted CSPro DB data sources, but in other instances a random salt may be used.