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 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 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
Large Sector Support: SSD volumes with sector sizes over 4K are supportedNoNoNoNoNoNoNoNoNoYes5Yes5
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.

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.


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 NoNoNoNoNoNoNoYesYesYesYes?
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 NoNoNoNoNoNoYesYesYesYesYes?
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
Actian Zen v14 August 2019December 2022 (Delayed)Not ScheduledNot Scheduled
Actian Zen v15 August 2021Not ScheduledNot ScheduledNot Scheduled
Actian Zen v16 Summer 2024?Not 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-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