I’ve been thinking a lot about Core Data recently. It supports SQLite out of the
box, and its rather scalable and fast. Main reason being sqlite3
is included on every desktop and server of OS X that has shipped
since 10.4 (Tiger).
It got me thinking about using MySQL as a data store. It will
involve work, as Core Data itself is not extensible. And if
written, will we have to embed MySQL into the application? What
kind of problems will this pose? Licensing is the least of my
worries, I’m thinking more from an application perspective.
I haven’t played with the Enterprise Objects Framework (EOF) yet,
but it allows custom SQL, and is available in WebObjects so its
probably time to take a gander. Only real problem is its not in
Core Data, thus not available in desktop applications. Then
there’s …[Read more]