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.
LionSQL discards distributed multi-master complexity and bloat, vertically saturating single-node hardware with 28,000+ real-world transactions per second.
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.
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.
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.
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 (/_/).
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.
LionSQL was architected and benchmarked on macOS, with first-class binaries compiled for Linux servers and Windows environments.
Apple Silicon (arm64) & Intel (x86_64)
Native developer workstation tier. Delivers 28k TPS locally with full WiredTiger MVCC and pure In-Memory OCC support.
amd64 & aarch64 (Ubuntu / RHEL / Alpine)
Full production target. Hardened systemd daemon lifecycle, epoll networking, high-throughput WAL streaming, and CDC replication.
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.
Audited and benchmarked under strict ACID all-or-nothing transaction boundaries with zero race conditions.
:8090LionSQL 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 (/_/).
/sdk/lionsql.js (zero bundler needed)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.
# Reproduce complete 107-suite SQLLogicTest execution with 8 parallel workers
./bin/sqllogictest -dir test/slt -parallel 8
Download precompiled standalone binaries with zero dependencies, or build directly from source using Go.
: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.