A fast python database. python database

Today we will be talking about strip.pysondb, as the name suggest it's stripped down version of an existing JSON DB called pysondb.

We will discuss some issues with pysondb and how the strip.pysondb fixes those issues.

But first, some of the core features of strip.pysondb are.

No third party packages needed
No CLI
No ImageUtils
Use of python naming conventions in functions and classes.
Just the code required to perform CRUD operation on JSON DB.
Users can generate custom id's for their

Even though its called a stripped-down version of the original. There are some huge differences in the strip.pysondb works.

The data is not saved to file instantly, instead a methods needs to be called in order to do that.
The user is supposed to pass the keys / column name for the DB during initialization of the DB class.
Some of the new methods that are not derived from PysonDB are,
- pop
- commit
- load
- values
- set_id_generator
- id_exists

Let's talk about speed

Here is a sample code that continuously add 1000 values to the DB, and calculates the time it takes to add all the 1000 values

pysonDB

pip3 install pysondb

# test.py
from time import time

from pysondb import db

a = db.getDb("test.json")

t1 = time()
for i in range(1000):
    a.add({"name": f"name{i}", "age": i})
t2 = time()

print(t2 - t1)

Output

$ py test.py
7.166365623474121

Yep, it takes 8 seconds to add 1000 values. If the DB already has a 1000 values then it takes 20 seconds.

strip.pysondb

pip3 install strip.pysondb

# test2.py
from time import time

from pysondb import DB

db = DB(keys = ["name", "age"])

t1 = time()
for i in range(1000):
    db.add({"name": f"name{i}", "age": i})

db.commit("test2.json")
t2 = time()

print(t2 - t1)

Output

$ py test2.py
0.009546756744384

As you can see it only takes 0.01 seconds to add 1000 values. It only takes 0.9 seconds to 100_000 values to the DB.

Click here to see the GItHub Repo and for more info on the usage of strip.pysondb Star it if you like it.

So next time you want to use a DB in your projects choose wisely and research all the available options.

Thank you for reading.

strip.pysondb a faster JSON DB for python

Let's talk about speed