zniazi

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.

I agree, the syntax is very clean.

That's right.

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.

I would write a method to check if you have internet connection. And whenever you make a POST request to push some data to your server, check if there is internet access. If there is not, save the data locally. You can do your local save with a few lines of code using Snapit.