[quote=167977:@olivier vidal]
ok, thank you Ruslan. So Valentina Server does not replace the access mechanisms of Sqlite. If I understand correctly, if Sqlite is set in WAL mode, we will always have a writing thread at the same time that an “unlimited” number of read threads. Valentina Server adding the server side: access via a port, additional queuing mechanism.[/quote]
Well, of course we NOT going “to improve” SQLite engine.
I think it is quite good and its authors know it really better of us.
Our developer asks here, you really have so heavy-loaded cases to worry?
I mean it’s a good thing Sqlite retains its mechanism. This is reassuring.
But yes, Sqlite being open-source, if multiple threads could simultaneously write, it would bring a lot of power in this database. Sqlite can not because it is not a server and a lock is placed on the entire database. But with a server, if we could at least ask the write lock per table, that would be a big improvement. That said, actually, I have not yet reached the limits of Sqlite.