Re: Core Data with ODBC databases?
Re: Core Data with ODBC databases?
- Subject: Re: Core Data with ODBC databases?
- From: Andrew Satori <email@hidden>
- Date: Wed, 16 Oct 2013 10:20:14 -0400
Oh, I've got a rudimentary ODBC ORM sitting in my private SVN repo, but I elected to not publish it because while it handles PostgreSQL and MSSQL alright, it doesn't do MySQL, Oracle, FrontBase, MS Access, etc very well at all. The vague nature of what is behind an ODBC data source means that each backend ODBC driver needs a front end adapter to deal with the idiomatic syntax and behavior differences. My conclusion is that in this day and age, the cost of upkeep and support so far outweighs the potential revenue that it was a project best left unreleased (and before anyone screams Open Source, I already maintain PGSQLKit, PGSQL for Mac, and ODBCKit as OSS. There aren't enough people willing to actually contribute money or work to these types of projects to justify it).
Don't misunderstand my comments as being negative on ODBC, I use it every single day, and I push it hard. But at the end of the day, it is an abstraction layer, and adding another in the form and an ORM just isn't a great idea (IMO) that factored into the demise of Enterprise Objects.
Dru
On Oct 16, 2013, at 9:56 AM, Jens Alfke <email@hidden> wrote:
>
> On Oct 16, 2013, at 6:14 AM, Andrew Satori <email@hidden> wrote:
>
>> I'd like to take this a step further. CoreData is a really nice tool, but CoreData really isn't the tool for using a multi-user RDMS since it skips over some of the frequently forgotten concepts like locking and data concurrency.
>
> Also, CoreData’s SQL schema is highly opaque. You can’t use CoreData to access a normal existing SQL database (it won’t recognize the schema), and a SQL database created by CoreData is going to have a lot of weird-looking tables that you really shouldn’t access using anything else but CoreData.
>
> Again, CoreData is _not_ an ORM. I don’t actually know of any Cocoa-based ORM library for ODBC, but by this point it’s likely that someone somewhere has written one. (There’s a new one by Marco Arment for SQLite, whose name I forget, but it only works with SQLite so it’s probably not useful for the OP.)
>
> —Jens
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden