2

Is there a way to share an in-memory sqlite database between two different python processes? I have looked around and while it can be done within the same process (using a connection string like sqlite3.connect("file:memdb1?mode=memory&cache=shared", uri=True) for example), it is not clear to me whether (and how) this is possible between processes.

I am using Windows and Python 3.8. Btw for linux it looks a possible work-around is using a memory mounted drive, see this answer.

Improve this question
1
  • Why not using a file-based db? I suppose you can use memory mapping, if necessary. Commented Sep 5, 2022 at 18:50
Related questions
21
sharing a :memory: database between different threads in python using sqlite3 package
6
In-memory SQLite database shared by multiple processes
33
Can two processes access in-memory (:memory:) sqlite database concurrently?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.