Optuna: Question: Is it ok to open SQLite database file twice?

Created on 5 Feb 2020  路  2Comments  路  Source: optuna/optuna

While I do a training with:

study = optuna.create_study(
        direction='maximize', 
        study_name="training_01", 
        storage='sqlite:///data/training_01.db',
        load_if_exists=True,
        )

I want to open up an other notebook and read the data from the database like you describe here: https://optuna.readthedocs.io/en/stable/tutorial/rdb.html#experimental-history

The question is: is it ok to open the database file (SQLite) twice?

Thanks
Philip

question

Most helpful comment

Thank you for your question.

It's okay unless you place an SQLite database file on NFS.
SQLite doesn't allow multiple applications to open the same database file on NFS simultaneously. If you are interested in the detail, please refer to the SQLite official FAQ entry.

All 2 comments

Thank you for your question.

It's okay unless you place an SQLite database file on NFS.
SQLite doesn't allow multiple applications to open the same database file on NFS simultaneously. If you are interested in the detail, please refer to the SQLite official FAQ entry.

Awsome. Thanks!

Was this page helpful?
0 / 5 - 0 ratings

Related issues

g-votte picture g-votte  路  3Comments

konradsemsch picture konradsemsch  路  4Comments

djKooks picture djKooks  路  4Comments

elbaro picture elbaro  路  4Comments

c-bata picture c-bata  路  3Comments