Stoolap - High-performance HTAP SQL database in Go

High-performance HTAP SQL database

A modern Hybrid Transactional/Analytical Processing engine written in pure Go, combining row-based storage with columnar indexing and zero dependencies.

Get Started GitHub

Why Stoolap?

Modern database design for today's application demands

High Performance

Row-based storage for transactional workloads and columnar indexing for analytics deliver exceptional speed for both OLTP and OLAP operations.

Memory-First

Designed with in-memory operation in mind while providing optional persistence for durability. Ideal for both high-throughput and real-time applications.

HTAP Architecture

Hybrid Transactional/Analytical Processing unifies OLTP and OLAP workloads in a single system, eliminating the need for separate database engines.

Zero Dependencies

Built entirely in Go with no external dependencies, enabling simple deployment and minimal Docker images without bloat or security issues.

MVCC Transactions

Multi-Version Concurrency Control provides high isolation with minimal locking. Optimistic concurrency enables high throughput for mixed workloads.

SQL Standard

Supports modern SQL including JOINs, window functions, and advanced query features. Built for compatibility with existing SQL knowledge and tools.

Get Started in Minutes

Simple to install, easy to use

terminal

          $
          go get github.com/stoolap/stoolap
        

          $
          stoolap
        
Stoolap Database Server v1.0.0
Connected to memory database

          stoolap>
          CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);
        
Table created successfully.

          stoolap>
          INSERT INTO users VALUES (1, 'John Doe');
        
1 row affected.

          stoolap>
          SELECT * FROM users;
        
+----+----------+
| id | name     |
+----+----------+
| 1  | John Doe |
+----+----------+
1 row in set.

Easy to Install

Just one command to install, no dependencies or complex setup required.

Installation Guide

Standard SQL

Use familiar SQL syntax with powerful extensions for modern applications.

SQL Commands

Go Integration

First-class support for Go applications with native driver.

Quick Start Tutorial

Modern Architecture

Designed for performance, scalability, and ease of use

Flexible Client Interface

Built-in database/sql driver, command-line interface, and API access - all using the same high-performance core.

Optimized Query Processing

SQL parsing, intelligent query optimization, and vectorized execution deliver exceptional performance for both OLTP and OLAP workloads.

HTAP Storage Engine

Row-based version store with columnar indexing provides both transactional and analytical capabilities within a unified engine for the best of both worlds.

Explore Architecture

Ready to Get Started?

Explore Stoolap and transform your database experience.

Installation Guide Quick Start Tutorial

Open Source License

Stoolap is proudly open source, released under the Apache License 2.0.

Patent Protection

Includes explicit patent grant to protect users and contributors

Community-Friendly

Promotes collaboration while protecting contributions

Enterprise-Ready

Widely accepted in enterprise environments

View License Contribution Guidelines