The other tidbit Ted doesn't mention is licensing. One of the issues
with using MySQL libraries is the licensing. MySQL's client
libraries are GPL, not LGPL and that can have some issues (depending
upon your interpretation of the license) with your own code. ODBC
abstracts you from some of those licensing concerns.
Now, I'll admit right up front that ODBC isn't perfect, but for what
it does, it does it well, and there is growing support for it on the
On Dec 26, 2006, at 9:27 PM, Ted Thibodeau Jr wrote:
Hi, Steven --
* Steven (RSAA Storage) Smith [2006/12/26 01:08 PM -0700] wrote:
Anyone have samples or url's to samples of using MySQL (I'm currently
running 5.0.21 standard) on MacOSX (10.4.8) using Cocoa? I've tried
but the link to the example files is broken and I haven't been able
to figure out the framework. I'd like to be use MySQL API's directly
from Cocoa, but would be okay to use Cocoa bundled/linked to C++ or C
API's if someone knows how or can point me in the right direction.
I can't recommend building directly to any DBMS, because that locks
you (and your customers/users) into a back-end which may not be the
best next week, month, or year -- but I would recommend looking into
ODBC, either through Andrew Satori's ODBCKit, wrapping Objective C
around the base of C/C++ --
Building to use the ODBC APIs -- especially if you use standards-
compliant SQL (rather than DBMS-specific dialects) -- can deliver an
application which can be used against any ODBC accessible DBMS, which
means end-users can use MySQL if they want, or OpenLink Virtuoso,
PostgreSQL, Oracle, Microsoft SQL Server, Sybase, Ingres, Progress,
Frontbase, Openbase, Firebird, etc. -- whatever engine suits their
overall personal or enterprise needs and goals.
Full documentation on writing ODBC applications is found in the online
ODBC Developer's Guide, hosted by Microsoft (maintainers of the spec).
This documentation is not scoped to Objective C, nor to Mac OS X, but
it covers the ODBC API in fairly exhaustive detail.
Be seeing you,
A: Yes. http://www.guckes.net/faq/
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?