← Back to Projects
Mini-SQL

Mini-SQL

Go SQL LSM-Tree File I/O

A lightweight SQL database written in Go that supports CREATE TABLE, INSERT, and SELECT operations with persistent storage. Built on top of my LSM Tree Storage Engine as the storage backend, turning a low-level engine into a usable database.

Technical Highlights

  • SQL parser for CREATE TABLE, INSERT, and SELECT statements
  • LSM-tree storage with memtable + SSTables for write-optimized performance
  • Write-ahead log (WAL) for crash recovery and durability
  • Embeddable as a Go library or usable via interactive REPL
  • Data persists across restarts via SSTable files