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 DependenciesPure ISO C11 engine compiling to a self-contained single binary with zero third-party runtime requirements. |
Sub-Millisecond EngineDual storage architecture: in-memory Copy-on-Write and 4KB slotted disk pages exceeding 380,000 queries/sec. |
Native AI Vector SearchSIMD-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.