DataBasePython is a command-line database management system written in Python.
Features
- Create and delete tables
- Insert, read, update, and delete data
- Supported data types: int, str, bool
- Automatic ID generation
- Pretty table output
- Confirmation for dangerous operations
| Command | Description |
|---|---|
create_table users name:str age:int is_active:bool |
Create a new table with typed fields |
insert into users values ("Alice", 28, true) |
Insert a new record |
select from users |
Display all records |
select from users where age = 28 |
Display records by condition |
update users set age = 29 where name = "Alice" |
Update matching records |
delete from users where age = 29 |
Delete matching records |
info users |
Display table information |
- create_table users name:str age:int is_active:bool
- insert into users values ("lock", 28, true)
- select from users
- update users set age = 28 where name = "lock"
- delete from users where age = 28
- info users