Re: Database
Re: Database
- Subject: Re: Database
- From: John DeSoi <email@hidden>
- Date: Thu, 27 Jan 2005 00:56:34 -0500
On Jan 25, 2005, at 9:27 AM, Ted Thibodeau Jr wrote:
(For reasons which pass understanding, Apple didn't choose to include
the full kit, which OpenLink provided to them, and only bundled the
dylibs + headers. Further confusing the issue and the world of
users and developers, iODBC 3.0.6, which has been outdated since
before Jaguar shipped, was the version chosen -- and remains the
version Apple ships. iODBC 3.51.2 is the current build available
from the download sites for Mac OS X, with 3.52.1 coming shortly
as we gradually update builds for all platforms. If you work with
ODBC at all, or with tools which work with ODBC, please let Apple
know that you'd like to have the latest kit in both Panther and
Tiger environments!)
Unfortunately this is exactly why I try to avoid ODBC. You need to have
all the right drivers, libraries, and so on and then hope for the best
if you want to distribute something or move it to another machine. I'm
sure it is a good approach if working with multiple databases is a
requirement, but otherwise there are much better solutions.
By using such an agnostic API, which is also cross-platform, you
can build your application once, and use it long-term, recompiling
to get some platform benefits, but otherwise not worrying about the
newest versions of databases or other things.
I'm biased, but PostgreSQL runs on just about every operating system
(including Windows now with PostgreSQL 8.0). In fact, the server
protocol is well documented and it is relatively easy to build a
client/server interface using just TCP/IP sockets. Unlike most (all?)
of the other databases mentioned, PostgreSQL is free for all uses
including commercial applications.
There's lots of saying Prevayler is superior to RDBMS, restating
the same thing over and over again, but not a lot of information
about how it works, nor real-world examples.
I'd like to see some TPC-style testing comparing Prevayler to the
RDBMS paradigm, and some discussion of non-Java solutions, rather
than just the hand-waves there currently...
I think there are some uses for the idea, but not as an enterprise
database replacement.
Some work has been done in this area with Lisp.
See: http://common-lisp.net/project/cl-prevalence/
and a real-world application study:
http://homepage.mac.com/svc/RebelWithACause/
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
_______________________________________________
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
| References: | |
| | >Database (From: Carlos Coutinho <email@hidden>) |
| | >Re: Database (From: Ted Thibodeau Jr <email@hidden>) |