Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v16
+ 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+ years of development. The charts on this page were created to help you quickly 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 Featurev5v6v7v8v9v10v11v12v13v14v15v16
Maximum Data File Size Supported4GB4GB64GB64GB256GB256GB256GB256GB64TB64TB64TB64TB
Maximum Key Length Supported (Bytes)25525525525525525525525525525525510246
Maximum Size of SQL Bound Column64K64K64K64K64K64K64K64K64K64K64K2GB
Compatibility with Older Versions: Highly-reliable data migration and backward-compatibilityYesYesYesYesYesYesYesYesYesYesYesYes
Ability to Write to Btrieve 5.x or Older Files: Newer engines require rebuilding old files to enable writing to them.YesYesYesYesNoNoNoNoNoNoNoNo
Ability to Read from Btrieve 5.x or Older Files: Newer engines require rebuilding old files to enable writing to them.YesYesYesYesYesYesYesYesYesYesYesNo
Btrieve API Available: High-speed, navigational database engine supports ultra-fast data access with maximum flexibilityYesYesYesYesYesYesYesYesYesYesYesYes
SPX Network Support: Supports NetWare network stackYesYesYesYesYesYesYesYesNoNoNoNo
ODBC Drivers Included: Supports ad hoc queries and reporting from any ODBC applicationNoYes1YesYesYesYesYesYesYesYesYesYes
TCP/IP Network Support: Supports IPv4 network stackNoNoYesYesYesYesYesYesYesYesYesYes
NetBIOS Network Support: Supports Microsoft Workgroup CommunicationsNoNoYesYesYesYesYesYesNoNoNoNo
Turbo Write Accelerator: New disk algorithm improves write performance on V8+ filesNoNoNoYesYesYesYesYesYesYesYesYes
SQL Functions TOP, ROWCOUNT, TIME_ZONE, etc.NoNoNoYesYesYesYesYesYesYesYesYes
Debug Requesters Installed: Assists developers with debugging applications in pre-installed environmentsNoNoNoYesYesYesYesYesYesYesYesYes
Page Compression: Saves disk space and can improve performanceNoNoNoNoYesYesYesYesYesYesYesYes
Linux Support: Eliminates dependence on Microsoft operating systemsNoNoNoNoYesYesYesYesYesYesYesYes
Improved SQL Performance: SQL engine has been tuned and improved considerably over older versionsNoNoNoNoYesYesYesYesYesYesYesYes
Improved COBOL Support: OCCURS and REDFINES functionality is now supported inside the data dictionary and SQLNoNoNoNoYesYesYesYesYesYesYesYes
64-bit Microkernel Engine: Better performance and scalability through larger cache sizesNoNoNoNoNoYesYesYesYesYesYesYes
Long Owner Names 1: Improved security with owner names up to 20 bytes in length and better encryptionNoNoNoNoNoYesYesYesYesYes2Yes2Yes2
Multi-Core Support: Improved performance and scalability on multi-core hardwareNoNoNoNoNoNoYesYesYesYesYesYes
64-bit SQL Engine: Better performance and scalability due to having more memory availableNoNoNoNoNoNoYesYesYesYesYesYes
Performance Monitor Counters: Adds the ability to monitor engine health and performance from PerfMonNoNoNoNoNoNoYesYesYesYesYesYes
IPv6 Network Support: Adds support for native IPv6 networksNoNoNoNoNoNoYesYesYesYesYesYes
Telephone Activation: Allows activation of licenses where Internet access is unavailableNoNoNoNoNoNoYesYesYesYesYesYes
ORDER BY Allowed in Subquery: Improves SQL engine capabilities with TOP clauseNoNoNoNoNoNoYesYesYesYesYesYes
Backup Agent Included2: Supports simplified backups with users in the system through ContOps ModeNoNoNoNoNoNoYesYesYesYesYesYes
VSS Writer Included: VSS Writer supports full backups with users in the system (Server Engines only)NoNoNoNoNoNoYesYesYesYesYesYes
SaaS Licensing Available: Hosted applications and Software-as-a-Service installations are supportedNoNoNoNoNoNoYesYesYesYesYesYes
Online Database Defragmenter: Optimize storage and performance of data files with system runningNoNoNoNoNoNoNoYesYesYesYesYes
VM Live Migration Support: More flexible licensing model allows for easier server managementNoNoNoNoNoNoNoYesYesYesYesYes
SQL Unicode Support: Support for NCHAR, NVARCHAR data types and new UNICODE ODBC driversNoNoNoNoNoNoNoYesYesYesYesYes
Simplified Installation: Installs all components for the OS -- no more split 32-bit or 64-bit installersNoNoNoNoNoNoNoYesYesYesYesYes
Simplified Licensing: License is based on machine name only, not the hardware fingerprintNoNoNoNoNoNoNoYesYesYesYesYes
Standalone Server License Available: Allows full 64-bit engine performance on single-user system at a lower costNoNoNoNoNoNoNoYesYesYesYesYes
CVE-2017-11757 Vulnerability Resolved: This security vulnerability has been addressed.NoNoNoNoNoNoNoYesYesYesYesYes
Cache Management: Allows you to load data into the database engine cache (or purge it) to improve performanceNoNoNoNoNoNoNoNoYesYesYesYes
Btrieve 2 API: Simpler interface for new developers, supporting C/C++, and SWIG access for C#, JavaScript, Perl, PHP, Python, etc.NoNoNoNoNoNoNoNoYesYesYesYes
Free Reporting Engine Available: Cache engine offloads SQL processing for better SQL performanceNoNoNoNoNoNoNoNoYesYesYesYes
Edge Server Edition Available: Supports SQL/Btrieve on Edge/IoT Devices (like RaspPi) on ARM and IntelNoNoNoNoNoNoNoNoYesYesYesYes
BTRVEX API: Supports larger data buffers, as well as support for tables over 256GB or with more than 4 billion rowsNoNoNoNoNoNoNoNoYesYesYesYes
LIKE Function Supported in Extended Operations: Allows developers to search for text data more rapidlyNoNoNoNoNoNoNoNoYesYesYesYes
TRY_CAST and TRY_CONVERT Functions Added: Allows data conversions in SQL to not fail on errorNoNoNoNoNoNoNoNoYesYesYesYes
UPSERT Capability Added: Allows SQL statements to attempt an INSERT, and if it fails, switch to an UPDATE insteadNoNoNoNoNoNoNoNoYesYesYesYes
BIGIDENTITY/AUTOINC Support: Supports 8-byte auto-increment values to support more recordsNoNoNoNoNoNoNoNoYesYesYesYes
Improved Schema Export/Import: Streamlines conversion to v2 metadata or migrating tables to a new databaseNoNoNoNoNoNoNoNoYesYesYesYes
Active Directory Integration: Offers a simplified security scheme for AD usersNoNoNoNoNoNoNoNoYesYesYesYes
Core Edition Available: Supports SQL/Btrieve on Android/iOS DevicesNoNoNoNoNoNoNoNoNoYesYesYes
AUTOTIMESTAMP Data Type: Stores current timestamp on Insert or UpdateNoNoNoNoNoNoNoNoNoYesYesYes
TIMESTAMP2 Data Type: Provides support for nanosecond precision on timestampsNoNoNoNoNoNoNoNoNoYesYesYes
AES-256 File Encryption: Provides improved security on disk with known and tested algorithmNoNoNoNoNoNoNoNoNoYesYesYes
Java Engine Separated: Allows upgrade of Java separately from the Actian componentsNoNoNoNoNoNoNoNoNoYesYesYes
JSON Filtering in GetNextExtended Calls: Allows search of LONGVARCHAR data for JSON-formatted dataNoNoNoNoNoNoNoNoNoYesYesYes
New DeleteExtended Capability: Can delete multiple records faster and more efficiently in a single callNoNoNoNoNoNoNoNoNoYesYesYes
Data Export Utility Included: Allows easy export of data from the command line with built-in toolNoNoNoNoNoNoNoNoNoYesYesYes
CVE-2022-40756 Vulnerability Resolved: This security vulnerability has been addressed.NoNoNoNoNoNoNoNoNoYesYesYes
Long Owner Names 2: Improved security with 32-byte owner names and better encryptionNoNoNoNoNoNoNoNoNoYes4Yes4Yes4
Large Sector Support: SSD volumes with sector sizes over 4K are supportedNoNoNoNoNoNoNoNoNoYes5Yes5Yes5
File Close Delay: Performance gain when files are closed then opened againNoNoNoNoNoNoNoNoNoNoYesYes
SQL Performance Improvements: SQL engine is faster for DELETE and LIKE/ILIKE OperationsNoNoNoNoNoNoNoNoNoNoYesYes
Scalar Subquery Optimization: SQL is faster when non-correlated, scalar subqueries are usedNoNoNoNoNoNoNoNoNoNoYesYes
System Data v2: Stores create and last update time for each record and exposes it from SQLNoNoNoNoNoNoNoNoNoNoYesYes
SQL Windowing Functions: New functions for OVER(PARTTION...) syntax, as well as EVERYN, LAG, and DATEFLOOR functions for time-series dataNoNoNoNoNoNoNoNoNoNoYesYes
JSON Output From Tools: Allows scripting environments like Powershell to parse results more easilyNoNoNoNoNoNoNoNoNoNoYesYes
Configure On Installation: Allows developers to slipstream configuration options at installation timeNoNoNoNoNoNoNoNoNoNoYesYes
More Detailed Key Statistics: Improves optimization of SQL queries -- requires minimum v15.10NoNoNoNoNoNoNoNoNoNoYes6Yes6
EasySync: Simplified Data ReplicationNoNoNoNoNoNoNoNoNoNoNoYes
SQL LIKE/ESCAPE: Ability to change escape character for LIKE clausesNoNoNoNoNoNoNoNoNoNoNoYes
SQL Query Logging: Enable/disable from Control CenterNoNoNoNoNoNoNoNoNoNoNoYes
Offline Rebuild: Ability to rebuild files on a machine without a database licenseNoNoNoNoNoNoNoNoNoNoNoYes
Page Read-Ahead: Improves performance of STEP operationsNoNoNoNoNoNoNoNoNoNoNoYes
.NET 8 Support: New SDK components for .NET 8NoNoNoNoNoNoNoNoNoNoNoYes
Nested JSON Support: Allows access to nested JSON in Extended OperationsNoNoNoNoNoNoNoNoNoNoNoYes
System Data: Access to system data from Btrieve 2 APINoNoNoNoNoNoNoNoNoNoNoYes
Improved Python Packages: Support for Python Package Index (PyPI)NoNoNoNoNoNoNoNoNoNoNoYes

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 using this feature can be read on Zen v14 or higher ONLY. If you copy these files back to v13 or older, they will be unreadable.

5 Sector sizes over 4K are a hardware function of the physical hardware and cannot be changed. This hardware is supported in v14.21 Update 6 and higher, and v15.10 and higher.

6 Files using this feature can be read on Zen v15.10 or higher ONLY. If you copy these files back to v15.00 or older, they will be unreadable.

7 Files using this feature can be read on Zen v16.00 or higher ONLY. If you copy these files back to v15 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 Supportedv5v6v7v8v9v10v11v12v13v14v15v16
DOS (Including Client) YesYesYesYesYesNoNoNoNoNoNoNo
Novell NetWare YesYesYesYesYesNoNoNoNoNoNoNo
IBM OS/2 YesYesYesNoNoNoNoNoNoNoNoNo
Linux (Various Distros) NoNoNoYesYesYesYesYesYesYesYesYes
Mac OS X NoNoNoNoNoNoNo10.9
10.10
10.10
10.11
10.10-
10.14
10.14
10.15
?
Raspbian/Raspberry Pi OS NoNoNoNoNoNoNoNoYesYesYesYes
Windows IoT Core Intel/ARM NoNoNoNoNoNoNoNoYesYesYesYes
Android (Zen Core Library) NoNoNoNoNoNoNoNoYesYesYesYes
iOS (Zen Core Library) NoNoNoNoNoNoNoNoYesYesYesYes
Windows 3.1x YesYesYesNoNoNoNoNoNoNoNoNo
Windows 95 YesYesYesNoNoNoNoNoNoNoNoNo
Windows 98/Me YesYesYesYesYesNoNoNoNoNoNoNo
Windows NT Workstation 3.5x NoYesYesNoNoNoNoNoNoNoNoNo
Windows NT Workstation 4 NoYesYesYesYesNoNoNoNoNoNoNo
Windows 2000 Workstation NoYesYesYesYesYesNoNoNoNoNoNo
Windows XP NoYesYesYesYesYesYesNoNoNoNoNo
Windows Vista NoNoNoNoNoYesYesYesNoNoNoNo
Windows 7 NoNoNoNoNoYesYesYesYesYesNoNo
Windows 8.1 NoNoNoNoNoNoYesYesYesYesYesNo
Windows 10 NoNoNoNoNoNoNoYesYesYesYesYes
Windows 10 IoT Enterprise NoNoNoNoNoNoNoNoNoNoYesYes
Windows 11 NoNoNoNoNoNoNoNoNoNoYesYes
Windows NT Server 4 NoYesYesYesYesNoNoNoNoNoNoNo
Windows 2000 Server NoYesYesYesYesYesNoNoNoNoNoNo
Windows Server 2003/SBS NoYesYesYesYesYesYesNoNoNoNoNo
Windows Server 2008/SBS/R2 NoNoNoNoNoYesYesYesYesYesNoNo
Windows Server 2012/SBS2011 NoNoNoNoNoNoYesYesYesYesYesNo
Windows Server 2016 NoNoNoNoNoNoNoNoYesYesYesYes
Windows Server 2019 NoNoNoNoNoNoNoNoYesYesYesYes
Windows Server 2022 NoNoNoNoNoNoNoNoNoNoYesYes

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 Supportedv5v6v7v8v9v10v11v12v13v14v15v16
ActiveX NoYesYesYesYesYesYesYesYesYesNo2No2
ADO.NET NoNoNoNoYesYes3.2
3.5
4.0
4.0
4.2
4.2
4.3
4.3
4.4
4.4
4.5
4.4
4.?
Btrieve 16-bit YesYesYesYesYesNo1No1No1No1No1No1No1
Btrieve 32-bit NoYesYesYesYesYesYesYesYesYesYesYes
Btrieve 64-bit NoNoNoNoNoYesYesYesYesYesYesYes
Btrieve 2 API NoNoNoNoNoNoNoNoYesYesYesYes
Distributed Tuning InterfaceNoNoNoYesYesYesYesYesYesYesYesYes
Distributed Tuning Objects NoNoNoYesYesYesYesYesYesYesYesYes
JCL NoNoNoYesYesYesYesYesYesYesYesYes
JDBC NoNoNoYesYesYesYesYesYesYesYesYes
JDBC 4.0 Driver NoNoNoNoNoNoNoNoYesYesYesYes
NetWare/Scalable SQL YesYesYesNoNoNoNoNoNoNoNoNo
ODBC 16-bit NoYesYesYesYesNoNoNoNoNoNoNo
ODBC 32-bit NoYesYesYesYesYesYesYesYesYesYesYes
ODBC 64-bit NoNoNoNoNoNoYesYesYesYesYesYes
OLEDB NoNoNoYesYesYesYesYesYesYesNo2No2
PDAC (Delphi/RAD Studio) NoNoNoYesYesYesYesYesYesYesYesNo2

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

In June 2024, Actian changed their support model and provided new phases, but with no new descriptions, so we don't yet understand what these terms actually mean. Right now, your guess is as good as mine, but we'll update this when we know more.

Engine VersionFirst Customer
Ship (Release)
End of Enterprise SupportEnd of Extended SupportEnd of Obsolescence Support
Actian Zen v14 August 2019August 2024August 2029August 2034
Actian Zen v15 August 2021August 2026August 2031August 2036
Actian Zen v16 June 2024June 2029June 2034June 2039

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-2024, 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