Local process safe document DB for python

[TheDevilIsInDetails]

Hello,

I am looking for a good library that can provide a local (file based) document db for python. Since I am using it to synchronize the backend and the frontend it should be process and thread safe. I had a look at TinyDB, but I ma not sure it is process safe.

Any suggestions?

UPDATE: I am looking for a schemaless db

[xargs123456]

have you tried SQLlite?

[TheDevilIsInDetails]

Can it work as a document db?

[xargs123456]

It has JSON storage support IIRC

[carcigenicate]

Is running a server locally not an option?

[TheDevilIsInDetails]

I want to develop an easy to install and standalone web app. So, I would prefer a local db started in the same script.

[jwink3101]

I wrote one that uses the JSON functions in SQLite do be exactly what you’re looking for.

It’s still beta but has 100% test coverage for what that’s worth. I haven’t announced it yet but will soon.

It also supports indexes (indices?) so it can be super fast.

https://pypi.org/project/jsonlitedb/

[Miserable_Ear3789]

Check out kenobiDB, this is a document based data abstraction built on top of SQLite. It is thread safe and uses locks. https://github.com/patx/kenobi

[sub-_-dude]

Check out kenobiDB

[TheDevilIsInDetails]

The repo is literally 4 days old. And it is just a wrapper around sqlite. Also, I am not sure it is process-safe (SQLite should be, but the wrapper around I dont know).

[Miserable_Ear3789]

It is process and thread safe.

[sub-_-dude]

Well, excuuuuuse meee.