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

$250-750 USD

Closed

Posted

about 6 years ago

$250-750 USD

Paid on delivery

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

Project ID: 16805860

About the project

11 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 in 60 days

5.0

(108 reviews)

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 in 10 days

4.7

(16 reviews)

6.1

@aanvikm

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

$777 USD in 10 days

5.0

(6 reviews)

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 in 15 days

4.9

(7 reviews)

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 in 10 days