On Thu, Sep 25, 2008 at 2:31 PM, Gene Velazquez <[EMAIL PROTECTED]> wrote:
> Dear Google, > Thank you for looking at my issue. In-line are the answers to your response > questions. > -- > Thanks, > Gene > > > ------------------------------ > *From: *Brad Neuberg <[EMAIL PROTECTED]> > *Reply-To: *<[email protected]> > *Date: *Thu, 25 Sep 2008 14:08:49 -0700 > *To: *<[email protected]> > *Cc: *Scott Hess <[EMAIL PROTECTED]> > *Subject: *[gears-users] Re: Reading data from MS Access-concurrence the > problem > > Hi folks, I talked with Gene today by phone. He would like to use Gears > under the following scenario; I told him there might be concurrency issues > but I wanted to see if anyone else in the community had tried this: > > Gene's users have a local MS Access database on the users desktop; they > manipulate this through MS Access. Gene would like to have some of the > tables be live and also change the SQLite database that Gears would be > using. Has anyone tried something like this? > > Some questions for Gene: > > > - Do you want two-way access? I.e., does the user through the > web-browser ever change SQLite in such a way that it would need to > propagate > to Access, or are things read-only from the web side? > > > No, the communication is one-way. > > > - What technologies do you plan to do the synchronization between the > Gears SQLite database and the Access database? JavaScript running inside > the > browser won't work. > > > We are wide open to suggestions. Access can run a SQL database which may > make the process easier. > > SQLite is a single process database, so my understanding is it won't work > in this scenario. > > Is there any other way to "milk this cow?" > SQLite database files can be accessed by multiple processes concurrently. It has a multiple-reader / single-writer file locking model. The the gears database files are just SQLite database files, potentially with full-text-searchable virtual tables depending on your schema. In theory these files can be accessed 'out-of-band' of Gears so to speak, any modifications made by some other agency would be visible to Gears.Database javascript client code. Can Access be configured to store and retrieve directly to/from a SQLite database file? Or are there facilities to migrate from an access.db to a sqlite.db (and apply deltas going forward)? You'd be out there on the bleeding edge to coble a system together that relies on the names and locations of these database files. Could the entire app be browser hosted instead of having Access involved? > > > On Thu, Sep 25, 2008 at 12:54 PM, gene <[EMAIL PROTECTED]> wrote: > > > Using SQL lite the need is to be able to have live interaction with a > MS Access database on the users desktop. The Access database can be > converted to SQL if it makes the job doable. there are only six tables > from the Access database that need to be moved into the SQL lite. Is > this impossible? > > Thanks > > > > > -- > Best, > Brad > > [EMAIL PROTECTED] > >
