Skip to content

akemi-aiai/DataBasePython

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Python CLI Database Engine

Python CLI CRUD Data Types Poetry Makefile Storage Status

DataBasePython is a command-line database management system written in Python.

Features

  1. Create and delete tables
  2. Insert, read, update, and delete data
  3. Supported data types: int, str, bool
  4. Automatic ID generation
  5. Pretty table output
  6. Confirmation for dangerous operations

Commands

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

Examples:

  1. create_table users name:str age:int is_active:bool
  2. insert into users values ("lock", 28, true)
  3. select from users
  4. update users set age = 28 where name = "lock"
  5. delete from users where age = 28
  6. info users

About

Python CLI database engine with CRUD commands, typed fields, automatic IDs, pretty table output, caching, and logging.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors