🗄️ Mini Relational DBMS in C++

A lightweight, file-based SQL engine built from scratch using C++. Supports core relational database operations including JOINs, conditional filters, indexing, and persistence.

---

✅ Features

• CREATE TABLE name (col TYPE [PRIMARY KEY], ...)
• INSERT INTO name VALUES (...)
• SELECT * FROM name
• DELETE FROM name WHERE col = val
• UPDATE name SET col = val WHERE col = val
• DROP TABLE name
• EXPORT TABLE name
• SHOW TABLES
• SHOW COLUMNS FROM name
• TRUNCATE TABLE name
• CREATE INDEX ON name col
• FIND FROM name WHERE col = val (uses index)
• JOIN t1 AND t2 ON t1.col = t2.col
• JOIN ... WHERE t2.col = val
• EXPORT JOINED TO filename.table
• EXIT with unsaved export reminder
• transaction.log replay support

---

🏗️ How It Works

• All tables are stored as .table files (CSV-style)
• Each command is parsed using C++ stringstream
• Primary key constraints and type checking are enforced
• JOIN results are stored in-memory and exportable
• On startup, all .table files are auto-loaded and transactions are replayed

---

🚀 Getting Started

✅ Compile:

With g++:

g++ src/main.cpp src/Table.cpp -o dbms
./dbms