What it can do
- Create new tables
- Insert records into tables
- Display stored data
- Update existing records
- Delete records or entire tables
- Store table data using JSON files
How it works
The Mini Database Engine follows a simple modular structure.
- Table Management Module Handles creating, listing, and deleting tables.
- Record Management Module Manages inserting, selecting, updating, and deleting records.
- Storage Module Stores table data inside JSON files inside the database folder.
- Command Interface Allows users to interact with the database using commands such as create_table, insert, select, update, and delete.
Example Terminal Output
DB> create_table students
Enter columns: name,age,city
Table 'students' created successfully.
DB> insert students
Enter name: alex
Enter age: 21
Enter city: Houston
Record inserted successfully.
DB> select students
ID | NAME | AGE | CITY
1 | alex | 21 | Houston
Technologies Used
- Python
- JSON file storage
- Command Line Interface
- Object Oriented Programming