Find Jobs
Hire Freelancers

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

$250-750 USD

Zavřený
Zveřejněno skoro před 6 roky

$250-750 USD

Zaplaceno při doručení
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.
IČ projektu: 16805860

O projektu

11 nabídky
Vzdálený projekt
Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
11 freelanceři nabízejí v průměru $645 USD za tuto práci
Avatar uživatele
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 v 60 dnech
5,0 (108 recenze)
8,0
8,0
Avatar uživatele
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 v 10 dnech
4,7 (16 recenze)
6,1
6,1
Avatar uživatele
Hello Sir, I would like to discuss more about this project. I am an expert in c#. Thanks Aanvik
$777 USD v 10 dnech
5,0 (6 recenze)
5,5
5,5
Avatar uživatele
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 v 15 dnech
4,9 (7 recenze)
4,5
4,5
Avatar uživatele
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 v 10 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
A proposal has not yet been provided
$555 USD v 3 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z DENMARK
Denmark
0,0
0
Členem od dub 27, 2018

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.