I'm wanting to interface programmatically with a # of relational
databases like mysql. What would you guys recommend for being
compaitable with the main line medium size databases as a common
interface to them?

Thanks,

On 2010-11-29 05:13, Joe wrote:
I'm not sure I understand your question. Are you looking for something
instead of sql, or something on top of sql?

I don't think anything will replace sql for many years. On top of sql
there are a number of frameworks, but these are dependent on your host
language so it is a bit difficult to give any advise in this regard.

/Lennart

Joe <no.respond (AT) invalid (DOT) email> wrote:

This depends on your coice of programming language. For Java there
is JDBC. For Perl there is DBI. For C++ there are abstraction layers
in several class libraries (i.e. Qt has QSqlDatabase). PHP comes
with several abstraction layers: DBA, dbx, PDO.
etc. pp.

In the Windoze world there is ODBC as a freestanding abstraction
layer (programming language independent). And finally I remember
SQL Relay as supporting a range of backend SQL DBMSes
(http://sqlrelay.sourceforge.net/)

Some of those are just a thin layer (DBI, JDBC) adding little more
than syntactic sugar. Others come with more penalties. I.e. ODBC
has a rather bad reputation.

All those interfaces are below the SQL layer. So you still have to
write your SQL statements in a way that is compatible with all the
backend DBMSes you plan to use.


XL

Michael Vilain wrote: