StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>Core Data:</strong></p> <ol> <li><p>Primary function is graph management (although reading and writing to disk is an important supporting feature)</p></li> <li><p>Operates on objects stored in memory (although they can be lazily loaded from disk)</p></li> <li><p>Works with fully-fledged objects that self-manage a lot of their behavior and can be subclassed and customized for further behaviors</p></li> <li><p>Non-transactional, single threaded, single user (unless you create an entire abstraction around Core Data which provides these things)</p></li> <li><p>Only operates in memory</p></li> <li><p>Requires a save process</p></li> <li><p>Can create millions of new objects in-memory very quickly (although saving these objects will be slow)</p></li> <li><p>Leaves data constraints to the business logic side of the program</p></li> </ol> <p><strong>Database or SQLite:</strong></p> <ol> <li><p>Primary function is storing and fetching data</p></li> <li><p>Operates on data stored on disk (or minimally and incrementally loaded)</p></li> <li><p>Stores "dumb" data</p></li> <li><p>Can be transactional, thread-safe, multi-user</p></li> <li><p>Can drop tables and edit data without loading into memory</p></li> <li><p>Perpetually saved to disk (and often crash resilient)</p></li> <li><p>Can be slow to create millions of new rows</p></li> <li><p>Offers data constraints like "unique" keys</p></li> </ol> <p>Referred from below link <a href="http://cocoawithlove.com/2010/02/differences-between-core-data-and.html" rel="nofollow">http://cocoawithlove.com/2010/02/differences-between-core-data-and.html</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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