Questions on litesync

jhay006

Bernardo i see , will try this thanks

jhay006

btw ,
regarding on your below respone

Conflicts on insertions are avoided with the different row id numbering. There is no conflict resolution in place. The commands are processed in the order they reach the primary node(s)

does it mean , if client 1 and client 2 add a record on a table exactly same time but with different ID's
it will save both records ?

what about , they edit the same record example row ID number 1 with name and age , both changed it at the exact same time

client 1 changed age to 22
client 2 changed age to 23
? How will litesync treat it ?

does the last write wins ? i mean both changes successfully saved and sync at the same exact time , but i believe since its sqlite , the changes will be queued and whichever the last write will win ?

Bernardo

Yes.

Clients 1 and 2 write to the local database first, only then these changes are sent to the primary node(s) for synchronization.

If they are creating new records, then these records will have different row ids, and there is no conflict.

If they are modifying the same record using an UPDATE command, the last one to reach the primary nodes will overwrite the data send by the first one. And both nodes will end up having the content of the last node that sent the data to the primary node. So it does not matter the time in which they wrote to the record, what matters it the order in which the changes reach the primary node(s).

jhay006

okay thanks for that 🙂 ,

The last question is , how can i contribute ? since source code is only available for commercial license ,
but i want to contribute for this project , is there something i can do to contribute ?

Thanks

Bernardo

The wrappers for different programming languages are open source

You can check them here:

https://github.com/litesync
https://gitlab.com/litesync

jhay006

Bernardo

is there any update documentation for compiling the source code ? all of the wrappers included on the first line says
"First follow the instructions to compile and install LiteSync from the source code "

but this link is not found
https://gitlab.com/litesync/litesync-release

Bernardo

Only for those with a commercial license

It also says "or use the pre-compiled binaries"

jhay006

copy thanks

btw , where can i find this header ?
#include <sqlite_modern_cpp.h>

Bernardo

https://github.com/SqliteModernCpp/sqlite_modern_cpp

jhay006

Bernardo thank you , is there a way to check if litesync is disconnected from the tcp and force reconnect? , also is there a way to trigger the sync . ?

Bernardo

Nope. It is all automatic

jhay006

Bernardo sometimes it doesn't sync.
it happens on android/ios app

sync is active at first launch of the app , or a phone restart then reopen the app

but if i just close the app from its task manager, then reopen it , any changes will not sync anymore unless i close it again then reopen it will trigger the sync but any changes will not sync until i repeat the process

so what i did to resolve it temporary is when i execute an insert
i just need to close the current connection
then reconnect
then run the sql to insert it to local
then close again then reconnect after the insert query to trigger the sync function

Bernardo

I was not able to reproduce the problem
Maybe is it the Android version?
I use an old version of Android and the sample project works just fine there
I can switch between apps, the one stays in the background, and when coming back to it it is fully functional
Are you following the structure of the sample project (Java / Android Studio)?
Maybe it is something related to the "activities"

jhay006

okay im good with mobile app ,
i saw .NET there is it possible to work with ASP.net ?

Bernardo

I have no idea. I even thought it was dead.

Just note that the database connection must be kept open, it cannot be opened just for a single HTTP request and then closed. There is no enough time for initialization and synchronization on this way.

« Previous Page