Monday, November 16, 2026

PC/OpenData SQL Server 27.0 Released

Official Release Announcement

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.

Published by PC/OpenSystems LLC • BSD-3-Clause Open Source • Production Heritage Since 2006

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.

⚡ Under 5ms Cold Start 🔒 Zero Vendored Crypto 🧠 Built-In HNSW Vector AI 🔄 3-Node Raft Consensus 📦 Single-File C11 Amalgamation

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.

# Windows (Powershell / Command Prompt)
.\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:

CREATE TABLE products (
  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 PATH configuration.
  • 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.

© 2006–2026 PC/OpenSystems LLC. All rights reserved. Released under the BSD-3-Clause License.

Welcome to PC/OpenSystems LLC

PC/OpenSystems LLC. is dedicated to providing top customer service including integration, providing Linux compatible hardware and enterprise desktop software solutions. We provide solutions tailored to your needs whether its building systems to suit your needs. Whether its a custom database solution, providing Linux powered PC and Server Solutions. Whatever you need you can rest assured that PC/OpenSystems LLC. will deliver a high performance and stable product


PC/OpenSystems LLC. Web Search

About PC/OpenSystems LLC.

PC/OpenSystems LLC. is a small consulting firm and the only Linux retailer in NC for Linux PC's and custom systems located in Franklinton North Carolina. We specialize in hardware repair and we resell custom Linux based computers, software maintenance as well as custom application development.