The Capture-it software uses Pervasive PSQL® to store its data.
Pervasive® is an
ACID compliant Database Management System that supports Client-Server and Software-as-a-Service architecture.
Why do we use this Database?
Pervasive® is an evolution of the Btrieve® database and has a long lineage going back to Windows® 3.1. The basic architecture has undergone small incremental improvements since then; the current version being number 12.
Low Administration Overhead
Once Capture-it is installed there is virtually no administration to be carried out with the Pervasive® database.
The database occupies a small footprint and automatically grows to accommodate your data.
You can even back up the database using a file copy whilst Capture-it is running! All this reduces the Total Cost of Ownership (TCO) and allows you to spend your time running your business instead of handling your IT.
The speed of Pervasive® is hard to beat; even when compared to enterprise level databases. This makes it the perfect platform to store our real time Job Costing and Time and Attendance data.
The cost of the database software is included with the Capture-it software as a one-off amount. There are no additional client licenses to buy.
3rd Party Connectivity
Pervasive® has a variety of methods to allow you to connect to it from ADO.NET, OLE DB, ODBC and ActiveX. This allows ad-hoc reporting directly into Microsoft® Excel®