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
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
> 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
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
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.
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
> > 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
7 matches
Mail list logo