The CSPro DB data source
allows reading and writing data to a SQLite database
. This data source, introduced in CSPro 7.0, is the default data source for collecting data, and is the most used CSPro data source, followed by text files
. Unless there is a requirement that your data be in text format, you are encouraged to use the CSPro DB data source, as it has the most functionality of all data sources.
The structure of the SQLite database
is based on the dictionary. Each record in the dictionary corresponds to a table in the database. The database tables have the same name as the record in the dictionary. Each item in the record corresponds to a column in the table with the same name as the dictionary item. Because the CSPro DB data source is a SQLite database, it is possible to query the data
using SQL statements.
The CSPro DB data source is used when a file has the extension .csdb
. An encrypted version of this data source, Encrypted CSPro DB
, is used if a file has the extension .csdbe
The CSPro DB data source supports the following features:
|Notes, case labels, and case statuses
|Storage of more than one kind of record
|Binary data items
|Cases with duplicate keys
|Case identification via UUID
|Contains an embedded dictionary
|Allows record sorts
The CSPro DB data source stores binary data
in a binary-data
table. When reading case data, binary data is loaded asynchronously
, read from the SQLite database only when needed by the application.
The following behavior can be customized by specifying properties in the connection string
. The default behavior is marked with ⁺⁺⁺.
|Property Name and Values
|Determines if cases are cached in memory. This may be useful to advanced users who want to optimize programs that do a lot of case lookups.
Cases are cached, meaning that a case is only read from the data source once.
Cases are not cached.