PreviousGetting Started with Pervasive PSQL v9 SP2 (9.5) (Server Edition) (v9 SP2 (9.5) revision 1) Next

About the Server Engine

Chapter contents

This section provides some basic information about the Pervasive PSQL Server engine. For a detailed discussion of Pervasive PSQL architecture, please refer to Pervasive Products and Services.

If you would like more information about what comes in your product and what gets installed, please see Chapter 2, Preparing to Install Pervasive PSQL.

Purpose

You have purchased the Pervasive PSQL Server engine. This database engine is designed to support up to many hundreds of concurrent network users when installed on the appropriate hardware. It is capable of supporting web, corporate, departmental, and other client/server or web-based applications where reliability and performance are critical.

Where to Install

The Server engine must be installed on the same computer where the database files are located. The client portion of the software must be installed on every computer that is expected to access the database. In the case of web applications, the client must be installed on the same computer as the web server. Multiple web server platforms require a client on each platform.

Additional User Licenses

If you receive Status Code 161 or other status codes indicating you have exceeded your licensed user count, you may wish to buy additional user licenses. You can purchase additional licenses in blocks of 10, 20, 50, 100, or more. You may purchase user count upgrades from your application reseller or directly from Pervasive.

Features

All Pervasive database engines offer the same powerful feature set and full-functioned support for programming interfaces. All engine editions are plug-and-play compatible, requiring no application changes to switch from one engine to another. Data files are binary-compatible across all supported platforms.

The chart below shows the major differences between the two different editions of the product.

Table 1-1 Comparison of Server and Workgroup Features
Feature
Server
Workgroup
Supports Btrieve, ODBC, OLE DB, and ActiveX interfaces

Full-featured relational support (online backup, security, referential integrity, management tools, and so on)

Binary compatible data files across all platforms and engine editions

Easy plug-and-play upgrading, no application changes required

Includes complete online documentation

Can access data on a file server where no database engine is installed
 

Supports remote ODBC client connections

Requires a Workgroup engine on all computers expected to access remote data
N/A

Engine runs on Windows

Engine runs on NetWare

 
Engine runs on Linux

 
Multi-user for small groups

Scales to hundreds of users

 
Extranet license available

 


Chapter contents
Book contents

Prev topic: About Pervasive PSQL
Next topic: Preparing to Install Pervasive PSQL