ISVs who build and maintain mission-critical applications for small to mid-sized enterprises need performance, reliability, and database features that minimize support requirements. And, they need an easy migration path to new OS and hardware platforms.

Pervasive PSQL simplifies development and deployment, and minimizes the adoption challenges of new technologies including Windows Vista, Windows Server 2008, 64-bit computing and multi-core processing.

Pervasive PSQL Summit v10 is the perfect database for small and midsized businesses. It's been refined with over 25 years of focus on the issues that are key to the SMB: delivering consistently superb application performance, long term reliable operation without requiring a database administrator, self tuning and self optimizing, simple, fast (and sometimes completely invisible) installation, easy upgrades and years of backward compatibility.

Cross platform support enables development and deployment on multiple platforms, including 32-bit and 64-bit Windows, Linux, and NetWare.

• Binary compatibility among different platforms allows you to freely move your database from one OS to another.
• A common API for all engine platforms provides your application a single code base and enables you to port it without rewriting any code.
• Multiple platform deployment capability allows you to write your application once, and then deploy it anywhere.

Compare versions of Pervasive PSQL.
Maintenance-free operations guarantee that you will focus on meeting your business objectives rather than on downtime and rework.

• Dynamic cache operations, instantaneous file allocations, and index balancing, ensuring optimal performance without manual intervention.
• Auto-Reconnect technology avoids minor networking issues by seamlessly reconnecting workstations to a server engine in case of a network error.
• Archival and transaction logging, eliminating typical time-consuming tracking tasks.
• Server/Requester version independence dramatically simplifies your deployment.
• Pervasive System Analyzer eliminates deployment issues related to component management.
• Cross-platform dynamic parameters eliminate the need to remaster the database environment from platform to platform.
• Support for backward compatibility to your legacy applications and databases.

Pervasive PSQL can scale from the desktop to high-performance servers capable of supporting high-volume environments.

• Migration from workstation to workgroup client/server without application code changes.
• Data safety and recovery features guarantee that your critical data is always available.
• Continuous operations mean you can back up files while they are in use by an application.
• Complete transaction processing and recovery enables the user to easily recover changes made to a data file between the time of the last backup and a system failure.
• Transaction durability guarantees the integrity of your database.
• High performance Btrieve transactional API delivers fast access to your data.

An integrated application development environment provides you with the right tools to meet the demands of today's fast-changing technology environment.

• Support for widely used development environments, such as .NET 2.0, Visual Basic, Visual C++, Delphi, and Java.
• WYSIWYG development tools and complete SDK.
• Pervasive PSQL's flexible architecture provides you with the performance of transactional data access and the flexibility of relational access through a SQL engine delivering high-speed access to your data across all relational data access methods (ODBC, JDBC, OLE DB, etc.).
• ActiveX controls.
• Pure Java interface.
• Full Installation Toolkit – Allows transparent deployment of the database engine as part of the business application.
• DevTalk - Pervasive's Developer Forum
• Pervasive PSQL Knowledge Base

• AuditMaster - Compliancy and auditing. Know who's doing what to your data when, where and how
• Backup Agent - Works with third-party software to ensure accurate, reliable point-in-time recovery for partial or complete backups.
• DataExchange - Real-time backup and multi-database synchronization. Keep your data secure and organized across all PSQL databases.

The Pervasive PSQL v10 Server edition is the ideal choice for your high-volume user and transaction environments. Summit runs out-of-the-box as a Windows Vista application, including support for 64-bit Windows platforms running on Intel and AMD 64-bit processors. PSQL v10 is also available on 32 and 64-bit Windows XP, 2000, and 2003. Both PSQL Server and Client are available in 32-bit and 64-bit versions. Pervasive PSQL v10 Server for Windows delivers high-performance, low-maintenance solutions to the Windows platform. Fully integrated, Pervasive PSQL v10 allows for seamless integration into your Windows environment, and it provides graphical utilities for server management as well as a full suite of graphical server console management utilities. The Pervasive PSQL Server engine may be installed with license blocks for 6, 10, 20, 50, 100, 250, 500 or an unlimited number of users. The server engine is capable of scaling to hundreds of concurrent users with the purchase of additional licenses. Upgrading to another configuration requires no changes to the supported application, just plug and play with the new database engine. Version upgrades are simple too. Pervasive PSQL Summit v10 is file compatible with Btrieve 6.15, V7, V8, and v9.

The Pervasive PSQL v10 Workgroup Edition delivers full-featured, high-performance database power at the desktop, on the road, or in your workgroup. The Workgroup Edition is designed to deliver multi-user client/server performance, dependability, reliability, and data integrity in environments with no network server, or where practical reasons dictate an alternative to server-based database engines.

Based on PSQL Server architecture, the Workgroup delivers centralized multi-user concurrency and locking management to data access regardless of where the database resides in your business. These robust features are delivered via a file management scheme that controls and directs all database access through a single point, much like traditional client/server technology.

By providing all the features and benefits of the Pervasive high-performance, low-maintenance client/server database technology, the Workgroup prevents the need to compromise on quality or performance when choosing a solution to support your application. With application compatibility between Workgroup and Server editions, Pervasive PSQL lets you scale your deployments from a single user to client/server without application modifications or data file manipulation. This reduces costs and saves time by allowing the same application to run in several environments. Of course, the Workgroup engine still provides full compatibility with all existing Btrieve-based applications on supported platforms. As a result, you can take advantage of the features and increased speed that Pervasive PSQL v10 offers without changing your application.

Workgroup is available in single user, three or five concurrent user configurations. With Pervasive PSQL v10 Workgroup, you can share data across the business without compromising on performance, dependability, reliability or data integrity.

The following matrix is a summary of compatibility information between releases of Pervasive PSQL and Pervasive's Security Solutions Products.

Pervasive Database Version	Compatible Product	Available
Pervasive PSQL v9	Backup Agent 1.1	Yes
Pervasive PSQL v10	Backup Agent 1.2	per Patch
Pervasive PSQL v9	DataExchange 2.8	Yes
Pervasive PSQL v10	DataExchange 2.9	per Patch
Pervasive PSQL v9	AuditMaster 6.3	Yes
Pervasive PSQL v10	AuditMaster 6.4	per Patch

Windows (All products) Refer to the Control Panel Settings for Add or Remove Programs

Linux (Backup Agent only) If you installed using RPM format, type "rpm qa" at the command line prompt to get a list of installed applications. Otherwise type "pvbackup" to get the version number

If you have an installed version of PSQL v9 compatible Backup Agent, DataExchange, or AuditMaster, upgrades to the new versions are free of charge.

View the Pervasive PSQL v10 Readme to learn more.

The following tables list the system requirements for each supported version of PSQL products. Requirements are divided into two categories: Environment (Operating System) and Hardware (CPU, Memory, Disk, etc). Only products that are supported by Pervasive Software are listed. The following chart outlines the supported operating systems for the PSQL database products.

Operating System	Edition	Pervasive Product
		Server v9 | v10	Workgroup v9 | v10	Client v9 | v10
Windows Vista	Enterprise 32-bit Edition
	Enterprise 64-bit Edition
	Ultimate 32-bit Edition
	Ultimate 64-bit Edition
	Business 32-bit Edition
	Business 64-bit Edition
	Home Premium 32-bit Edition
	Home Premium 64-bit Edition
	Home Basic 32-bit Edition
	Home Basic 64-bit Edition
Windows 2003	Windows Server R2 64-bit
	Windows Server R2
	Windows Server and Small Business Server
	Windows Server R2 with Failover Cluster
	Windows Small Business Server R2
	Windows Server R2 Terminal Services
	Windows Server (SP1) 64-bit
	Windows Server and Small Business Server (SP1)
	Windows Server and Small Business Server (SP1) with Failover Cluster
	Windows Server (SP1) Terminal Services
Windows 2000	Windows Server, Advanced Server and Terminal Services (SP4)
	Windows Server (SP4) with Failover Cluster
Windows XP	Professional (SP2) 64-bit
	Professional and Home Edition (SP2)
	Window XP Embedded (SP1), and Embedded for Point of Service

Operating System	Edition	Pervasive Product
		Server v9 | v10	Workgroup v9 | v10	Client v9 | v10
Citrix	Presentation Server 4.0 (32-bit and 64-bit)
	Presentation Server 4.5 (32-bit and 64-bit)

The following chart outlines the supported hardware requirements for the PSQL database products.

Product	Operating System	Minimum CPU Speed	Memory Requirement	Disk Space Requirement
Server v10	Windows 64-bit	Athlon64, Opteron, Xeon or other Intel EM64T	2 GB	500 MB
Workgroup v10			1 GB	500 MB
Client v10
Server v10	Windows 32-bit	Pentium 4 1.1 GHz CPU
Workgroup v10	Windows 32-bit	Pentium III 500 MHz CPU	256 MB	500 MB
Client v10
Server v9	Windows 64-bit	Athlon64, Opteron, Xeon or other Intel EM64T	2 GB	500 MB
Workgroup v9			512 MB	500 MB
Client v9
Server v9	Windows 32-bit	Intel 486 or higher
Workgroup v9	Windows 32-bit	Intel 486 or higher	128 MB	500 MB
Client v9

The following chart outlines the requirements needed to install and configure the Xtreme I/O (XIO) driver in Pervasive PSQL v10. If your system meets the minumum system requirements listed below, the Xtreme I/O system driver is installed by default.

• AMD Athlon 64
• AMD Opteron
• Intel Xeon
• Intel Pentium 4 or higher
• Intel EM64T

• Windows 32-bit operating systems
• Windows Vista Business, Ultimate and Enterprise
• Windows 2003 Server
• Windows 2000 Server

• Minimum 2 gigabytes (GB) of RAM
• XIO checks the memory requirement at runtime. If memory is below the 2GB minimum, XIO will not install

• NTFS file partition for the database files that will be accessed
• FAT32 is not supported

Pervasive PSQL includes all the components, controls, and interfaces you need to develop full-featured applications that leverage the power of Pervasive PSQL.

• JDBC and Java Class Libraries for developers working with portable applications.
• ActiveX for rapid application development in Visual Basic.
• ODBC interface connecting you to a variety of third-party development tools.
• OLE DB for tight integration with ADO and Visual Studio.
• Delphi/C++ Builder interface providing a Visual Component library to speed database development.
• PDAC direct access components for the Delphi/C++ Builder environments.
• Btrieve native interface for low-level direct access to the database.
• Distributed Tuning Interface (DTI). When implemented as a 32-bit or 64-bit DLL,  DTI provides the developer with an API level integration with the Pervasive PSQL database engine indcluding:
  • Connection - Start and stop Pervasive PSQL services on remote servers.
  • Configuration - Access to database engine settings.
  • Monitoring - Returns engine statistics and resource usage, such as the files open on a server or the clients currently connected to it.
  • Cataloging - Manage database schema and dictionary information, such as database names, table names and properties, as well as drop and create tables and dictionaries.
• Code samples, snippets and tutorials have been updated to illustrate the functionality and flexibility of all interfaces and components to help you start producing full-featured applications quickly and efficiently.