Accessing SQLite Databases Concurrently
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 459
- Forks
- 359
- Avg merge
- 3d 6h
- Merged PRs (30d)
- 73
Description
If you encounter a bug use the following template.
If you have a feature request feel free to freestyle.
### Steps to reproduce
1. Put the sqlite database on a shared drive
1. Run a measurement on one computer
2. Load a dataset on another computer from the shared SQLite database.
### Expected behaviour
I expect to be able to load datasets, or inspect them with plottr-inspectr as they are coming in.
### Actual behaviour
Database is locked. Unable to open the DB.
### System
**operating system**
Windows 10
**qcodes branch**
unknown, using version 0.22
**qcodes commit**
unknown
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the shared-drive scenario described on Windows 10, with one computer measuring and another loading or inspecting data through plottr-inspectr. Trace the SQLite access used for dataset loading and inspection; done means concurrent measurement and dataset access no longer fails with “Database is locked”.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sqlite
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100