Pervasive PSQL

From Wikipedia, the free encyclopedia

You have new messages (last change).
Pervasive PSQL
Developer: Pervasive Software
Latest release: v9 (9.1) / 2005
OS: Cross-platform
Use: RDBMS
Website: www.pervasive.com

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, PSQL provides both relational and transactional access to data. PSQL is available on Linux, Novell NetWare and Microsoft Windows platforms. PSQL 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.

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

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

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

Pervasive PSQL 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.

Contents

[edit] 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.

[edit] 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

[edit] 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 9.x after upgrading to PSQL.

[edit] 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.

[edit] Embeddability

Pervasive PSQL v9 can be embedded into applications.

[edit] 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™ effectively backs up operating databases.

[edit] 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
Retrieved from "http://en.wikipedia.org../../../p/e/r/Pervasive_PSQL_ce25.html"
In other languages