Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The iPhone directory app can be used to store data in any format you want (xml, json or a proprietary format), because all you do is save a file. But if you choose to use the iPhone app directory to store data you have to write code to read the file (very simple to do) and parse the information (not so simple because the dificulty scales based on the information complexity).</p> <p>SQLite is a tool to store structured data, providing you a set of tools to access and use the information. You don't need to parse the information, because SQLite does it for you by using transact sql queries.</p> <p>By now, because you have a list of individuals, and these people are relationed to offices, I think you should use SQLite.</p> <p>The Code Data is a object graph management, it's a tool to give you more options over data manipulation, and can make your life very easy if you have a lot of data and very complex data models. I don't think you need that for your particular problem, but I think you should learn it at some point.</p> <p><strong>UPDATE 1</strong></p> <p>You application will have something like:</p> <p>A core database (sql server, oracle, my sql, etc) will hold your individuals information (your cloud database).</p> <p>A web page (php, asp.net, etc) will display the core database information in json or xml format (your api).</p> <p>A iphone app will download the information from the web page and store it in the local SQLite. (you have to decide when you will update the local sql lite, like when is opened, once a week, once a moth, twice a day, etc) (your local storage method).</p> <p>Display the local SQLite individuals information in the app.</p>
    singulars
    1. This table or related slice is empty.
    1. POXcode iOS phone directory app. core data, sql lite, or
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USlolol
    1. USlolol
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POXcode iOS phone directory app. core data, sql lite, or
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you for taking the time to answer my question. So if I used SQLite, could I say..create a database that I can edit, and everyone who has the app will see the reflections? Ive been digging and the more I dig the more I get overwhelmed (new to database managament). Ive come across people mentioning the app connecting to a web API, which I am not familiar with.
      singulars
      1. PO
      1. USscniro
    2. COplease see my update
      singulars
      1. PO
      1. USlolol
    3. CODidn't read this update, removing my answer then.
      singulars
      1. PO
      1. US8vius
 

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