Share in-memory database between processes sqlite

Question

It is possible [in any way, even poorly hacked solution] to share in-memory database between many processes? My application has one process that opens the in-memory database and the other are running only SELECT queries on the database.

NOTE: I need solution only for python 2.7, and btw if it matters the module I use for making new processes is multiprocessing.

So you saying there is no way to do that in SQLite? it might be big headache to move to another db because I have already writtten whole program based on that. — johndoe_asking
– johndoe_asking, Commented May 25, 2016 at 11:08
If you've written the program in a sensible way, it should be easy to switch to another SQL-based DB that uses the Python DB API. — jonrsharpe
– jonrsharpe, Commented May 25, 2016 at 11:47
Because I find out that multiprocessing fit more than threads in my application. — johndoe_asking
– johndoe_asking, Commented May 25, 2016 at 21:57

Naomi · Accepted Answer · 2016-08-18 14:06:46Z

4

On Linux you can just use /dev/shm as the file location of your sqlite.

This is a memory mounted drive suitable exactly for that.

answered Aug 18, 2016 at 14:06

Naomi

5,56626 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Navid_pdp11 Over a year ago

@johnedoe_asking do you solve your problem by using this answer?

Collectives™ on Stack Overflow

Share in-memory database between processes sqlite

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related