Even if there exists modules that do this (see other answer), I tried to write one simple, self-contained version. Here is a class KeyValueStore (key and value are strings) that works like this: Demo from sqlitekeyvaluestore import KeyValueStore kv = KeyValueStore('test.db') # uses SQLite print(len(kv)) # 0 item kv['hello1'] = 'you1' kv['hello2'] = 'you2' kv['hello3'] = 'you3' print(kv['hello1'])
![Use SQLite as a key:value store](https://cdn-ak-scissors.b.st-hatena.com/image/square/98d6f053a97a87156775f60757c60865d0f2c47d/height=288;version=1;width=512/https%3A%2F%2Fcdn.sstatic.net%2FSites%2Fstackoverflow%2FImg%2Fapple-touch-icon%402.png%3Fv%3D73d79a89bded)