Mac Geekery

I do not know how many have used it, but having a ‘framework’ for Cocoa that supported the same basic features as ADO.NET would be an incredibly powerful tool. I am not a big fan of MS software, but SQL Server, .NET and ADO are about the only things out of that company that I admire. I have worked with all of them extensively, and they are excellent tools.

There are times when one needs to be able to do much more than the relatively simple access defined in the two sample project discussed here. Perhaps I am missing something, but there are some relatively simple things that I simply cannot figure out. Most of these requirements are based on the processing required to manage a schedule and game results for a Little leagie baseball season (the comments would apply to managing most team sport schedules). 1. How can I import data from a file, parse it, and add it to my database? 2. Note that in the above, one input record may create three datanase records (visiting team, home team and the game itself). 3. Displaying, entering scores and saving the information is relatively simple, as shown in your examples. 4. How do I scan the contents of the [Games] table and generate [Standings] records in another table? I need to keep track of several statistics for each team (number of wins, ties and losses against each of the other teams, so this table is [TeamID, OpponentID, Wins, Ties, Losses, BonusPoints], where the bonus points are assigned based on varius rules to break ties in the standings. 5. The initial contents of the [Standings] table are generated with some standard (albeit complex) SQL, but the remainder requies several passes through the data. 6. I need to be able to make a pass through the data and generate an HTML file for inclusion on a web site so participants can see the results.

Very few of these issues were addressed in the two sample projects, and I have not been able to find information in the Apple documentation that assists me in answering the questions. Nor does there seem to be any generic framework/interface for accessing a SQL (relational) database directly. Yes, I could code to the C interface for MySQL or SQLite directly, but: that is not an object oriented approach (non-Cocoa) or even C++; and it requires custom coding for each database, making it hard to switch.