Sqlite alternative for iPhone [monotouch]

Question

As the name says.

I find that many problems are related to the lack of thread safety in the Sqlite shell needed to use Sqlite with Monotouch, so the question is, is there an alternative? There must be something !!?

w: //

Answer 1

Sqlite itself is not thread safe, so you need to manually block it whenever you intend to access the database. You can see how I did it with TweetStation:

http://github.com/migueldeicaza/TweetStation/

This allows me to update the database in the background.

Sqlite : sqlite-net, Sqlite Mono.Data.Sqlite.

CoreData, , , .

Answer 2

iOS 4 sqlite3_config (SQLITE_CONFIG_SERIALIZED) Sqlite3 #:

    var result = SQLite3.Config(SQLite3.ConfigOption.Serialized);
    if (result != SQLite3.Result.OK)
    {
        throw new InvalidProgramException("sqlite3 refused Serialized option");
    }