PC/OpenData SQL Server Enterprise Edition

PC/OpenData SQL Server Enterprise v27.0

High-Performance ACID Relational Database & AI Vector Similarity Engine

Solaris Heritage (2006–2026): Engineered originally for Sun Solaris (SPARC and x86), battle-tested across two decades of high-concurrency commercial production, and delivered commercially by PC/OpenSystems LLC.

Zero Dependencies

Pure ISO C11 engine compiling to a self-contained single binary with zero third-party runtime requirements.

Sub-Millisecond Engine

Dual storage architecture: in-memory Copy-on-Write and 4KB slotted disk pages exceeding 380,000 queries/sec.

Native AI Vector Search

SIMD-accelerated Cosine, L2 Euclidean, and Inner Product metrics with HNSW graph indexing for RAG pipelines.

Core Enterprise Features & Architecture

  • Full SQL Standard Engine: Complete support for DDL, DML, multi-table INNER/LEFT/RIGHT JOINs, correlated subqueries, aggregate functions (COUNT, SUM, AVG, MIN, MAX), indexed views, and ACID transactions (BEGIN, COMMIT, ROLLBACK, SAVEPOINT).
  • Dual Storage Engine Architecture:
    • In-Memory Copy-on-Write (CoW): Microsecond execution, lock-free snapshot isolation, and instantaneous rollback.
    • Disk Slotted Pages (ENGINE = DISK): 4KB fixed slotted pages with CLOCK buffer cache pool, WAL write-ahead logging, and B+ Tree indexing for multi-gigabyte persistent workloads.
  • AI Vector Similarity & HNSW Indexing: Store embeddings from OpenAI, HuggingFace, Cohere, or local LLMs directly inside VECTOR(n) columns. Approximate Nearest Neighbor (ANN) search via HNSW indexes provides sub-millisecond similarity retrieval.
  • MS SQL Server & Oracle Interoperability: Direct mounting, importing, and exporting of Microsoft SQL Server (.mdf, .ldf, BCP dumps) and Oracle Database (.dbf, Data Pump .dmp) files without third-party ETL tools.
  • High Availability & Disaster Recovery: Synchronous Raft 3-node quorum clustering, remote WAL shipping, and continuous archiving for deterministic Point-In-Time Recovery (PITR) down to the exact second.
  • Enterprise Security & Compliance: Native OS cryptography (Windows CNG / Schannel and POSIX OpenSSL), TLS 1.3 encrypted client-server traffic, role-based access control (RBAC), and tamper-evident cryptographic audit logs.
  • Modern Interactive Shell: POSIX raw mode line editor, Ctrl+R reverse history search, smart multi-candidate Tab completion with longest common prefix, integrated query results pager, and multi-line SQL statement execution.
  • Modern Web Studio: Full web and PWA interface running on an integrated lightweight HTTP server

Performance Benchmarks (100,000 Operations)

Workload Benchmark PC/OpenData SQL v27.0 Traditional Embedded SQL
Bulk Insert (100k Rows with WAL) 142 ms (704,225 ops/sec) 580 ms (172,413 ops/sec)
Primary Key Point Query 0.0026 ms / query 0.0094 ms / query
HNSW Vector Similarity Search (Top-5) 0.18 ms / search Not Natively Supported
Executable Binary Footprint < 1.2 MB Standalone 35 MB – 120 MB

Quickstart: Hybrid Relational & Vector SQL

-- Launch interactive shell with database storage file
$ opendata enterprise.pcod

-- Create hybrid table with relational metadata and embedding vectors
CREATE TABLE documents (
    id INT PRIMARY KEY,
    category VARCHAR(64),
    content TEXT,
    embedding VECTOR(1536)
);

-- Build fast HNSW index for vector similarity search
CREATE INDEX idx_docs_hnsw ON documents(embedding) USING HNSW;

-- Execute sub-millisecond Approximate Nearest Neighbor query
SELECT id, category, content, VECTOR_DISTANCE(embedding, [0.024, -0.015, ...]) AS distance
FROM documents
WHERE category = 'Enterprise'
ORDER BY distance ASC
LIMIT 5;

Enterprise Packaging & Deployment

Enterprise Linux (RPM)

Red Hat Enterprise Linux, CentOS Stream 10, Rocky, AlmaLinux:

sudo dnf install ./pc-opendata-27.0-1.el10.x86_64.rpm

Windows Server (MSI)

Windows Server 2022 / 2025 and Windows 10/11 x64:

msiexec /i OpenDataSQL-27.0.1-x64.msi /quiet

Order Commercial Licenses & Enterprise Support

PC/OpenData SQL Server Enterprise includes certified installation packages, commercial deployment licenses, direct engineer-backed SLAs, and automated maintenance updates from PC/OpenSystems LLC.

PC/OpenData SQL Server Enterprise is a commercial distribution and is not hosted on GitHub.

Looking for the community edition? The open-source engine is available on GitHub.


© 2006–2026 PC/OpenSystems LLC. All rights reserved. PC/OpenData SQL Server core engine is licensed 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.