Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v15
+ Actian Zen v14
+ Actian Zen/PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 12
+ Btrieve 6.15
+ Actian Vector

+ Protecting Your Data

+ Goldstar Services

+ Goldstar Tools

+ Developer Resources

+ Other Solutions

Using AMS? Status 7224 Fix My PSQL License Report Engine Crash Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

Product Version Quick-Reference Chart

The Actian Zen (formerly Pervasive PSQL) product has seen much change and growth over its 40-year lifespan. The charts on this page were created to help you visualize the major differences between each of the product releases over time.

The first chart provides a list of the major features available and which version first included that feature. The second chart shows the supported operating systems in each release. The third chart shows you which development API's are supported within each release. Finally, the last chart shows you the major release and support dates for each version.

Major Features by Actian Zen/PSQL Product Versions

Database Engine Featurev5v6v7v8v9v10v11v12v13v14v15
Maximum Data File Size Supported4GB4GB64GB64GB256GB256GB256GB256GB64TB64TB64TB
Compatibility with Older Versions: Highly-reliable data migration and backward-compatibilityYesYesYesYesYesYesYesYesYesYesYes
Ability to Write to Btrieve 5.x files or Older: Newer engines require rebuilding old files to enable writing to them.YesYesYesYesNoNoNoNoNoNoNo
Btrieve API Available: High-speed, navigational database engine supports ultra-fast data access with maximum flexibilityYesYesYesYesYesYesYesYesYesYesYes
SPX Network Support: Supports NetWare network stackYesYesYesYesYesYesYesYesNoNoNo
ODBC Drivers Included: Supports ad hoc queries and reporting from any ODBC applicationNoYes1YesYesYesYesYesYesYesYesYes
TCP/IP Network Support: Supports IPv4 network stackNoNoYesYesYesYesYesYesYesYesYes
NetBIOS Network Support: Supports Microsoft Workgroup CommunicationsNoNoYesYesYesYesYesYesNoNoNo
Turbo Write Accelerator: New disk algorithm improves write performance on V8+ filesNoNoNoYesYesYesYesYesYesYesYes
New SQL Functions: SQL functions like TOP, ROWCOUNT, TIME_ZONE, and more have been addedNoNoNoYesYesYesYesYesYesYesYes
Debug Requesters Installed: Assists developers with debugging applications in pre-installed environmentsNoNoNoYesYesYesYesYesYesYesYes
Page Compression: Saves disk space and can improve performanceNoNoNoNoYesYesYesYesYesYesYes
Linux Support: Eliminates dependence on Microsoft operating systemsNoNoNoNoYesYesYesYesYesYesYes
Improved SQL Performance: SQL engine has been tuned and improved considerably over older versionsNoNoNoNoYesYesYesYesYesYesYes
Improved COBOL Support: OCCURS and REDFINES functionality is now supported inside the data dictionary and SQLNoNoNoNoYesYesYesYesYesYesYes
64-bit Microkernel Engine: Better performance and scalability through larger cache sizesNoNoNoNoNoYesYesYesYesYesYes
Long Owner Names 1: Improved security with owner names up to 20 bytes in length and better encryptionNoNoNoNoNoYesYesYesYesYes2Yes2
Multi-Core Support: Improved performance and scalability on multi-core hardwareNoNoNoNoNoNoYesYesYesYesYes
64-bit SQL Engine: Better performance and scalability due to having more memory availableNoNoNoNoNoNoYesYesYesYesYes
Performance Monitor Counters: Adds the ability to monitor engine health and performance from PerfMonNoNoNoNoNoNoYesYesYesYesYes
IPv6 Network Support: Adds support for native IPv6 networksNoNoNoNoNoNoYesYesYesYesYes
Telephone Activation Added: Allows activation of licenses where Internet access is unavailableNoNoNoNoNoNoYesYesYesYesYes
ORDER BY Allowed in Subquery: Improves SQL engine capabilities with TOP clauseNoNoNoNoNoNoYesYesYesYesYes
Backup Agent Included2: Supports simplified backups with users in the system through ContOps ModeNoNoNoNoNoNoYesYesYesYesYes
VSS Writer Included: VSS Writer supports full backups with users in the system (Server Engines only)NoNoNoNoNoNoYesYesYesYesYes
SaaS Licensing Available: Hosted applications and Software-as-a-Service installations are supportedNoNoNoNoNoNoYesYesYesYesYes
Online Database Defragmenter: Optimize storage and performance of data files with system runningNoNoNoNoNoNoNoYesYesYesYes
VM Live Migration Support: More flexible licensing model allows for easier server managementNoNoNoNoNoNoNoYesYesYesYes
SQL Unicode Support: Support for NCHAR, NVARCHAR data types and new UNICODE ODBC driversNoNoNoNoNoNoNoYesYesYesYes
Simplified Installation: Installs all components for the OS -- no more split 32-bit or 64-bit installersNoNoNoNoNoNoNoYesYesYesYes
Simplified Licensing: License is based on machine name only, not the hardware fingerprintNoNoNoNoNoNoNoYesYesYesYes
Standalone Server License Available: Allows full 64-bit engine performance on single-user system at a lower costNoNoNoNoNoNoNoYesYesYesYes
CVE-2017-11757 Vulnerability Resolved: This security vulnerability has been addressed.NoNoNoNoNoNoNoYesYesYesYes
Cache Management: Allows you to load data into the database engine cache (or purge it) to improve performanceNoNoNoNoNoNoNoNoYesYesYes
New Btrieve 2 API: Simpler interface for new developers, supporting C/C++, and SWIG access for C#, JavaScript, Perl, PHP, Python, etc.NoNoNoNoNoNoNoNoYesYesYes
Free Reporting Engine Available: Cache engine offloads SQL processing for better SQL performanceNoNoNoNoNoNoNoNoYesYesYes
Edge Server Edition Available: Supports SQL/Btrieve on Edge/IoT Devices (like RaspPi) on ARM and IntelNoNoNoNoNoNoNoNoYesYesYes
New BTRVEX API: Supports larger data buffers, as well as support for tables over 256GB or with more than 4 billion rowsNoNoNoNoNoNoNoNoYesYesYes
LIKE Function Supported in Extended Operations: Allows developers to search for text data more rapidlyNoNoNoNoNoNoNoNoYesYesYes
TRY_CAST and TRY_CONVERT Functions Added: Allows data conversions in SQL to not fail on errorNoNoNoNoNoNoNoNoYesYesYes
UPSERT Capability Added: Allows SQL statements to attempt an INSERT, and if it fails, switch to an UPDATE insteadNoNoNoNoNoNoNoNoYesYesYes
BIGIDENTITY/AUTOINC Support: Supports 8-byte auto-increment values to support more recordsNoNoNoNoNoNoNoNoYesYesYes
Improved Schema Export/Import: Streamlines conversion to v2 metadata or migrating tables to a new databaseNoNoNoNoNoNoNoNoYesYesYes
Active Directory Integration: Offers a simplified security scheme for AD usersNoNoNoNoNoNoNoNoYesYesYes
Core Edition Available: Supports SQL/Btrieve on Android/iOS DevicesNoNoNoNoNoNoNoNoNoYesYes
AUTOTIMESTAMP Data Type: Stores current timestamp on Insert or UpdateNoNoNoNoNoNoNoNoNoYesYes
TIMESTAMP2 Data Type: Provides support for nanosecond precision on timestampsNoNoNoNoNoNoNoNoNoYesYes
AES-256 File Encryption: Provides improved security on disk with known and tested algorithmNoNoNoNoNoNoNoNoNoYesYes
Java Engine Separated: Allows upgrade of Java separately from the Actian componentsNoNoNoNoNoNoNoNoNoYesYes
JSON Filtering in GetNextExtended Calls: Allows search of LONGVARCHAR data for JSON-formatted dataNoNoNoNoNoNoNoNoNoYesYes
New DeleteExtended Capability: Can delete multiple records faster and more efficiently in a single callNoNoNoNoNoNoNoNoNoYesYes
Data Export Utility Included: Allows easy export of data from the command line with built-in toolNoNoNoNoNoNoNoNoNoYesYes
CVE-2022-40756 Vulnerability Resolved: This security vulnerability has been addressed.NoNoNoNoNoNoNoNoNoYesYes
Long Owner Names 2: Improved security with 32-byte owner names and better encryptionNoNoNoNoNoNoNoNoNoYes4Yes4
File Close Delay: Performance gain when files are closed then opened againNoNoNoNoNoNoNoNoNoNoYes
SQL Performance Improvements: SQL engine is faster for DELETE and LIKE/ILIKE OperationsNoNoNoNoNoNoNoNoNoNoYes
Scalar Subquery Optimization: SQL is faster when non-correlated, scalar subqueries are usedNoNoNoNoNoNoNoNoNoNoYes
System Data v2: Stores create and last update time for each record and exposes it from SQLNoNoNoNoNoNoNoNoNoNoYes
SQL Windowing Functions: New functions for OVER(PARTTION...) syntax, as well as EVERYN, LAG, and DATEFLOOR functions for time-series dataNoNoNoNoNoNoNoNoNoNoYes
JSON Output From Tools: Allows scripting environments like Powershell to parse results more easilyNoNoNoNoNoNoNoNoNoNoYes
Configure On Installation: Allows developers to slipstream configuration options at installation timeNoNoNoNoNoNoNoNoNoNoYes
More Detailed Key Statistics: Improves optimization of SQL queries -- requires v15.10 file formatNoNoNoNoNoNoNoNoNoNoYes

1 Only SOME distributions of Btrieve 6.15 included the ODBC drivers. Others did not include it, but it may have been available at an additional cost.

2 Backup Agent is a free component on Server Engines only. It can be installed onto the Workgroup Engine, but a license must be purchased at additional cost.

3 Files with Long Owner Name 1 can be read on these versions, but these engines cannot create files with this long owner name format.

4 Files with Long Owner Name 2 (whether they be 20-byte or 32-byte names) can be read on Zen v14 or higher ONLY. If you copy these files back to v13 or older, they will be unreadable.

Supported Operating Systems by Actian Zen/PSQL Product Versions

Sometimes you need to run with older or newer operating systems, so here is a chart showing the supported database versions for each OS.

Operating Systems Supportedv5v6v7v8v9v10v11v12v13v14v15
DOS (Including Client) YesYesYesYesYesNoNoNoNoNoNo
Novell NetWare YesYesYesYesYesNoNoNoNoNoNo
IBM OS/2 YesYesYesNoNoNoNoNoNoNoNo
Linux (Various Distros) NoNoNoYesYesYesYesYesYesYesYes
Mac OS X NoNoNoNoNoNoNo10.9
Raspbian/Raspberry Pi OS NoNoNoNoNoNoNoNoYesYesYes
Windows IoT Core Intel/ARM NoNoNoNoNoNoNoNoYesYesYes
Android (Zen Core Library) NoNoNoNoNoNoNoNoYesYesYes
iOS (Zen Core Library) NoNoNoNoNoNoNoNoYesYesYes
Windows 3.1x YesYesYesNoNoNoNoNoNoNoNo
Windows 95 YesYesYesNoNoNoNoNoNoNoNo
Windows 98/Me YesYesYesYesYesNoNoNoNoNoNo
Windows NT Workstation 3.5x NoYesYesNoNoNoNoNoNoNoNo
Windows NT Workstation 4 NoYesYesYesYesNoNoNoNoNoNo
Windows 2000 Workstation NoYesYesYesYesYesNoNoNoNoNo
Windows XP NoYesYesYesYesYesYesNoNoNoNo
Windows Vista NoNoNoNoNoYesYesYesNoNoNo
Windows 7 NoNoNoNoNoYesYesYesYesYesNo
Windows 8.1 NoNoNoNoNoNoYesYesYesYesYes
Windows 10 NoNoNoNoNoNoNoYesYesYesYes
Windows 10 IoT Enterprise NoNoNoNoNoNoNoNoNoNoYes
Windows 11 NoNoNoNoNoNoNoNoNoNoYes
Windows NT Server 4 NoYesYesYesYesNoNoNoNoNoYes
Windows 2000 Server NoYesYesYesYesYesNoNoNoNoNo
Windows Server 2003/SBS NoYesYesYesYesYesYesNoNoNoNo
Windows Server 2008/SBS/R2 NoNoNoNoNoYesYesYesYesYesNo
Windows Server 2012/SBS2011 NoNoNoNoNoNoYesYesYesYesYes
Windows Server 2016 NoNoNoNoNoNoNoNoYesYesYes
Windows Server 2019 NoNoNoNoNoNoNoNoYesYesYes
Windows Server 2022 NoNoNoNoNoNoNoNoNoNoYes

Developer API's Available by Actian Zen/PSQL Product Versions

The developer API's are accessible from a variety of programming environments and languages, including Assembler, BASIC, C, C++, C#, Pascal, Delphi, Fortran, Several COBOL variants, and many more. If you are programming with a specific API, though, then you may need to know which versions suport that API.

Developer APIs Supportedv5v6v7v8v9v10v11v12v13v14v15
ActiveX NoYesYesYesYesYesYesYesYesYesNo2
ADO.NET NoNoNoNoYesYes3.2
Btrieve 16-bit YesYesYesYesYesNo1No1No1No1No1No1
Btrieve 32-bit NoYesYesYesYesYesYesYesYesYesYes
Btrieve 64-bit NoNoNoNoNoYesYesYesYesYesYes
Btrieve 2 API NoNoNoNoNoNoNoNoYesYesYes
Distributed Tuning InterfaceNoNoNoYesYesYesYesYesYesYesYes
Distributed Tuning Objects NoNoNoYesYesYesYesYesYesYesYes
JCL NoNoNoYesYesYesYesYesYesYesYes
JDBC NoNoNoYesYesYesYesYesYesYesYes
JDBC 4.0 Driver NoNoNoNoNoNoNoNoYesYesYes
NetWare/Scalable SQL YesYesYesNoNoNoNoNoNoNoNo
ODBC 16-bit NoYesYesYesYesNoNoNoNoNoNo
ODBC 32-bit NoYesYesYesYesYesYesYesYesYesYes
ODBC 64-bit NoNoNoNoNoNoYesYesYesYesYes
OLEDB NoNoNoYesYesYesYesYesYesYesNo2
PDAC (Delphi/RAD Studio) NoNoNoYesYesYesYesYesYesYesYes

1 Btrieve 16-bit applications can be supported on the newer enviroments by copying the 16-bit components from the PSQL v9 Client to the system.

2 Existing applications written with these APIs will still work, but the APIs have been deprecated.

Important Dates by Actian Zen/PSQL Product Versions

And finally, flipping the chart sideways, we can show the release dates, End of General Availability, and End of Support Dates for each version.

Engine VersionFirst Customer
Ship (Release)
General Availability Ends
(Actian stops selling)
Transition Support
(No new patches)
Support Ends
(End of Life)
Btrieve 6 1995July 1999September 1999September 1999
Pervasive.SQL 7 January 1998January 2002January 2002January 2002
Pervasive.SQL 2000 September 1999January 2003July 2004July 2004
Pervasive.SQL V8 November 2002July 2006December 2006December 2006
Pervasive PSQL v9 March 2005July 2009July 2009January 2010
Pervasive PSQL Summit v10 September 2007March 2011September 2011March 2012
Pervasive PSQL v11 September 2010June 2015January 2016July 2016
Actian PSQL v12 December 2014June 2018January 2019July 2019
Actian PSQL v13 June 2017December 2020December 2021December 2022
Actian Zen v14 August 2019December 2022Not ScheduledNot Scheduled
Actian Zen v15 August 2021Not ScheduledNot ScheduledNot Scheduled

Of course, this information is provided simply as a quick-reference chart and should NOT be considered the final word on supported features or platforms, as there are sometimes idiosyncrasies that cannot be easily depicted in this format. For example, some features may only be in specific sub-versions. In short, use this data with caution, and refer back to the official product manuals from Actian for the final word on support.

Still confused? Give us a call and we'll help you work through this!

  Copyright © 1997-2023, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 1945 Maplewood Ln | Munster IN 46321 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us