simple-database-c

Certainly! Here's the updated documentation with the resource included: simple-database-c A lightweight SQLite clone written in C, designed to explore how databases work from the ground up. This project walks through building a simple relational database step by step, covering key concepts like indexing, transactions, and storage formats. 🚀 Why This Project? Ever wondered how databases actually work under the hood? How is data stored in memory and on disk? What makes transactions and rollbacks possible? How do indexes speed up queries? What happens when a table gets too big? This project is a hands-on attempt to build a database from scratch to understand these concepts deeply. 🔧 Features 🖥️ Interactive REPL to run SQL-like commands 📝 Basic SQL compiler & virtual machine 📂 File-based storage for persistence 🌳 B-Tree indexing for fast lookups 🔄 Transaction support with rollbacks 🔍 Binary search for efficient queries 📚 What You’ll Learn The fundamentals of database storage (memory & disk) How SQL queries are processed behind the scenes How B-Trees work and why they’re used in databases The mechanics of transactions and rollbacks The basics of writing a mini SQL engine in C