[sqlite] Newbie --question about multiple PCs accessing sqlite

2004-05-19 Thread shamil_daghestani
I'm contemplating using the TCL binding of sqlite, but the database is to be located in a shared folder and about 100 users will be accessing it for read/write purposes. I would like to take some time to learn as much as possible to safeguard the database from getting corrupt due to sever

Re: [sqlite] runtime detect of THREADSAFE

2004-05-19 Thread Peter
Stefano Barbato wrote: is there a way to detect at runtime if the sqlite library has been compiled with the THREADSAFE=1 flag or not? No, or not that I know of. It would be nice for ver 3 to have a simple function which returns a structure of the database library capabilities. The obvious ones w

Re: [sqlite] Newbie --question about multiple PCs accessing sqlite

2004-05-19 Thread Mitchell Vincent
> I'm contemplating using the TCL binding of sqlite, but the database is to > be located in a shared folder and about 100 users will be accessing it for > read/write purposes. I would like to take some time to learn as much as > possible to safeguard the database from getting corrupt due

[sqlite] runtime detect of THREADSAFE

2004-05-19 Thread Stefano Barbato
Hi, I already tried to find the aswer on the faq/wiki/mailing list archive/google with no luck so here is my question: is there a way to detect at runtime if the sqlite library has been compiled with the THREADSAFE=1 flag or not? I need thread-safeness turned on and I would like to test for it

Re: [sqlite] Re: Life of a cursor

2004-05-19 Thread Tito Ciuro
Hello again, All these answers are client/server related and very informative, but the original question is still in the open. In SQLite's case, let's assume I want to make a wrapper which add some functionality and simplifies some features. I create a cursor which contains a copy of the data.

RE: [sqlite] Re: Life of a cursor

2004-05-19 Thread Fred Williams
What George described is exactly how client-server is implemented using Borland's development products. The result set is "cached" locally on the client. Any updates performed on the client data set must be "applied" to the server. All aspects of the entire process are controlled by the develope

Re: [sqlite] Re: Life of a cursor

2004-05-19 Thread Brass Tilde
> > After that, it's of no use to keep the database open, so it closes it. > > And sends the results obtained back to the client. > > Wow! This is the first I hear that. Wouldn't that be an expensive > operation? (opening, closing, reopening...) For an embedded database, such as SQLite, yes it wou