Re: HELP! - Database questions
Re: HELP! - Database questions
- Subject: Re: HELP! - Database questions
- From: Ted Thibodeau Jr <email@hidden>
- Date: Fri, 7 Mar 2008 15:05:30 -0500
Hi, Jeff --
* Jeff Brown [2008/03/07 09:05 PM +1100] wrote:
> something a bit more Mac related and so am looking for
> a SQL database that allows me to connect easily using
> Cocoa.
>
> I also need to be able to use SQL queries with it
> directly since that is how my app is already set up -
> (SELECT, UPDATE and DELETE)
>
> The options I've seen are:
> 1. Core Data - which is good because it ships with
> XCode BUT it doesn't appear to allow me to use SQL
> directly? Also is it possible to use Core Data as a
> client/server on a local network with a maximum of 10
> clients writing to the database only occasionally?
> 2. SQLite - BUT can it act as a server where it
> resides on one machine and I can log into it from
> another on a local network - I need to be able to do
> this.
> 3. FrontBase
>
>>From users' experience which of these provides the
> best option?
I'd recommend omething more generic -- like ODBC -- which means
you'll never be bound to a particular DBMS in the future.
The open source iODBC [1] SDK, downloadable in precompiled form
including source [2] from OpenLink Software (sponsors and my
employer) , or as source only [3] from SourceForge, delivers
a full set of Frameworks as well as the traditional dylibs.
(iODBC runtime has been included in Mac OS X since Jaguar, but
the version shipped by Apple is typically one or more dot-revs
behind the current, and there has generally been one or more
significant bugs left in the Apple-shipped version for months
or years after patches landed in the official downloads.)
ODBC delivers all the functionality you would expect from a DBMS
native connection API, but if used properly the application can
be run against any DBMS.
DBMS-specific extensions to ANSI SQL and DBMS-native SQL dialect
can be used, but this means your application remains bound to
that specific back-end, *or* you must write multiple case-handlers
such that relocation is possible. Still, adjusting these over
time is typically less effort than rewriting an entire app to
use a different DBMS-specific client API.
Hope this helps,
Ted
[1] http://iodbc.org/
[2]
'http://download.openlinksw.com/download/login.vsp?pfam=7&pform=1&pcat=18&prod=iodbc-sdk&os=universal-apple-macosx10.4-32&release-dbms=6.1-nodb&proceed=Next+>'
[3] http://sf.net/projects/iodbc
--
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.
Xcode-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden