Actian Zen
activeby Actian (HCLSoftware) · since 1982 · also known as Btrieve, Pervasive PSQL, Pervasive.SQL, Zen Edge
The Btrieve/Pervasive lineage: zero-admin embedded database with key-level and SQL access, now edge-focused.
Overview
Actian Zen is the current name for the database that began as Btrieve in 1982 and later became Pervasive PSQL. Its trick is dual access to the same files: a fast record-level Btrieve 2 API for navigational reads and writes, and a relational SQL engine with ODBC/JDBC on top. That made it a favourite for accounting, practice-management and retail ISVs that ship a database inside their product and need it to run unattended. Actian, now part of HCLSoftware, released Zen 16.0 in June 2024 with larger key sizes, Kafka streaming, EasySync replication and container support. It is best for existing Btrieve applications and small embedded/edge deployments.
Strengths & trade-offs
Strengths
- +Same data reachable through fast Btrieve record API and standard SQL
- +Runs for years inside ISV products with essentially no administration
- +Small footprint editions for Android, iOS and Raspberry Pi edge devices
- +Long backward compatibility for decades-old Btrieve applications
Trade-offs
- −Shrinking ecosystem; most usage is legacy ISV software
- −SQL engine is less capable than mainstream RDBMSs
- −Commercial licensing for a niche product
Great for
- +Accounting and practice-management software back ends
- +Point-of-sale and retail store systems
- +Edge devices that sync data to a central server
Think twice for
- −Large centralised OLTP
- −Analytics
- −Greenfield cloud-native apps
Capabilities
Native or official first-party support · 11 of 25 tracked
Scale & consistency
- Comfortable data size
- Small · ≤ 100 GB
- Horizontal scaling
- None
- Multi-region
- No
- Transactions
- Full ACID
- Consistency
- Strong
- Schema
- Strict
- Architecture
- Embedded, Client server
- Query languages
- SQL, Btrieve 2 API
Deployment
Ecosystem
Alternatives to Actian Zen
The in-process SQL engine that ships in every phone, browser and OS: one file, zero servers.
actian-zen vs sqlite →Self-tuning embeddable SQL database with MobiLink sync, still shipped inside ISV apps but frozen at v17.
actian-zen vs sap-sql-anywhere →Small-footprint embedded database with SQL and network-model APIs for RTOS, edge and safety-certified devices.
actian-zen vs raima-database-manager →Embedded JSON document database with SQL++ queries, vector search and sync to Couchbase.
actian-zen vs couchbase-lite →Microsoft's flagship RDBMS: T-SQL, columnstore, Always On, and now native vectors and JSON.
actian-zen vs sql-server →Embedded time-series and relational database for microcontrollers, RTOS and edge AI devices.
actian-zen vs ittia-db →Actian Zen FAQ
What is Actian Zen?
Actian Zen is a relational database by Actian (HCLSoftware), first released in 1982. Actian Zen is the current name for the database that began as Btrieve in 1982 and later became Pervasive PSQL. Its trick is dual access to the same files: a fast record-level Btrieve 2 API for navigational reads and writes, and a relational SQL engine with ODBC/JDBC on top. That made it a favourite for accounting, practice-management and retail ISVs that ship a database inside their product and need it to run unattended. Actian, now part of HCLSoftware, released Zen 16.0 in June 2024 with larger key sizes, Kafka streaming, EasySync replication and container support. It is best for existing Btrieve applications and small embedded/edge deployments.
Is Actian Zen open source?
No. Actian Zen is proprietary, closed-source software.
Does Actian Zen support ACID transactions?
Yes. Actian Zen supports full ACID transactions, with strong consistency.
Does Actian Zen scale horizontally?
Actian Zen does not scale horizontally; it runs on a single node, so you scale it up rather than out. It is comfortable at small scale (≤ 100 GB).
How can I run Actian Zen?
You can self-host it, embed it in your application and run it at the edge.
What is Actian Zen best for?
Actian Zen is a strong fit for accounting and practice-management software back ends; point-of-sale and retail store systems; and edge devices that sync data to a central server. Think twice for large centralised OLTP.
What are the best alternatives to Actian Zen?
Common alternatives to Actian Zen include SQLite, SAP SQL Anywhere, Raima Database Manager, Couchbase Lite and Microsoft SQL Server. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.
How popular is Actian Zen?
Actian Zen ranks #278 of 844 databases on the WhichDB Score (11.7/100), and #89 among relational databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.