Timeline for Data Synchronization in mobile apps - multiple devices, multiple users
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 30, 2013 at 14:56 | comment | added | Sebastian | @ProgrammerNewbie: Relational data itself makes the matter of synchronization and concurrency all the more difficult. Try to partition your data in a way that allows you to separate the truly concurrent items from the rest, so that you can deal with them separately. In CouchDb, it is advisable to use flat hierarchies because revisions are managed on a document basis. Nesting two or more object levels in one document means you lose control over which change/revision concerned which object/change. | |
| Jul 29, 2013 at 21:56 | comment | added | ProgrammerNewbie | @Sebastian - I'm just not familiar with NoSQL, so I'm wondering if I still need an RDBMS for my relational data. | |
| Jul 29, 2013 at 15:31 | comment | added | David V | @ProgrammerNewbie, It sounds like your plan is generally good: have an API abstracting from the database. CouchDB sort of does this, but you aren't entirely abstracted from the fact that it is CouchDB. Regarding your second question, I don't know why you need an RDBMS either. CouchDB provides map/reduce views for providing queries on the data, filters, change tracking, and much more. | |
| Jul 29, 2013 at 8:42 | comment | added | Sebastian | Please specify your "need for a RDBMS". What does it provide that CouchDb does not? CouchDb is a NoSQL database, so you wouldn't need an additional MySQL. On top of it, CouchDb can get you a long way without a middle tier as you can intercept the API calls using JavaScript and build your output with views. | |
| Jul 28, 2013 at 19:31 | comment | added | ProgrammerNewbie | Also, I'm now looking at CouchDB. Would I build the application using only CouchDB? Or would I still use something like MySQL in conjunction with CouchDB? For example, the application will still have some basic need for a RDBMS. Do I model that kind of data in MySQL and then put the data that requires synchronization in CouchDB? | |
| Jul 28, 2013 at 19:29 | comment | added | ProgrammerNewbie | My plan for the API was to implement a RESTful API using CodeIgniter, which would interact with whatever DB solution was necessary. I wasn't thinking of using a DB system that had a built in API. Does my plan disagree with your answer? | |
| Jul 28, 2013 at 17:22 | history | edited | David V | CC BY-SA 3.0 |
added a note about background sync
|
| Jul 28, 2013 at 17:15 | history | answered | David V | CC BY-SA 3.0 |