Skip to main content

Make Your own personal database liter than others

Project description

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

boxdb-0.1.tar.gz (5.5 kB view hashes)

Uploaded Source

Built Distribution

boxdb-0.1-py3-none-any.whl (6.0 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page