PSQL
Actian Zen, formerly known as Pervasive PSQL, is an embedded database engine designed for edge computing, IoT, and ISV applications that require local data processing with optional cloud sync.
Publisher review
Actian Zen, formerly known as Pervasive PSQL, is an embedded database engine designed for edge computing, IoT, and ISV applications that require local data processing with optional cloud sync. It runs on Windows, Linux, Android, iOS, and macOS, and can be deployed in VMs or containers. The product targets developers building resource-constrained or offline-first systems where low maintenance and transactional responsiveness are critical. Zen is not a general-purpose SQL server; it is a record manager with a secondary SQL interface, best suited for applications that use its native transactional API (the legacy Btrieve interface).
Zen supports both NoSQL and fully ANSI-compliant SQL interfaces, allowing developers to query data via either API. It handles tables up to 64TB and includes AES 256-bit encryption for data at rest and in transit. A key architectural feature is NoETL between versions: schema and data upgrades do not require extract-transform-load processes, simplifying long-term maintenance. The database connects to any ODBC/JDBC or ASP.NET source or destination, and supports client libraries for C/C++, C#, Java, JavaScript, Python, Delphi, and Basic. It offers three deployment tiers: Zen Mobile (a lightweight library embedded directly in apps for IoT devices), Zen Edge (full client-server for edge gateways with up to 100 concurrent users), and Zen Enterprise (for large-scale ERP, POS, and accounting systems).
In the embedded database market, Zen competes with PostgreSQL, RaimaDB, and Ditto, as well as backup-focused tools like OpenText/Carbonite and NovaBACKUP. PostgreSQL is often cited as 50-70% faster than PervasiveSQL when using the SQL interface, according to user testing. However, Zen's transactional API is described as "the most responsive DB you can imagine" for record-oriented workloads. The product is not a direct replacement for PostgreSQL in SQL-heavy scenarios; its strength lies in offline persistence, low-latency edge processing, and minimal administrative overhead.
The honest trade-off: Zen's SQL interface is historically less performant and stable than dedicated SQL databases, as noted by long-time users. If your primary access path is SQL, PostgreSQL or another RDBMS will likely deliver better throughput and reliability. Zen also lacks a subscription-based pricing model (it is traditionally licensed per-seat or per-server), which may be a pro or con depending on budget preferences. The product's documentation and community support are thinner than PostgreSQL's, and its ecosystem is dominated by legacy ISV applications rather than modern cloud-native stacks.
How it works
-
Dual NoSQL/SQL interfaces
Supports both a native transactional (Btrieve) API and fully ANSI-compliant SQL, letting developers choose the access method per use case.
-
Multi-platform deployment
Runs on Windows, Linux, Android, iOS, macOS, and within VMs or containers, covering edge devices to enterprise servers.
-
AES 256-bit encryption
Encrypts data at rest and in transit using AES 256-bit standards, meeting common security compliance requirements.
-
64TB table support
Handles tables up to 64 terabytes, suitable for large-scale transactional or IoT data sets without sharding.
-
NoETL version upgrades
Schema and data upgrades between versions do not require extract-transform-load processes, reducing maintenance downtime.
-
Multi-language client libraries
Provides SDKs for C/C++, C#, Java, JavaScript, Python, Delphi, and Basic, plus ODBC/JDBC and ASP.NET connectivity.
-
Edge-to-cloud sync
Designed for offline persistence at the edge, with built-in capabilities to sync data to the cloud when connectivity is available.
Strengths and trade-offs
Strengths
- Transactional API is described by users as 'the most responsive DB you can imagine' for record-oriented workloads.
- Supports tables up to 64TB with no ETL required between versions, simplifying long-term data management.
- Runs on 6 operating systems (Windows, Linux, Android, iOS, macOS) plus VMs and containers, enabling broad edge deployment.
- Very low maintenance overhead, with one user noting 'the database software itself is very low maintenance and has been great.'
Trade-offs
- SQL interface is historically less performant and stable than dedicated SQL databases like PostgreSQL.
- User testing indicates PostgreSQL can be 50-70% faster than PervasiveSQL when using the SQL interface.
- Not recommended as a primary SQL database; its strength is the transactional API, not SQL access.
- Pricing is not subscription-based and requires contacting Actian for quotes, making cost comparison opaque.
Pricing context
Pricing is not publicly listed; available through Actian sales or support packs. Historically licensed per-seat or per-server, not subscription-based.
Getting started with PSQL
-
Download and install Zen
Visit the Actian website and download the Zen Edge or Enterprise installer for your target OS. Run the installer, accept the license, and choose the deployment tier that matches your concurrent user count and device type.
-
Configure database instance
Open the Zen Control Center and create a new database instance. Set the database name, file path, and encryption key if AES 256-bit protection is required. Enable the SQL interface if you plan to use ANSI SQL queries.
-
Connect via ODBC/JDBC
Install the Zen ODBC or JDBC driver on your application server. Use the driver manager to add a new data source pointing to your Zen instance, specifying the server hostname, port, and database name.
-
Load data with Btrieve API
Write a small program using the Zen client library for your language (e.g., C# or Python). Open a connection, create a table using the transactional API, and insert sample records to verify read/write performance.
-
Schedule backup and sync
Set up a recurring backup job using the Zen Backup utility or a script that calls the backup API. If using edge-to-cloud sync, configure the cloud endpoint and sync interval in the Zen settings to push local data when online.
Frequently Asked Questions
What is Actian Zen and how is it different from a regular SQL database?
Actian Zen, formerly Pervasive PSQL, is an embedded database engine for edge computing and IoT. Unlike general-purpose SQL servers, it is a record manager with a secondary SQL interface, optimized for transactional workloads using its native Btrieve API rather than SQL.
What platforms does Actian Zen support for deployment?
Actian Zen runs on Windows, Linux, Android, iOS, and macOS, and can be deployed in virtual machines or containers. This multi-platform support makes it suitable for edge devices, gateways, and enterprise servers, covering a wide range of hardware environments.
How does Actian Zen compare to PostgreSQL in terms of performance?
User testing shows PostgreSQL can be 50 to 70 percent faster than PervasiveSQL when using the SQL interface. However, Zen's transactional API is described as highly responsive for record-oriented workloads, making it better suited for offline persistence and low-latency edge processing.
What are the key features of Actian Zen for IoT and edge computing?
Key features include dual NoSQL and SQL interfaces, AES 256-bit encryption, support for tables up to 64TB, NoETL version upgrades, multi-language client libraries, and edge-to-cloud sync. These features enable local data processing with optional cloud synchronization for resource-constrained devices.
How is Actian Zen licensed and what are the pricing options?
Actian Zen is traditionally licensed per-seat or per-server, not subscription-based. Pricing is not publicly listed and must be obtained through Actian sales or support packs. This model may suit some budgets but makes cost comparison less transparent than subscription alternatives.
What are the main weaknesses of Actian Zen compared to other databases?
The SQL interface is historically less performant and stable than dedicated SQL databases like PostgreSQL. Documentation and community support are thinner, and its ecosystem is dominated by legacy ISV applications. It is not recommended as a primary SQL database for SQL-heavy scenarios.
Alternatives
How PSQL compares
Direct head-to-head against 3 competitors. Picked by 7wData.
PSQL
- Pricing
- Pricing is not publicly listed; available through Actian sales or support packs. Historically licensed per-seat or per-server, not subscription-based.
- Target
- Actian Zen, formerly known as Pervasive PSQL, is an embedded database engine designed for edge computing, IoT, and ISV applications that require local data processing
- Strength
- Transactional API is described by users as 'the most responsive DB you can imagine' for record-oriented workloads.
- Watch for
- SQL interface is historically less performant and stable than dedicated SQL databases like PostgreSQL.
Neon
- Pricing
- Free to $299/mo (8 vCPU, 16 GiB)
- Target
- Serverless PostgreSQL with database branching for dev/test
- Deployment
- Cloud (multi-region)
- Strength
- Database branching like git branches for development workflows
- Watch for
- Cold start latency and compute-hour billing can be unpredictable
Supabase
- Pricing
- Free to $99/mo (4 vCPU, 8 GiB)
- Target
- Firebase alternative with PostgreSQL, auth, and realtime
- Deployment
- Cloud (multi-region)
- Strength
- Built-in auth, realtime subscriptions, and storage alongside PostgreSQL
- Watch for
- Free tier pauses after 7 days of inactivity; fixed plans limit flexibility
DigitalOcean Managed Databases
- Pricing
- $15/mo (1 vCPU, 1 GiB) to $244/mo (6 vCPU, 16 GiB)
- Target
- Simple, transparently priced managed PostgreSQL for production
- Deployment
- Cloud (US, EU, Asia)
- Strength
- Transparent pricing with no hidden egress fees
- Watch for
- Limited PostgreSQL configuration options and fewer enterprise features
User reviews
No user reviews yet. Be the first to write one.
Sources
Reporting on this tool draws on these publicly available sources.