Posts

Showing posts with the label share

How to share a :memory: database between different process in python using python sqlite3 package

How to share a :memory: database between different process in python using python sqlite3 package scenario is shown as below,i got many processes to do CPU-bound work and read only on the same database,i know cache and uri key words could be used for sqlite to share database cache between threads,but how about between processes?it's better to be available both for linux and windows, Thank you! def run(self): self.phyconn = apsw.Connection(self.fileName) self.memconn = apsw.Connection(":memory:") try:#backup.__exit__() just make sure copy if finished,not close backup,so with is good,memconn is still exist when out with self.memconn.backup("main", self.phyconn, "main") as backup: # call with 0 to get the total pages backup.step(0) total = backup.pagecount stepped = 0 one_percent = total if total < 100 else total // 100 last_percentage = 0 while step...

How can I share access 2013 database between users to fill a form without other accesses? [on hold]

How can I share access 2013 database between users to fill a form without other accesses? [on hold] I am a new in access 2013. I have a database with a simple form to add data to it. I want to share my form between some users to add data to it in local. I mean I want users just can fill my form without accessing other parts of program and data that they entered in my form save in my database just like a form in a site. If it is possible, how can I do it? Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question. Welcome to Stack Overflow! This is a site where programmers write their own code and share issues with a specific problem after trying to solve it on their own. If, after doing more research , y...