DEV Community

Cover image for strip.pysondb a new JSON DB for python
Adwaith Rajesh
Adwaith Rajesh

Posted on

strip.pysondb a new JSON DB for python

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,

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
Enter fullscreen mode Exit fullscreen mode
  # 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)

Enter fullscreen mode Exit fullscreen mode
  • Output
  $ py test.py
  7.166365623474121
Enter fullscreen mode Exit fullscreen mode

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
Enter fullscreen mode Exit fullscreen mode
  # 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)
Enter fullscreen mode Exit fullscreen mode
  • Output
  $ py test2.py
  0.009546756744384
Enter fullscreen mode Exit fullscreen mode

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.

Discussion (0)