Recommended resources for learning database development with Cocoa

cocoadatabaseoraclereferencesybase

I am currently learning Cocoa. However I am coming from a traditional Sybase/Oracle background using Powerbuilder. Having been spoiled by the 'power' of a datawindow for may years, I not sure that coredata or sqllite will satisfy my needs and ideas.
Basically I'm looking for some good reference sites, books, or just plain old advice on how to approach database development with Cocoa.
Any comments and advice are welcomed.

Best Answer

This is a pretty broad topic, but if you want to go down the Core Data route, check out this book http://pragprog.com/titles/mzcd/core-data Core Data published by Pragmatic.

Core Data is a persistence solution that is highly object oriented and integrated with cocoa. In my opinion it is relatively easy to implement basic persistence with it.

Marcus Zarra, the author of the book I recommended also has a great Cocoa blog with lots of Core Data resources: http://www.cimgf.com/category/core-data/

Related Solutions

List of standard lengths for database fields

I just queried my database with millions of customers in the USA.

The maximum first name length was 46. I go with 50. (Of course, only 500 of those were over 25, and they were all cases where data imports resulted in extra junk winding up in that field.)
Last name was similar to first name.
Email addresses maxed out at 62 characters. Most of the longer ones were actually lists of email addresses separated by semicolons.
Street address maxes out at 95 characters. The long ones were all valid.
Max city length was 35.

This should be a decent statistical spread for people in the US. If you have localization to consider, the numbers could vary significantly.

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

There are a few steps to see the tables in an SQLite database:

List the tables in your database:
```
.tables
```
List how the table looks:
```
.schema tablename
```
Print the entire table:
```
SELECT * FROM tablename;
```
List all of the available SQLite prompt commands:
```
.help
```

Best Answer

Related Solutions

List of standard lengths for database fields

Sql – How to list the tables in a SQLite database file that was opened with ATTACH

Related Topic