Buy

O&K Print Watch – Database

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.

Supported Database Systems

1. Microsoft SQL Server

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.

2. SQLite

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.

3. PostgreSQL

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.

Database Connection Configuration

Go to the menu: Settings → Database

Example Connection Strings

MS SQL Server

Provider=SQLOLEDB;User ID=prnwatch;Data Source=PRNSRV\PRNWATCH;Password=123456;Initial Catalog=PRNWATCH

PostgreSQL

Host=localhost;Port=5432;Database=prnwatch;User ID=prnwatch;Password=123456

SQLite

Data Source=C:\ProgramData\O&K Software\O&K Print Watch\prnwatch.db

Recommended Database by Data Volume

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