LightningDB is a lightweight, high-performance relational database built from scratch in TypeScript. This project aims to provide a simple, efficient, and reliable database with support for indexing, transactions, joins, and a SQL-like query interface.
- ✅ Build a fully functional relational database from scratch.
- ✅ Implement CRUD operations (Create, Read, Update, Delete).
- ✅ Support SQL-like querying.
- ✅ Optimize with indexing and query planning.
- ✅ Implement transactions and concurrency control.
- ✅ Provide an SDK for JavaScript and TypeScript.
- Create Tables with schema definitions.
- Insert, Select, Update, Delete data.
- Query Execution with filtering and sorting.
- Basic Indexing for faster lookups.
- Transactions with ACID compliance.
- Joins to query across multiple tables.
- Backup & Restore to prevent data loss.
- Stored Procedures & Triggers for automation.
- Concurrency Control for safe multi-user access.
- Language: TypeScript
- Storage: File-based (JSON/Binary) or SQLite-like structure
- Query Engine: Custom SQL-like parser
- Indexing: Hash indexes & B-Trees (planned)
- API Layer: Node.js for server integration
yarn installyarn dev