Databases
StackOverflow2013
Postsdbo
POOne way sync website > iPhone app using Core Data
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOne way sync website > iPhone app using Core Data
    primarykey
    data
    text
    <p>I'm building an iPhone application with a database (most likely I'll use Core Data for the first time, but it can still turn out that I'll be using SQLite depending on your answers here).</p> <p>The content of this database should be updated on a regular base from some online storage (most likely a MySQL database).</p> <p>As the initial database will be rather large it will be in the app so the user won't need to download that, the updates will be rather small so those can be downloaded. You can see that 'Delta' updates are a must (downloading the whole dataset each time is just too much data). Updates will consist of a few new records and eventually some corrections of existing records</p> <p>The local database will have a few tables/entities (with a lot of relations between them) that need to be updated, those tables/entities will be read-only (*). There will be another few tables/entities where the user can enter comments (read/write) but they never have to get updated, this is private user data. As a matter of fact I'll sometimes create an extra table with just a 1-1 relation to keeps nicely separated (dataset tables/entities versus comments tables/entities).</p> <p>Can somebody provide me with a way to generate a file online with all the changes in the db, that can be downloaded to the phone and efficiently and correctly parsed so that those changes/new records are applied. I've been thinking like something similar to the migrations Rails uses to maintain its database, but can't seem to find anything that looks clean and performant. Keeping in mind dat relations between different tables/entities is very important, that's were my inspiration is failing...</p> <p>(*) for a start read only, later on the user will be able to add records and edit them. He will never be able to edit the existing records, and his own records don't need to go back to the server.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGlenn
    1. USGlenn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POOne way sync website > iPhone app using Core Data
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POOne way sync website > iPhone app using Core Data
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POOne way sync website > iPhone app using Core Data
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload