Re: Re: SQL Development
Re: Re: SQL Development
- Subject: Re: Re: SQL Development
- From: Ted Thibodeau Jr <email@hidden>
- Date: Fri, 22 Sep 2006 15:34:02 -0400
*** On Sep 22, 2006, at 10:17 AM, Jaime Rios wrote:
>>> Hi folks,Does anyone have any suggestions for third party
>>> utilities that allow an Obj-C Cocoa application connect to
>>> a SQL server? Thanks in advance!
I'm guessing you meant Microsoft SQL Server, here?
** On 9/22/06, Michael Jurewitz <email@hidden> wrote:
>> You should take a look at http://cocoamysql.sourceforge.net/
>> (specifically the open source framework they use for connecting
>> their Cocoa app to a MySQL db).
* Jaime Rios [2006/09/22 01:54 PM -0400] wrote:
> I guess if I want support for PostgreSQL, I'll have to make my
> own C to Obj-C API. Fortunatly for me, I found out that Sybase
> is completly supporting Mac OS X!
Why bind yourself to a single database?
ODBC is accessible from Obj-C, either by bridging to the old-style
dylibs shipped by Apple, or by using the Frameworks installed with
the precompiled iODBC SDK or any ODBC Driver from OpenLink (we are
the supporters and maintainers of the open source iODBC project,
from which the dylib build originated), discussed here --
http://docs.openlinksw.com/mt/iodbcappsmacos.html
You can build your own copy of the Frameworks from the source, which
you can get from iODBC.org or the Sourceforge project page.
http://www.iodbc.org/
http://sourceforge.net/projects/iodbc
If you really like the CocoaMySQL kit referenced above, you might
want to build it with links to the MySQL-2-ODBC open source bridge
we put together some years ago. You can then code as if you are
working against MySQL, and the end result will be able to work
against any ODBC-accessible target, including but no longer
limited to MySQL.
http://sourceforge.net/projects/mysql2odbc
Once you've got ODBC connectivity in your app, you can choose to
use an ODBC Driver from OpenLink Software, the DBMS vendor, or
whatever third party makes you happy. I do recommend that you
make use of OpenLink ODBC Bench, another open source project,
to compare the drivers in your own environment, so you can see
just which one really does deliver the best bang --
http://sourceforge.net/projects/odbc-bench
Inspired by TPC-A and TPC-C suites, this tool simulates these
benchmark suites on simple workstations, allowing you to compare
DSN configurations, ODBC Drivers, backend DBMS, and hosting OS,
on your own infrastructure. Obviously, as open source, you can
inspect the tests to ensure there's no bias in favor of any DBMS
or driver, and you can extend and modify the tests to suit your
own specific needs, as desired.
Be seeing you,
Ted
--
A: Yes. http://www.guckes.net/faq/attribution.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:email@hidden
OpenLink Software, Inc. // http://www.openlinksw.com/
http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/
http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden