boxdb 0.2

Make Your own personal database liter than others

BOXDB

This a database managment lib made for python, which works like any Libraries and is very lite no aditional setup require but there is some procedure to create a project is very easy.

Installation

• use pip install boxdb
• Make sure that your pip version is updated pip install --upgrade pip.
• Select the correct package for your environment:
• Import the package: import boxdb

Clone the project

  git clone https://github.com/kshitij1235/boxdb/tree/main/dist

Install

  pip install boxdb

Libraries Used

• Tabulate
• filemod

Features

• Very lite and easy to maintain
• custom encryption are very easy to apply
• faster in performace

things to keep in mind

• you can only acess the database file when your python file and database file are in same directory

How to use it :)

phase 1

1. In order to start with boxdb you first need to have a file for table reaction with a variable with some parameters

2. you can use this code to start with it too

from boxdb import*

#in this variable you make sure too include the the name key aka variable as it will be your table name 
# and rest you can put any number of keys values you want its upto you 

info={
    'name':"plasma",      
    'description':"makeing heard of cows talking to each other and making things more brigth for the world to take stem"
}

# with the help of this function your table will be created 
boxdb.create_project(info)

#with the help of this function you can check the details of your table which  you stored
details=boxdb.get_detail("plasma")
print(details)

functions	description	arguments
create_project	This function creates basic file system to store data	info(patten given above for variable naming)
get_detail	This gives you all the basic details of the table	table_name

phase 2 (wow you learned to set up boxdb)

Now lets start with row creation and deletion

from boxdb import*

# At start lets create some row !!!!

# you can pass string or even list to create rows its according to your wish
# ill show creating 4 rows 3 with rows and 1 with string
row=["sr no","names of cow","lites fo milk"]

# this fucntion takes table name (in my case its  "plasma") and rows you can pass list if you have many rows 
# or you can use string if you wanna create one single row 


# this is multiple 
boxdb.create_row("plasma", rows)

# this is single row 
boxdb.create_row("plasma", "update")

#you can always delete a row if you want


# this fucntion takes table name (in my case its  "plasma") and rows you can pass list if you have many rows to delete
# or you can pass a sting if you wanna delete a single row

# in this case am deleting a single row but you can always pass a list to
boxdb.remove_row("plasma", "update")

functions	description	arguments
create_row	This function helps you create rows in you table	table_name,row(accepts list or string)
remove_row	Helps you delete rows if you dont want	table_name,row(accepts list or string)

Lets learn about creating columns

from boxdb import*

# At start lets create some columns!!!!

# you have to pass list to columns according to the rows 

# for example if you have three rows ,you have to pass 3 elements each elements gets added to 
# each row 

# In short you can add 1 column at a time but a fix for that will be realease soon too 

columns=["1","amanda","28"]

# this fucntion takes table name (in my case its  "plasma") and column you have to  pass list 
# thta you created earlier according to row size 

# this is multiple 
boxdb.add_column("plasma", columns)


#you can always delete a column if you want


# this fucntion takes table name (in my case its  "plasma") 
# and the number of column 

# in this case am delelting a single columns whic h is column number 1
boxdb.remove_column_number"plasma", 1)

functions	description	arguments
add_column	This function helps you create columns in you table	table_name,column_data(list)
remove_column_number	Helps you delete column if you dont want	table_name,remove_column_number

Showing table

from boxdb import*

# Displaying table is a kids job , its very easy 

# this function helps you to show table 
# this function takes a single argument which is table name(in my case its "plasma")

##i understand few freatures should be added to improve the use of show table functions
# and yes it would be release soon 

boxdb.get_table("plasma")

functions	description	arguments
get_table	This function helps to visualize the table	table_name

License

MIT

Feedback

If you have any feedback, please reach out to us at email [e-mail]