How sync data to a SQL server in multi-tenant setup from local sqlite

Question

I have a scenario where N clients connect to a central server (PostGres based). All of the N clients can get offline, and store everything in sqlite database. Is a service like fresh books, to make invoices.

Each client have a local copy of the main data (customers, products) filtered for that user. All client can update customers, products and each one work for their own invoices (i.e.: each client edit only his own invoices, but see aggregated data for everyone).

I know about add timestamp and GUID IDs, but not how approach this task. About how detect conflicts and auto-solve it, or if exist a sample code I can look about this..

P.D: Only sqlite is fixed. Because I'm in the planning stage, I could switch to any tech necessary that could solve better this task... I'm work with .net, python, django, obj-c

JuneT · Accepted Answer · 2011-08-26 02:05:01Z

1

have a look at Sync Framework. although in your case, you may have to write a custom provider to work with the non-MS databases.

here's a sample using PostGres: InfoQ: Making Microsoft Sync Framework work with PostgreSql.

some links to Sync Framework to give you an idea how it works:

Synchronizing SQL Server and SQL Express

How to: Handle Data Conflicts and Errors for Database Synchronization (SQL Server)

Synchronizing Other ADO.NET Compatible Databases

Offline-Only Scenarios

How to: Use a Custom Change Tracking System

answered Aug 26, 2011 at 2:05

JuneT

7,7802 gold badges17 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How sync data to a SQL server in multi-tenant setup from local sqlite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related