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

+ Data Protection Products

+ Goldstar Software Services

+ Goldstar Software Tools

+ Other Solutions

AMS Users: Click Me Fix My PSQL License Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

  PSQL v13 Quick Links
Product Information
Pricing Information
Patch Downloads
License Options Explained
Workgroup vs Server?
Buy Now On-Line!
Ongoing Support
Why Goldstar?

Actian PSQL v13 Product Information

First Customer Ship:June 27, 2017
End of General Availability:Not Scheduled
End of Support:Not Scheduled

Click here for the PSQLv13 Product Data Sheet

As with previous versions (Actian PSQL v12 and older), PSQL v13 is available for Windows in both 32-bit and 64-bit levels. The Linux and OS X engines are 64-bit only. We do not expect compatible versions of DataExchange and AuditMaster until 2018 at the earliest.

At the same time, Actian announced yet another rebranding of their product, so you can look forward to more changes to come. The name "Actian PSQL v13" will be retired in favor of a new name -- Actian Zen Embedded Database v13. This new name is supposed to help convey the primary features of PSQL -- Zero-DBA, Embeddable, and Nano-footprint (i.e. small size). As this is a recent development, the current PSQL v13 product and downloads are not going to see any of these rebranding changes right away, but this change is expected to be done slowly, kind of like when they changed Pervasive Software to Actian within the v11-v12 time frame. We will post new information about the name change as it comes to light, but if you start to see announcements for "Zen v13", you'll know to what this is referring.

What's New In PSQL v13?

Here is a list of the most important new features in this release:

  • Support for Larger Data Sets: The new v13 file format supports files as large as 64TB and with up to 18 quintillion records! A new BTRVEX function is needed to access systems over 4 billion records, but this can be phased into your code, modifying applications only where needed.
  • PSQL Reporting Engine: Many users have asked for this feature over the years, and it has finally come to fruition! Included FREE with PSQL v13 is a new Reporting Engine (RE), which allows you to set up a secondary PSQL server for reporting purposes. Now, you can off-load your SQL queries and reports, preserving the performance of your production server.
  • New Btrieve C and C++ APIs: Simpler development is here! A new Btrieve 2 API is included with v13 which offers a simplified way of calling the database from C, but also from object-oriented languages like C++. Even better, a new SWIG API is available for the Btrieve 2 API which offers access from Perl, PHP, Python, and other scripting environments. Get more details from the Getting Started guide.
  • New Schema Export and Import in PCC: A completely revamped solution to exporting and importing your SQL metadata is available in v13, making it possible to recreate your databases, migrate from v1 to v2 metadata, and more.
  • Updated Cache Management: Would you like to purge useless data from your database engine cache? A new option for BUTIL is available to do just that! This command can be used to flush pages from a large, rarely-accessed file from your database cache. Even better -- use the -CACHE option to pre-load data from your critical files into the cache, improving performance for your users!
  • New SDKs: ADO.NET 4.3 modules, as well as .NET Standard 2.0 drivers, are now available (ADO.NET 4.0 has been deprecated in PSQL v13).
  • LIKE with Btrieve Extended Operations: Service Pack 1 adds a new feature for developers -- the ability to use LIKE syntax to search for substrings with the Extended Operations, such as GetNextExtended and StepNextExtended. This feature will provide performance gains to the SRDE right away, and can allow for LIKE searching in your Btrieve applications to provide a substantial speed improvement.
  • Integration with AD Security: Service Pack 1 adds a new Active Directory security integraton feature for the SQL engine. You can create groups in AD, along with matching groups in SQL, and SQL security will be handled through the AD assignment. (A user can still be a member of only one group.) This can ease the administrative overhead for Windows users.
  • New Operating System Support: SP1 adds support for the Windows Nano Server environment, allowing you to run on a minimim-footprint, non-GUI version of Windows Server designed to run in the cloud or within containers. This engine can be managed remotely via WMI and PowerShell, and it reduces the OS size and security footprint of your environment considerably, saving both storage space and memory. SP3 adds official Android, iOS, and Windows Server 2019 support, as well.
  • 8-Byte AutoInc/BIGIDENTITY: SP2 adds support for an 8-byte AutoInc data type, which was added (in SP3) to SQL as the BIGIDENTITY data type.
  • TRY_CAST and TRY_CONVERT: SP2 adds two new SQL functions that return NULL if the conversion fails (instead of crashing the query).
  • UPSERT Capability: SP3 adds the UPSERT capability -- attempt an INSERT and if it fails, treat it as an UPDATE instead.

You can get the official What's New document now.

Supported Operating Systems and Hardware Requirements

Officially supported operating systems include Windows 7 and newer, and Windows Server 2008 R2 and newer only, along with various OS X and Linux distributions and versions. Windows Vista, Windows XP, Server 2003, Server 2008 (not R2) and older operating systems are not formally supported by Actian with this release! This does not mean that they will not work, but only that they have not been officially tested or supported by Actian.

There are no stated minimum hardware requirements. Essentially, if you can run the OS, you can run the database engine. However, performance will be commensurate with the resources provided, as well as the workload.

Actian PSQL v13 License Models

Actian PSQL v13 has three different license models to choose from:

  • Workgroup Engine: Per-user licensing, up to a maximum of 5 concurrent users
  • Server Engine: Per-user licensing, starting at 6 concurrent users
  • Cloud Server Engine: Data size licensing with unlimited users for Web/SaaS installations

Please see our PSQL v13 License Primer for more information on the various license types and other factors that might help you determine the best license type for your environment.

If you have decided on per-user licensing, but you are still not sure if you want the Workgroup Engine or the Server Engine, check out our Workgroup Versus Server Comparison Chart.

Pricing for each of these license models can be found on our Actian PSQL v13 price list, or you can BUY IT NOW from our on-line store. If you want to try out different license models before you buy (a really good idea!), you can get trial downloads from here.

Still not sure which license model or size to get?

Actian PSQL v13 Application Support

We expect application vendors to start testing Actian PSQL v13 soon after its release, and hopefully to announce support for the new version shortly thereafter. If we have heard from your vendor, then our Application Support pages may have useful information already for you. Otherwise, please contact your application vendor directly to find out when they expect to support PSQL v13.

[Expand Entire Page... ] [Collapse Entire Page... ]

[+] Actian PSQL v13.30 (SP3, a.k.a. v13 R2)...

[+] Actian PSQL v13.20 (SP2)...

[+] Actian PSQL v13.10 (SP1)...

[+] Actian PSQL v13.00 (FCS)...

[+] Frequently Asked Questions About Actian PSQL v13...

[Expand Entire Page... ] [Collapse Entire Page... ]

If you have additional questions about the product, please contact us!

  Copyright © 1997-2019, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 3007 Carmel Dr | Flossmoor IL 60422 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us