my error with line db = TinyDB('db.json'), in python 3.6

rs904c

I'm brand new to using tinyDB.
I'm using Python 3.6.0, and I can see this is version is not supported yet.
I'm using Windows 7.

I'm following the getting started instructions, in the Basic Usage area.

from tinydb import TinyDB, Query
db = TinyDB('db.json')
I step through my code and this line give me the following error:
builtins.PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'db.json'

So, in case someone is using tinydb, they might want to hold off on upgrading to Python 3.6, as it seems incompatible.
I'm looking forward to testing with a development version of tinydb, or waiting until a version comes out that works with Python 3.6.

I downgraded to python 3.4, and I'm still getting this exact error. Can you help?

msiemens

Hey rs904c, so it seems like db.json is already opened in another program, maybe a text editor. Could you check no other program has opened your db.json or maybe try a different file name?

This behaviour shouldn't depend on the Python version, so you should be able to use TinyDB with both Python 3.4 and Python 3.6.

Cheers!

rs904c

msiemens
I tried a different file name and still got the same error.

I searched some documentation and I found the following:
f
rom tinydb import TinyDB, where
from tinydb.storages import
db = TinyDB(storage=MemoryStorage)

I don't get an error any more, but I'm not sure it is writing data, since when I do db.all(), I get nothing.

msiemens

That's really weird. Do you have some sort of anti-virus running that might interfere with TinyDB here? How exactly do you insert data into the database?

Cheers!

rs904c

I think the problem was that the db files was in a directory with a "#" in the name. Like c:\wip#prog1\