Python: JSON-friendly Database Library

Mukesh3

Registered
Feb 23, 2022
2
0
1
hyderbad
cPanel Access Level
DataCenter Provider
At the risk of downvotes, here goes:

I am looking for a JSON-friendly database management library in python. SQLite3 seems attractive at first glance because I would like to store the database locally (and a file is easily moved/manipulated). However, the SQL structure in general is poorly suited for my application. The data I am managing in Python is a dictionary with VERY DEEP nesting. So, to flatten this data to be useful in SQL is suboptimal. Since I intend to have multiple users reading and writing to the database simultaneously, I would prefer something that is ACID compliant. I am currently reading the "database JSON file" as a Python dictionary, making changes to data in the dictionary, and then again writing the entire dictionary to a JSON file. As the length of the JSON files increases, write times become excessive and the ability for users to simultaneously write to the file is lost.

Are there any python libraries that support JSON database management for deep nests? If I could set a SQL table value to another table maybe we'd be in business but I haven't found anything indicating that is acceptable.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
11,718
1,862
363
cPanel Access Level
Root Administrator
Hey there! I didn't reply to this yesterday because I didn't have anything to add from my end. This might be better suited to a more general development forum as these questions don't directly relate to the cPanel software.

It's always possible another user will let you know about their experience with these tools.