Nettalk and SQlite

[terryd]

Looking at the Sqlite database I thought it would be a good substiture for tps files in Nettalk, especially if I was able to create the databse as local to a mobile device. I like the idea of a platform independent database
However from the Clarion documentation

You can access the same SQLite file from multiple processes.  However, only one process can write to the file at the same time.  Once a process has written to any table in the SQLite database file that process is the only process that can write to any table in that database.
 
SQLite and Multithreading

SQLite is designed to be used on a single thread but he Clarion file driver overcomes this limitation as much as possible.  To make this work the driver has one limitation on usage.  Only one thread can be accessing the SQLite database while a transaction is active.  If another thread attempts to access an SQLite database and another thread is in the middle of a transaction, the non-transacting thread will wait until the transaction is completed..

As I understand it this would disqualify Sqlite from use with Nettalk unless the data was WORM. Is this correct?
I converted a small app of mine to sqlite and found in single user operation only one problem with case sensitivity of keys.

[Bruce]

Hi Terry,

>> As I understand it this would disqualify Sqlite from use with Nettalk unless the data was WORM. Is this correct?

No, that's not correct - at least not as I read it.

Basically I read it as saying that file access will be "serialized" - especially in the case of writes - so that only one write is happening at once.

Write-locks are of a pretty short duration though, so as long as the system is not over-write-heavy I would expect it to be a reasonable replacement for TPS.

The biggest problem I have with using SQLite myself right now is that FM3 does not support it yet.

cheers
Bruce

[terryd]

Thanks Bruce
Yes the fm3 limitation is a problem.