O&K Print Watch supports multiple database systems: Microsoft SQL Server, SQLite, and PostgreSQL. This allows you to configure the system flexibly depending on the size of your organization and the volume of stored print data.
O&K Print Watch works with the following Microsoft SQL Server options:
The installer can automatically install LocalDB or Express Edition if needed, and it also automatically creates and initializes the database during installation.
Limitation:
LocalDB and Express editions are limited to 10 GB database size. For storing large volumes of data, use the full SQL Server edition or enable automatic cleanup of old records.
SQLite is the default built-in database used during installation. The database is created and configured automatically during setup. This option is recommended for small installations, pilot deployments, and testing purposes.
Starting from version 4.16.0.5037, O&K Print Watch supports PostgreSQL, a reliable, scalable, and cross-platform open-source database system.
Important:
Unlike MS SQL and SQLite, PostgreSQL requires manual creation of the database and user before installing O&K Print Watch. After setup, you can specify the connection parameters in the program settings.
Using PostgreSQL as a database server in O&K Print Watch.
Go to the menu: Settings → Database
Provider=SQLOLEDB;User ID=prnwatch;Data Source=PRNSRV\PRNWATCH;Password=123456;Initial Catalog=PRNWATCH
Host=localhost;Port=5432;Database=prnwatch;User ID=prnwatch;Password=123456
Data Source=C:\ProgramData\O&K Software\O&K Print Watch\prnwatch.db
| Data Volume | Recommended Database |
|---|---|
| Small (up to 100 thousand records) | SQLite |
| Medium (up to 1 million records) | PostgreSQL, MS SQL Express |
| Large (more than 1 million records) | PostgreSQL, Full MS SQL Server |