From: Phillip Gawlowski <cmdjackryan@...>
Date: 2008-04-17T00:57:41+09:00
Subject: Re: Is there a One True Postgres interface? Is   Ruby-postgresmaintained?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thomas Kellerer wrote:

| This is not want I meant. It's the driver that provides the JDBC API to
| the application. This is true for all 100% Java JDBC drivers. (e.g. the
| Oracle, SQL Server, MySQL).

http://java.sun.com/products/jdbc/overview.html

"JDBC Architecture
The JDBC API contains two major sets of interfaces: the first is the
JDBC API for application writers, and the second is the lower-level JDBC
driver API for driver writers."

Later on:

"Included in the Java Platform
As a core part of the Java 2 Platform, the JDBC API is available
anywhere that the platform is. This means that your applications can
truly write database applications once and access data anywhere. The
JDBC API is included in both the Java 2 Platform, Standard Edition
(J2SE) and the Java 2 Platform, Enterprise Edition (J2EE), providing
server-side functionality for industrial strength scalability."

In short: The driver talks to the DB, hooking Java and the DB together
via the JDBC API. ODBC works similar (much less well, though, IME).

|
| I'm a complete newbie with Ruby, but from what I have seen, I would be
| very surprised if it wasn't possible to implement a pure Ruby
| implementation to communicate with a Postgres backend. How much work
| that would be, is probably another question though.

Needs an API, though. And that needs working with Ruby's C code first,
to "teach" the Ruby language basic functionality (or to enable adapters
in a coherent manner).

JDBC allows agnostic access to Databases. Theoretically, any way.
Similar to Sequel, DataMapper, or ActiveRecord in the Ruby space.

It does work, but it is not unified, much less standardized.

- --
Phillip Gawlowski
Twitter: twitter.com/cynicalryan

YUPPIES: <Y>es, <U>nder <P>eer <P>ressure <I>'ll
~  <E>at <S>hit
~ -- Chris Squire
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkgGIeQACgkQbtAgaoJTgL9HhQCbBIXfYBh4SvnrWX8vU93MlycH
JR4An2I46T0Vx2BxbwvRvzwbdjBVMaSA
=9aq0
-----END PGP SIGNATURE-----