Announcing PC/OpenData SQL Server v27.0
A high-performance, embeddable ISO C11 ACID relational database engine featuring native Vector Search, 3-node Raft Quorum, and dual in-memory / slotted disk storage.
PC/OpenSystems LLC is proud to announce the official open source release of PC/OpenData SQL Server v27.0. Originally engineered in 2006 for mission-critical Sun Solaris (SPARC and x86) environments, PC/OpenData has powered enterprise-grade operations for nearly two decades. Today, the engine has been thoroughly modernized for Linux, Windows Server, and edge cloud environments, and released under the permissive BSD 3-Clause License.
What Sets PC/OpenData Apart?
💾 Dual Storage Architecture
Choose between ultra-fast in-memory Copy-on-Write (CoW) for microsecond sub-millisecond transactions or persistent 4KB slotted disk pages with B+ Tree indexes for databases exceeding physical RAM.
🧠 Native Vector Search & HNSW
Built-in VECTOR(dim) type with Cosine and L2 Euclidean distance operators, native HNSW indexing, and 8-bit Scalar Quantization (SQ8) reducing embedding memory consumption by 75%.
🔄 Synchronous Raft Quorum
Synchronous dual-write remote WAL shipping with strict majority quorum consensus across 3-node clusters. Eliminates split-brain and guarantees zero data loss on failover.
🏢 Enterprise SSO & Directory Auth
Native Active Directory UPN binds, OpenLDAP/FreeIPA authentication, and Kerberos/SPNEGO single sign-on with automatic security group role mapping.
📝 Built-in IRIS SQL Editor
Terminal-based GNU Nano-styled SQL editor embedded directly into the binary. Edit multi-line statements, load SQL scripts, format syntax, and execute with a single hotkey.
🔒 OS-Supplied Cryptography
Zero vendored crypto packages. Windows builds use CNG/Schannel; Linux builds leverage OS OpenSSL libcrypto and libssl. Builds without TLS reject unencrypted external exposure.
Getting Started in 60 Seconds
PC/OpenData builds with Clang, GCC, or MSVC in under five seconds. You can compile from separate translation units or drop in the single-file amalgamation src/opendata.c.
.\build.bat
.\bin\opendata.exe mydata.pcod
# Linux (Enterprise Linux / Ubuntu / Debian)
OPENDATA_TLS=1 bash build-scripts/wsl-build.sh
./bin/opendata mydata.pcod
Inside the SQL Shell, create tables, query data, and explore formatted output views:
id NUMBER PRIMARY KEY,
name VARCHAR2(60),
embedding VECTOR(3)
);
INSERT INTO products VALUES (1, 'High-Performance Database', '[0.95, 0.10, 0.05]');
COMMIT;
-- Switch formatting modes: table, box, markdown, json, csv, vertical
.mode table
SELECT * FROM products;
🔍 Built-In Release Diagnostics
Every build includes the full self-contained diagnostic test suite. Simply run opendata self-test to execute 1,820 automated checks across 13 test suites in less than 500 ms without installing Python, pytest, or external dependencies.
Pre-Packaged Releases Available Now
- Windows Installer: System-wide MSI/ZIP distribution with automatic UAC elevation and machine
PATHconfiguration. - Linux RPM Package: Native binary RPM for RHEL, CentOS 10, Rocky Linux, Fedora, and AlmaLinux with pre-configured Systemd service management.
- Docker & Kubernetes: Production-ready Alpine Linux multi-stage container image with non-root daemon execution.
- Client Bindings: Official SDKs for Python (
import opendata) and Node.js (require('opendata')), plus a dedicated Visual Studio Code syntax extension.
Get Started with PC/OpenData Today
Download the code, inspect the documentation, or deploy directly to your infrastructure.