sqlitedict
sqlitedict copied to clipboard
piskvorky
Persistent dict, backed by sqlite3 and pickle, multithread-safe.
Hello, I am a happy user of the SqliteDict. Thanks for making it! I would like to store a list as a table in the same sql file. At the...
It would be nice to have sqlitedict methods as co-routines. Thoughts?
Looking for similar prefix scan functionality like what is available in LevelDB or BadgerDB. Basically looking for the option to scan a set of prefixes. ``` def prefix_iteritems(self, prefix: str):...
Fixes #69 with `weakref` reader queue.
Took me some time to find the culprit, but after upgrading to sqlitedict `2.0.0` the writing is significantly slower. I am writing with: ``` with SqliteDict("tmp.db") as tmp: tmp["tmp"] =...
Encountered this error during a write to the database using the library. The objects being written were `collections.Counter[Tuple[str]]` and `Dict[str, Counter[Tuple[str]]]` Both types of objects previously worked fine in being...
After power down I got this issue on many files. Other sqlite3 files were working well. ```` class nestedDictSqlite(defaultdict): 'like defaultdict but default_factory receives the key so table is used...
I store the main object id as a tablename. If I want to drop the object from the db, there is no way to drop a table using the SqliteDict...
1. Added a Class _Con_SqliteDict which inherits SqliteDict but uses an existing Connection to initialize, it can be used for converting an existing sqlite connection to a SqliteDict connection, although...
 `sql_operation(0, oneId, twoId, threeId, fc)` ``` def sql_operation(w, oneId, twoId, threeId, fc): global code_folder fc2=0 try: if w==0: try: mydict = SqliteDict(code_folder+'core.sqlite', autocommit=True) uid = str(oneId)+"_"+str(twoId)+"_"+str(threeId) mydict[uid] = fc...
