Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>A couple of thoughts:</p> <ol> <li><p>Apple's recommended framework is Core Data. Especially if you have a lot of data, it's probably worth familiarizing yourself with it. </p></li> <li><p>Direct SQLite programming can have its advantages, but unless you have a compelling reason to pursue it (and I don't see anything suggesting this in your question), stick with Core Data. If you do decide to use SQLite, consider using the <a href="https://github.com/ccgus/fmdb" rel="nofollow">FMDB</a> Objective-C wrapper for SQLite.</p></li> <li><p>If you're dealing with a trivial amount of data (e.g. a dozen records), Core Data is probably overkill and you could just use a property list (plist). For example, if you have downloaded your JSON into a <code>NSArray</code> or <code>NSDictionary</code>, you can then just do <code>writeToFile</code> to save it, and <code>dictionaryWithContentsOFFile</code> or <code>arrayWithContentsOfFile</code> to read it back at a future date.</p></li> <li><p>JSON is generally considered more of a mechanism for exchanging data with a server. I wouldn't be inclined to store data locally in JSON format (though you could). I'd use a plist instead.</p></li> <li><p>By the way, it's generally not advised to store the images themselves in your CoreData/SQLite database. If you have larger files, for performance reasons, we often store them in the iOS <a href="http://developer.apple.com/library/ios/documentation/FileManagement/Conceptual/FileSystemProgrammingGUide/FileSystemOverview/FileSystemOverview.html#//apple_ref/doc/uid/TP40010672-CH2-SW12" rel="nofollow">File System</a> (and save some reference to the file name in the database).</p></li> <li><p>You mention that you have seen apps that download the entire (latest version) of a database. A more sophisticated implementation (critical with larger databases) would entail downloading updates (edits, deletions, insertions) rather than the full database. For a small database, if you can get away with the solution you propose (and it certainly makes it easier), but as your app becomes more sophisticated, you will want to consider more elegant server integration.</p></li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POUpdating Database from iOS app
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRob
    1. USRob
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 Good suggestions
      singulars
      1. PO
      1. USMark Kryzhanouski
    2. COHi Rob though the question is closed as being too basic and a chance for debate. i greatly appreciate your guidance. I think i will go on with SQL / FMDB for now as the customer may port the applications at later stage to other platforms like android and windows Phone. yes certainly it needs server integration as they need to send notifications with promotional products. if any more doubts may i contact you ?
      singulars
      1. PO
      1. USiSrini
    3. COVery good. FMDB will help immensely if you're doing SQLite. If you have additional questions, I'd suggest you post a new question here on S.O. and because it will undoubtedly be more specific, less open-ended and abstract, it's less likely to be closed ;). If you don't get responses and it's related to SQLite, feel free to put a comment here with a link to the new question.
      singulars
      1. PO
      1. USRob
 

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