A lightweight Mini Database Management System (DBMS) project built to demonstrate the core concepts of database operations, storage, and querying in a simplified environment.
-
Basic CRUD operations
Create, Read, Update, and Delete records from a mini database. -
Simple Query Support
Perform searches using basic commands and conditions. -
File-based Storage
Stores data in structured files to simulate persistent storage. -
Command-line Interface
Interact with the database using intuitive terminal commands. -
Validation & Error Handling
Ensures data integrity and prevents invalid operations.
- Language: Python
- Data Storage: JSON files
- Tools: Git, VS Code, Terminal
mini-dbms/ │ ├── src/ # Source code files ├── data/ # Sample database files ├── tests/ # Test scripts for functionality ├── README.md # Project documentation └── LICENSE # License file (optional)
- Clone the repository:
git clone https://github.com/KLIIRTY/mini-dbms.git
cd mini-dbms
Run the main program:
python main.py
Follow the command-line prompts to perform CRUD operations.
📊 Example Usage
> CREATE table_name field1 field2
> INSERT table_name value1 value2
> SELECT table_name WHERE field1=value1
> UPDATE table_name SET field2=value2 WHERE field1=value1
> DELETE table_name WHERE field1=value1
✅ What You’ll Learn
Fundamentals of database design and management
Handling persistent storage without a full-fledged DBMS
Implementing data validation and error handling
Working with command-line interfaces for user interaction
🌟 Future Improvements
Support for advanced queries (like joins or aggregates)
Adding multi-user access and concurrency
Integrating a GUI frontend
Implementing indexing for faster queries
📞 Contact
Author: Kelvin Njiru
GitHub: KLIIRTY
Email: Nyagakevin822@gmail.com