Sqlite to Sqlite (Sync two-way) c# UWP App used

$250-750 USD

Mbyllur

Postuar

almost 6 years ago

$250-750 USD

Paguhet në dorëzim

We would like to have a two way sync, between multiple databases over network. So If i have four pc, i want them to be able to add, edit and delete their own data and the data from the other sqlite databases. They all have a local sqlite database where a c# uwp app UI is running and handling all the CRUD. - If machine 1 is adding data, the data should appear on machine 2,3 and 4 as close to instantly (running local network) - if machine 1 has open to edit record, and 2,3 or 4 is trying, there should be a indication for not possible, it is already being edited (so we can pull this data to the uwp c# app and show message) - if machine 2 edits record, and machine 1 after machine 2 edits again. should not lose track of which order to update on all 4 machines. - If machine 1 goes offline but has added records, when it comes online it will send/upload to machine 2,3,4 and vice versa, all data on 2,3,4 will be added/edited,deleted on machine 1 (if record deleted on other machines and machine 1 has edited it, then check which is newest and perform that command) It is important, that all tables are available on all machines meaning, if table,record is added,edited or deleted, it will perfom changes on all machines. Prefer c# app, but if any other suggestions, we are have a dialog about this.

Android

C# Programming

C++ Programming

Mobile App Development

SQLite

ID e Projektit: 16805860

Rreth projektit

11 propozime

Projekt në distancë

Aktive 6 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

11 freelancers are bidding on average $645 USD for this job

@amusto

Hi, it is not an easy task, and I completely aware about data sync because I already manage data synchronizathion between applications based on MS SQL Server. What are you asking, mainly for point 2 "f machine 1 has open to edit record, and 2,3 or 4 is trying...", is quite impossible to achieve because an istantaneus synch is almost impossible. Furthermore each UWP app should now exatcly where the other apps are located to to physically update they SQLITE instances. This means that you need to amange a connection strings register somewhere, for example a sgared folder where each app can have access. If you are using the UWP apps inside a local network, my suggestion is to use a shared db. You could try keeping the SQLITE instance, but I would prefer to use more strong db like SQL SERVER. In this way you need only to manage data consistency as you prefer. REgards, Armado

$1 666 USD në 60 ditë

5,0

(108 përshtypje)

8,0

@Websitemaestro

Hi, I can definitely help you with two way synchronize . I am a full time developer working "8 hours a day" 40 hours per week. Lets discuss the project further on chat before start. Thanks

$388 USD në 10 ditë

4,7

(16 përshtypje)

6,1

@aanvikm

Hello Sir, I would like to discuss more about this project. I am an expert in c#. Thanks Aanvik

$777 USD në 10 ditë

5,0

(6 përshtypje)

5,5

@XpaMoBHuk

This is not a trivial task. There will be conflicts and deadlocks anyway, say node1 is offline, deleted a record, node2 updated the same records 1 min after, then after than node1 comes back online. What should happen with the record? Can these nodes see each other by local network? How many tables needs to be synced? This seems to me like a messaging system, when something changes the data, it posts it at the same time into the message queue or bus, and this is how other nodes can see what needs to be done. These messages are strongly ordered, so this requirement will be fulfilled. But offlined nodes will produce a deadlocks, I think. Whatever, I'm C# .Net consultant with over 18+ years on the market. I can allocate 20 hours per week for this task. I'm English speaking, located in Sydney, opened for a Skype chat. Feel free to contact me if interested.

$700 USD në 15 ditë

4,9

(7 përshtypje)

4,5

@Khalid302

Hello, I came across your project and I think the best way to do it would be to have a log table with a timestamp in all four databases which the respective machines will use to propagate events to other machines. This option guarantees the preservance of the updates during offline periods or even crashes. I recently finished a C# desktop applications that synchronizes an access database with a MySQL database for a website and re-reads the MySQL edits into the access database. I think that my experience in this particular realm is relevant to your project. Looking forward to your response. Thank you!

$400 USD në 10 ditë