Directory:Article Heaven/Pervasive PSQL

<adsense> google_ad_client = 'pub-1200304577225263'; google_ad_width = 468; google_ad_height = 60; google_ad_format = '468x60_as'; google_ad_type = 'text_image';//2006-12-28: MWB Directory space google_ad_channel = '2388332058'; google_color_border = '6699CC'; google_color_bg = '003366'; google_color_link = 'FFFFFF'; google_color_text = 'AECCEB'; google_color_url = 'AECCEB'; </adsense>

Template:Ntnes Pervasive PSQL is Pervasive Software's relational database (RDBMS) product. Designed for embedded database installations where the DBMS is distributed as part of an application software package, PPSQL provides both relational and transactional access to data. PPSQL is available on Linux, Novell NetWare and Microsoft Windows platforms. PPSQL is available in two editions: Workgroup and Server. The workgroup edition provides database services for single users and small networks up to five concurrent users. The server edition supports six or more concurrent users.

PPSQL supports SQL and offers developers the ability to connect through industry standard APIs such as ADO, ADO.NET, JDBC, ODBC, and OLE DB.

PPSQL is a superset of the original Btrieve data management product. PPSQL supports the entire Btrieve API and is backwards compatible with previous versions of PPSQL and Btrieve.

PPSQL's target clients are Independent Software Vendors (ISV's) building and maintaining applications for small to mid-sized enterprises.

Pervasive PPSQL provides simultaneous access to data through both transactional and relational APIs. This means that developers can use both Btrieve API and SQL from the same application.

Platform support

Pervasive PSQL supports:

Pervasive PSQL allows client operating systems of any kind to use a PSQL server install on any OS. For instance, Windows clients can access a PSQL database running on Linux.

Version 10 improvements

Pervasive PSQL Summit v10 is the latest embeddable RDMS release from Pervasive. Key changes in version 10 include:

a structured query language (SQL) engine
compatibility with Microsoft Vista and 64-bit architectures.
compatibility with a range of hardware, software, applications and operating systems
supports Microsoft’s next server OS, Windows Server 2008 as well as Linux distributions on both 32-bit and 64-bit platforms.

Version 9 improvements

Pervasive has released a new software release which builds upon existing software. Key changes in version 9 include:

Performance optimizations which impact SQL interfaces, resulting in an improvements on TPC C benchmarks and joins
Support for 128GB tables (up from 64GB)
Increased page size for faster database access
New bulk data utility for high performance data import

Backwards compatibility

Pervasive SQL has grown over time from its early roots as the Btrieve database engine, and still maintains support for the Btrieve API. Full file compatibility back to Btrieve 6.15 and read capability for Btrieve 5.x files is included in even up to Version 9 of PSQL. This means that the current version of PSQL is compatible with applications and data created more than ten years ago.

Vendors using Btrieve can achieve significant performance gains by changing file versions from 6.x to 10.x after upgrading to PSQL.

Standards conformance

The PSQL database engine support ADO.NET, ODBC, OLE DB, and JDBC. Version 9 has added support for 20 new SQL syntax parameters and conditions.

Embeddability

Pervasive PSQL v10 is designed to be embedded into applications.

<adsense> google_ad_client = 'pub-1200304577225263'; google_ad_width = 468; google_ad_height = 60; google_ad_format = '468x60_as'; google_ad_type = 'text_image';//2006-12-28: MWB Directory space google_ad_channel = '2388332058'; google_color_border = '6699CC'; google_color_bg = '003366'; google_color_link = 'FFFFFF'; google_color_text = 'AECCEB'; google_color_url = 'AECCEB'; </adsense>

Companion applications

Pervasive software sells, at extra cost, the following utilities to extend the capabilities of the PSQL engine.

Pervasive AuditMaster monitors and reports on all PSQL database activity.
Pervasive DataExchange allows real-time replication between databases.
Pervasive Backup Agent allows back up of operating databases by third-party back up systems such as Symantec Backup Exec.

Version History

Pervasive PSQL v9 (2005)
Pervasive.SQL V8 (2002)
Pervasive.SQL 2000i (7.94) (2001)
Pervasive.SQL 2000 (7.1) (1999)
Pervasive.SQL 7.0 (1998)
Scalable SQL 4.0 (1997) used in conjunction with Btrieve 6.15
Scalable SQL 3.0 (1994) used in conjunction with Btrieve 6.15