4 ms·

I'm not sure I'd call this a Core Data alternative, as it seems closer to a few convenience methods around SQLite. I'd imagine that using this for presenting d

I'm not sure I'd call this a Core Data alternative, as it seems closer to a few convenience methods around SQLite. I'd imagine that using this for presenting data in any kind of table view (a typical use for a local data store) could be extremely frustrating as it wouldn't do any of the progressive loading, caching or change notification that Core Data gives you. Core Data can be a pain to work with, but when you do it right, it has some extremely nice features - stuff that you absolutely need in a performant, stable app that handles data at a scale of anything more than a few dozen records. Also, looks like we've got some cat references (from the demo) in the library's own code, so I'm not sure whether the demo was created to demonstrate the library, or the library was a rushed abstraction of the cat project :) Edit: https://github.com/zniazi/SnapIt/blob/86f1ec45e6493c3fc9fd4d01e76d51095b5eb200/Pod/Classes/SnapIt.m#L271 https://github.com/zniazi/SnapIt/blob/86f1ec45e6493c3fc9fd4d... I would absolutely not recommend this for use in any kind of real-world app. From what I can tell, there is no attempt whatsoever to sanitize or parameterize SQL statements.

zniazi 12y ago
You are right in that NSFetchedResultsController is a nice feature of using Core Data with TableViews, but the functionality is not difficult to write on your own. As you insert or update data, call [tableView reloadData]. You may not want to reload each cell for one insert in which case you can do something a bit more custom. And yeah, there is a reference to catsDB. I thought people may find that funny if they ever looked into the implementation. The work is derived from a blog post I wrote a while back to demonstrate connecting to a SQL instance in Objective C.
zniazi 12y ago
Sanitization can be added pretty easily, but I will ask you this. Who will the user of your app be hurting if they do a SQL injection attack? They will be destroying data on their own phone.

zniazi 12y ago

You are right in that NSFetchedResultsController is a nice feature of using Core Data with TableViews, but the functionality is not difficult to write on your own. As you insert or update data, call [tableView reloadData]. You may not want to reload each cell for one insert in which case you can do something a bit more custom. And yeah, there is a reference to catsDB. I thought people may find that funny if they ever looked into the implementation. The work is derived from a blog post I wrote a while back to demonstrate connecting to a SQL instance in Objective C.

zniazi 12y ago

Sanitization can be added pretty easily, but I will ask you this. Who will the user of your app be hurting if they do a SQL injection attack? They will be destroying data on their own phone.