<div>
<div class="content wysiwyg-content">
My scenario:<br />
<br />
I have many machines which stores data in local databases (sqlite).<br />
There is one `client` machine that pull data from all machines and save it to his local database for use other parts of software. Saying pull I mean that he want get some data between dates, i.e. whole day, whole month. (By the way - how it's call that scenario?)<br />
<br />
I'am struggling with choosing correct technology.<br />
<br />
Currently I making RPC with Thrift framework. It's easy to use but I don't know is it good way, because I making some replication mechanism myself.<br />
With that RPC I call function i.e &nbsp;GetNewData(Revision). And I get all new tables data. Then I save it to client's database.<br />
<br />
Other idea was use MongoDB or CouchDB with replication (i don't know if these databases can by setup like in my scenario).<br />
<br />
Other idea was to save Sqlite database to file, download it and merge. Or save only new record and merge. It is simple, and because it is simple I'am afraid that I will be closed for future extensions. <br />
<br />
I need some advice and discussion.
</div>
</div>


My scenario:

I have many machines which stores data in local databases (sqlite).
There is one `client` machine that pull data from all machines and save it to his local database for use other parts of software. Saying pull I mean that he want get some data between dates, i.e. whole day, whole month. (By the way - how it's call that scenario?)

I'am struggling with choosing correct technology.

Currently I making RPC with Thrift framework. It's easy to use but I don't know is it good way, because I making some replication mechanism myself.
With that RPC I call function i.e  GetNewData(Revision). And I get all new tables data. Then I save it to client's database.

Other idea was use MongoDB or CouchDB with replication (i don't know if these databases can by setup like in my scenario).

Other idea was to save Sqlite database to file, download it and merge. Or save only new record and merge. It is simple, and because it is simple I'am afraid that I will be closed for future extensions. 

I need some advice and discussion.

Correct tech. for pull data from servers

Programming theory deals with the design, implementation, analysis, characterization, and classification of programming languages and their individual features, along with introductory programming concepts like program structure, variable declaration and conditional and looping constructs. Sub-disciplines include the formal semantics of programming languages, type theory, program analysis and transformation, comparative programming language analysis, metaprogramming, domain-specific languages, compiler construction and run-time systems.

Programming Theory

C++ is an intermediate-level general-purpose programming language, not to be confused with C or C#. It was developed as a set of extensions to the C programming language to improve type-safety and add support for automatic resource management, object-orientation, generic programming, and exception handling, among other features.

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

A NoSQL database provides a mechanism for storage and retrieval of data which is modeled in means other than the tabular relations used in relational databases. Motivations for this approach include: simplicity of design, simpler "horizontal" scaling to clusters of machines and finer control over availability. The data structures used by NoSQL databases (e.g. key-value, wide column, graph, or document) are specified from those used by default in relational databases, making some operations faster in NoSQL. Sometimes the data structures used by NoSQL databases are also viewed as "more flexible" than relational database tables.