views:

53

answers:

2

Consider the client application that should store its data on remote server. We do not want it to access this data "on-fly", but rather want it to have a copy of this data in local database. So we do not need connection with remote server to use application. Eventually we want to sync local database with remote server. The good example of what I am talking about is Evernote service. This type of applications is very common, for instance, in mobile development, where user is not guaranteed to have permanent Internet connection, bandwidth is limited and traffic can be expensive.

ORM (object relational mapping) solutions generally allows developer to define some intermediate "model" for his business logic data. And then work with it as some object hierarchy in his programming language, having the ability to store it relational database.

Why not to add to an ORM system a feature that will allow automatic synchronization of two databases (client and server), that share the same data model? This would simplify developing the applications of the type I described above. Is there any systems for any platform or language that have this or similar feature implemented?

+1  A: 

this links may provide some useful information

http://gwtsandbox.com/?q=node/34

http://www.urielkatz.com/archive/detail/google-gears-orm-v01/

http://www.urielkatz.com/archive/detail/google-gears-orm/

Anantha Kumaran
Hm, as far as I can see this is just for storing client-side local data. No sync with server functionality. Am I wrong?
Wicharek
+1  A: 

AFAIK, there are no such ORM tools.

It was one of original goals of our team (I'm one of DataObjects.Net developers), but this feature is still not implemented. Likely, we'll start working on database sync this spring, but since almost nothing is done yet, there is no exact deadline for this.

Alex Yakunin