business analyst
46.1K views | +0 today
Follow
business analyst
Your new post is loading...
Your new post is loading...
Rescooped by michel verstrepen from Dev Breakthroughs
Scoop.it!

Adding Database Synchronization to Your PhoneGap Project

Adding Database Synchronization to Your PhoneGap Project | business analyst | Scoop.it

For the past few days I've been working on a proof of concept PhoneGap application that demonstrates an example of database synchronization. This is a fairly complex topic and I'm only going to demonstrate one version of this, but I hope the concepts, code, and example application are useful to people hoping to tackle the same problem.

 

Before we start digging into code, let me explain what the application will demonstrate and the type of synchronization it will use. Our sample application is going to use a built-in database for documentation. Most mobile applications don't really have a lot of documentation. Anything that complex may not make sense on mobile anyway. But for whatever reason you want to use, the application has a large set of documents stored in the database.

 

This documentation may or may not ship with the application, but we want the application to sync with a remote server in order to get the latest and greatest documentation. Our synchronization "rules" will be simple:

- If the remote server adds new docs, the app needs to get it.

- If the remote server updates existing docs, the app needs to update its copy.

- If the remote server deletes a doc, the app needs to delete its local copy.

 

In this scenario, we don't have to worry about user generated content and handling updates bidirectionally. That allows us to simplify things quite a bit.


Via Nicolas Weil
No comment yet.
Rescooped by michel verstrepen from Dev Breakthroughs
Scoop.it!

How Twitter Stores 250 Million Tweets a Day Using MySQL

How Twitter Stores 250 Million Tweets a Day Using MySQL | business analyst | Scoop.it

Jeremy Cole, a DBA Team Lead/Database Architect at Twitter, gave a really good talk at the O'Reilly MySQL conference: Big and Small Data at @Twitter, where the topic was thinking of Twitter from the data perspective.

 

One of the interesting stories he told was of the transition from Twitter's old way of storing tweets using temporal sharding, to a more distributed approach using a new tweet store called T-bird, which is built on top of Gizzard, which is built using MySQL.


Via Nicolas Weil
No comment yet.