Official Release: v0.93.0 (Updated today)

Single-Binary, High-Concurrency
OLTP Database Server

LionSQL provides native Microsoft SQL Server T-SQL stored procedures, dual storage engines, and sub-microsecond interactive execution — packaged into a single standalone static executable with zero sidecars.

Go 1.26 Native Wire Protocols: PGWire (:5433) & TDS (:1433) Precompiled Bytecode Engine Zero External Daemons (No Redis / PgBouncer)
Architectural Invariants

Engineered for Sub-Microsecond OLTP

LionSQL discards distributed multi-master complexity and bloat, vertically saturating single-node hardware with 28,000+ real-world transactions per second.

Dual Wire Protocols

Simultaneous native support for PostgreSQL v3 wire protocol (:5433) and Microsoft SQL Server TDS (:1433). Connect seamlessly with psql, SSMS, DBeaver, and any standard ORM without proxy translation layers.

Precompiled Bytecode Execution Engine

Compiles T-SQL into lean, register-allocated bytecode instructions with sync.Pool recycling. Executes point lookups and interactive stored procedure loops in sub-microsecond (<1µs) latency.

Non-Blocking Dual Storage Engines

In-Memory OCC engine with 2.8M inserts/sec SkipList and private workspaces, paired with WiredTiger (the default storage engine used in MongoDB) for lock-free B+Tree MVCC and enterprise-grade ACID durability.

Zero-Sidecar & Embedded SPA Hosting

No Nginx, no Redis, no PgBouncer. Directly host React/Vue/Svelte SPAs (--app=./dist) via OS kernel sendfile(2) (45k+ RPS), with zero CORS and sub-microsecond in-process DB queries alongside the Web Studio (/_/).

Verified Ecosystems

Seamless Compatibility Across 9 Production Stacks

LionSQL provides 100% verified compatibility across top open-source platforms, ORMs, and BI suites over native PostgreSQL (:5433) and Microsoft SQL Server TDS (:1433) wire protocols — zero code changes or proxy sidecars required.

Multi-Platform Ecosystem

Developed on macOS, Deployed Everywhere

LionSQL was architected and benchmarked on macOS, with first-class binaries compiled for Linux servers and Windows environments.

Primary Development

macOS

Apple Silicon (arm64) & Intel (x86_64)

Native developer workstation tier. Delivers 28k TPS locally with full WiredTiger MVCC and pure In-Memory OCC support.

  • ✓ Both WiredTiger (B+Tree) & In-Memory OCC
  • ✓ Zero CGo compilation options available
  • ✓ PGWire (:5433), TDS (:1433) & Web Studio
Production Server

Linux

amd64 & aarch64 (Ubuntu / RHEL / Alpine)

Full production target. Hardened systemd daemon lifecycle, epoll networking, high-throughput WAL streaming, and CDC replication.

  • ✓ 100% WiredTiger & In-Memory OCC engines
  • ✓ Docker & Kubernetes containerized builds
  • ✓ 1-Writer Multi-Reader HA automatic failover
In-Memory Engine

Windows

Windows 10/11 & Server (amd64 / arm64)

Standalone developer & desktop tier. Runs high-concurrency In-Memory OCC with persistent AOF/RDB storage on a single static binary.

  • ✓ Zero-install static binary (lionsql.exe standalone execution)
  • ✓ Full Windows tooling support (SSMS, sqlcmd, PowerShell & .NET)
  • ✓ 1ms multimedia timer engine (winmm.dll optimized scheduling)
  • ℹ Note: WiredTiger engine is excluded on native exe (WSL2 / Docker recommended for WiredTiger)
Real-World Throughput

Empirical TPC-C Benchmark Results

Audited and benchmarked under strict ACID all-or-nothing transaction boundaries with zero race conditions.

28,300
Native Go TPC-C (TPS)
763,496 tpmC (New-Order avg 0.82ms)
17,803
T-SQL Precompiled Bytecode (TPS)
475,781 tpmC (P50 0.56ms interactive)
2.8M
SkipList Inserts / Sec
Lock-free concurrent in-memory tree
< 5ns
Go Scalar UDF Latency
Direct zero-alloc in-process invocation
Built-in Web Studio Single-Process Fullstack

Zero-Proxy Web App & Web Studio on :8090

LionSQL unites a high-concurrency T-SQL database, an embedded flat web server, and a client SDK in one static binary. Host your production React, Vue, or Svelte build (--app=./dist) with zero CORS overhead and kernel-level sendfile(2) isolation (45k~65k RPS), while managing data via the built-in Web Studio (/_/).

✓ Same-Origin Zero-CORS: Frontend UI and DB APIs served from the same port (:8090)
✓ Zero Network Hop (0µs): In-process pointer calls eliminate loopback TCP overhead
✓ Built-in JavaScript SDK: Instant client access via /sdk/lionsql.js (zero bundler needed)
✓ OS Kernel sendfile(2) Isolation: Static web traffic never starves database OLTP execution
Read Web App Hosting Guide →
● LionSQL All-in-One Engine (:8090) v0.93.0
Frontend SPA Hosting: --app=./dist (Active, 0 CORS)
Management Web Studio: http://127.0.0.1:8090/_/
JavaScript Client SDK: /sdk/lionsql.js (Embedded)
Static Asset Throughput: 52,400 RPS (sendfile zero-copy)
In-Process DB Query Hop: 0µs (In-Memory pointer call)
Dual Wire Protocol: TDS :1433 & PGWire :5433
Engine Verification & Quality

Proven Engine Correctness: 100% SQLLogicTest Compliance

LionSQL achieves 100% PASS across the complete SQLLogicTest (SLT) 107-suite corpus—the gold-standard black-box oracle verification used by SQLite, DuckDB, and CockroachDB.

551,217
Queries Verified
Zero hash or value mismatches
100%
Full Corpus Pass Rate
107 of 107 test suites passed
3VL
Strict 3-Valued Logic
Sound NULL, CASE & BETWEEN semantics
Zero
Cross-Protocol Divergence
In-Memory OCC, WiredTiger & PGWire
✓
551,217 Queries Verified
Zero hash or value mismatches across deeply nested algebraic expressions, complex joins (up to 64 tables), and synthetic fuzzing suites.
✓
Strict 3-Valued Logic (3VL)
Mathematically sound evaluation of ternary boolean truth tables for NULL, CASE conditional branching, and BETWEEN range semantics.
✓
Cross-Protocol Parity
100% identical execution parity across the native In-Memory OCC engine, WiredTiger B+Tree MVCC, and PostgreSQL v3 Wire Protocol (:5433).
Self-verifiable via a single command
# Reproduce complete 107-suite SQLLogicTest execution with 8 parallel workers
./bin/sqllogictest -dir test/slt -parallel 8
Get Started

Up and Running in 10 Seconds

Download precompiled standalone binaries with zero dependencies, or build directly from source using Go.

1. Prebuilt Standalone Binaries

v0.93.0 (Updated today)
Pure static binaries • Zero runtime dependencies
macOS
Apple Silicon (arm64)
lionsql-darwin-arm64 36.7 MB
Download for macOS
Linux
amd64 / x86_64
lionsql-linux-amd64 37.9 MB
Download for Linux
Windows
amd64 (.exe)
lionsql-windows-amd64.exe 38.9 MB
Download for Windows

2. Launch Server Daemon

# Grant execution permission (macOS / Linux)
chmod +x lionsql-*

# Option A: Start database server (Zero external dependencies)
./lionsql-darwin-arm64 serve

# Option B: Host frontend React/Vue SPA + DB on :8090 without Nginx
./lionsql-darwin-arm64 serve --app ./dist

# Endpoints:
# Web Studio : http://127.0.0.1:8090/_/
# Web App : http://127.0.0.1:8090/
# TDS / SSMS : 127.0.0.1:1433
# PGWire : 127.0.0.1:5433

# Connect via PostgreSQL Wire (Recommended CLI)
psql -h 127.0.0.1 -p 5433 -U postgres -d master
💡
Recommended CLI (psql): LionSQL simultaneously listens on both Microsoft SQL Server TDS (:1433) and PostgreSQL Wire (:5433). For interactive terminal exploration and scripting, psql is strongly recommended for its rich meta-commands (\d, \l), clean tabular formatting, and native availability across macOS, Linux, and Windows.

3. Or Build from Source (Go 1.26+)

git clone https://github.com/MaroShim/LionSQL.git
cd LionSQL
# Build with WiredTiger storage engine (macOS / Linux)
go build -tags wiredtiger -buildvcs=false -o bin/lionsql ./cmd/lionsql

# Or build Pure-Go In-Memory binary (macOS, Linux, Windows)
go build -buildvcs=false -o bin/lionsql ./cmd/lionsql
Code copied to clipboard!