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

UPDATE

• get_table() now we can select rows to show

• add_column() is been tweed so it fills empty spaces by null

• create_rows() is been updated soliving spacing problem in data file

• read performace is been improved with new lib update of filemod

Libraries Used

• Tabulate

• filemod

Features

• Very lite and easy to maintain

• custom encryption are very easy to apply

• faster in performace

Updates

• get_table() is updated now it can take selective rows.

• create_row() bug is solved.

• minor create_row() bug solved

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 (Creating a TABLE)

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 function takes table name (in my case its  "plasma") and column you have to  pass list 

# that 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")



'''

now there is another method to do it with selective rows

''' 



list_of_rows=["sr_no","number_of_cows"]

doxbd.get_table("plasma",[list_of_rows])

| 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 kshitijjathar7@gmail.com