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.

Saturday, October 31, 2026

Open Source Release: RunicShell for Linux 4.6.2

 Today the PC/OpenSystems LLC team is pleased to announce the release of RunicShell 4.6.2 for Linux.

RunicShell for Linux is a lightweight, high-performance, object-oriented command shell and scripting language written in modern standard C++20. It bridges the structured pipeline capabilities of PowerShell with Unix/POSIX ergonomics and native system telemetry—compiled into a single fast binary with zero runtime dependencies.

Some of the changes between this and the Windows release are

  • Native Linux binary
  • Native BASH and KSH script support to run unmodified sh or ksh scripts
  • Over 260 cmdlets 
  • Can be compiled on BSD and macOS as well
  • RPM package for easy install and inclusion in distribution repositories
  • Tested on various RPM distributions
  • Portable binary also for alternate distributions

The source code is available here

The release RPM and portable release can be found here

We hope everyone has a great Halloween

Tuesday, October 27, 2026

CrossShell for UNIX 15.7.1 Now Available

PC/OpenSystems, LLC is pleased to announce the release of CrossShell for UNIX 15.7.1. This update introduces new Windows command-line utilities and delivers stability improvements across the suite, including updates to CrossShellKSH and CrossShellZSH. 

About CrossShell for UNIX:  CrossShell for UNIX is a collection of more than 250 native utilities for Windows and Windows Server. It helps administrators, developers, and IT teams work across Windows and UNIX/Linux environments using familiar command-line tools. Unlike compatibility layers that rely on traditional text-stream workflows, many CrossShell utilities are designed to work with both text and structured Windows data. This approach enables tools such as awk, grep, and sed to interoperate with Windows technologies, including the Registry, CIM, and WMI. 

What's New: 

 New utilities - 
  • diskinfo: Reports information about fixed and removable disks, as well as network shares. - 
  • netconf: Displays active network connection information for wireless, Ethernet, and virtual network interfaces. - 
  • zstd: Provides command-line compression and decompression using the Zstandard format from Meta. - 
  • wslmgr: Offers a text-based interface for managing WSL instances and containers. - 
  • xmic: Provides a command-line alternative to the deprecated WMIC utility for querying CIM and WMI data. - 
  • yum: Brings the Yellowdog Updater, Modified package-management workflow to Windows, including support for system updates, winget packages, and Windows RPM packages. Improvements - 

Stability improvements and bug fixes across the utility suite. - 
  • CrossShellKSH 3.2.3: Expanded built-in compatibility, improved shell-script support, and better standalone operation. - 
  • CrossShellZSH 3.7.16: Expanded built-in compatibility, improved scripting and color support, and tab completion. 
Installation:

To install this release use the .msi from the Github release page or the portable distribution which now includes an optional script for installation.  If you are a current user of CrossShell for UNIX there is an RPM package available for install.

Getting CrossShell for UNIX Download the open-source release from the project's GitHub Releases page. Physical copies, including documentation, are available through the PC/OpenSystems web store.

Friday, October 16, 2026

Open Source Release: Vi for Windows

 The PC/OpenSystems LLC Open Source team is pleased to announce our new release of Vi for Windows Server 2022/2025 Core and Desktop.  Vi 5.0.0-2026 is our take on the classic Vi editor for the Windows Server platform.  

You can download it from here

https://github.com/rjdohnert/Vi-For-Windows

You can view the user's guide here

https://github.com/rjdohnert/Vi-For-Windows/blob/main/vi-user-guide.md

Key Highlights

  • Zero-Dependency Native Binary: Single self-contained executable (vi.exe & view.exe) powered by Windows Console Virtual Terminal Sequences with no external runtime dependencies beyond standard system libraries (user32.dll).
  • Full Mouse & Scroll Wheel Support: SGR mouse reporting (:set mouse=a / :set nomouse) with click-to-position cursor in any mode, smooth split-window wheel scrolling, right-click Windows clipboard paste ("+p), and clickable top tabline switching.
  • Extended Regular Expression Engine: Vim-compatible regex engine featuring precision match anchors (\zs, \ze), character classes (\d, \D, \w, \W, \s, \S), quantifiers (\+, \?, *), word boundaries (\<, \>), and character sets ([...], [^...]).
  • Non-Blocking Async Background Grep: Multithreaded :grep <pattern> on background worker threads with an animated status bar spinner and auto-populated Quickfix list (:copen, :cnext, :cprev, :clist).
  • Side-by-Side Diff Mode: Real-time LCS line comparison (vi -d file1 file2, :diffsplit <file>, :diffthis, :diffoff, :diffupdate) with gutter markers (+, -, !) and synchronized dual-window scrolling.

Window, Tab & Workspace Management

  • Multi-Window Viewport Splits: Horizontal and vertical splits (:split, :vsplit, :close, :only), directional navigation (Ctrl-W h/j/k/l), cycling (Ctrl-W w/p), and equal balancing (Ctrl-W =).
  • Tab Pages: Multi-tab management (:tabnew, :tabclose, :tabnext / gt, :tabprev / gT, :tabonly) with an interactive top tabline.
  • In-Memory Multi-Buffer Manager: Edit multiple files simultaneously (:ls, :b, :bn, :bp, :bd, :badd) with geometric buffer scaling (O(N)O(N)) for instant large server log loading.
  • Workspace Session Persistence: Save and restore complete window layouts, buffers, tabs, and cursor positions (:mksession [path], :source <path>, vi -S [path]).
  • Integrated Directory Explorer & Fuzzy Finder: Netrw-style directory browser (:Explore, :Sex, vi <dir>) and fast recursive in-memory file finder (:find <query>).
  • CTags Symbol Navigation: Cross-file symbol jump (Ctrl-], :tag <sym>), tag stack pop (Ctrl-T, :pop), and stack inspection (:tags).

Editing, Reliability & Shell Integration

  • Complete Vi Grammar & Text Objects: Full [count][operator][count][motion] composition, inner/around text objects (iw, aw, quotes, and brackets/parentheses/braces), and Visual Block Mode (Ctrl-V / Ctrl-Q) with column insert/append (I, A).
  • Indent-Based Code Folding: Collapse and expand code blocks (zc, zo, za, zR, zM, :set fdm=indent).
  • Buffer-Word Autocompletion: Zero-dependency Ctrl-N / Ctrl-P keyword completion across all active buffers.
  • Crash Recovery & Persistent Undo: Real-time swap journaling (.{filename}.swp, :recover) plus optional disk-persisted multi-session undo trees (.{filename}.un~, :set undofile).
  • External Modification & Read-Only Protection: Automatic detection of external disk changes (:set autoread, :checktime) and Windows FILE_ATTRIBUTE_READONLY enforcement ([RO] indicator, vi -R, view.exe).
  • Windows Clipboard & Line Endings: Native clipboard bridge ("+y, "+p, "*y, "*p) and transparent CRLF / LF preservation.
  • Interactive Subshell & Filter Pipes: Suspend or spawn a nested shell (:terminal, :sh) and pipe buffer ranges through external commands (:%!sort, :'<,'>!findstr ...).

Appearance & Syntax Highlighting

  • 5 Built-In Color Schemes: :colorscheme <dark|light|monokai|gruvbox|classic> (alias :colo).
  • 23 Languages & Formats Supported:
    • Systems & Compiled: C/C++, Rust, Go, Zig, Swift, Objective-C, Java, COBOL, Fortran, Pascal, Basic
    • Web & Scripting: JavaScript/TypeScript, Python, PowerShell, Batch/CMD, Shell (sh/bash/zsh)
    • Data, Config & Markup: TOML, SQL (ANSI & T-SQL), XML/HTML/SVG, YAML, INI/Registry/INF, JSON, Markdown


Installation & CLI Quick Start

  • Per-User Install: .\install.ps1 (installs vi.exe and view.exe to %LOCALAPPDATA%\Programs\vi)
  • System-Wide / Server Core Install: .\install.ps1 -AllUsers (installs to %ProgramFiles%\vi for all users, SSH, and WinRM sessions)
  • Explorer Context Menu: .\install.ps1 -ContextMenu (adds "Open with Vi" to Windows File Explorer)

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.