From: "Jukka Zitting" <[EMAIL PROTECTED]>
> Gene Sokolov responded to ODBC as a DB independence layer:
> > I was thinking more in terms of defining a set of
> > db-functions "the midgard way". I.e. an interface most
> > suitable for midgard needs. And then mapping those calls
> > to native db libraries or odbc calls. Making odbc the
> > default db interface would certainly hurt performance.
>
> The main point behind using ODBC and not a homegrown database
> abstraction layer is to make the project more modular and standard's
> conforming. Using available standards and implementations saves us from
> the trouble of designing, implementing, documenting and maintaining
> them.
Perl has DBI/DBD, Java has JDBC, PHP supports everything. If you go with
generic ODBC, then you have three tier midgard->odbc->native. If you write
for a layer which is best for midgard, you get just two layers
midgard->native. ODBC could be one of those "native" libraries. You could
even implement it first. But if you support odbc only, you would seriously
sacrifice performance. Besides, odbc comes from MSWindows realm. You can't
always find appropriate odbc drivers on unix platforms. They are also often
expensive.
> The problem with ODBC is that it's quite heavy and slow when used the
> way "Broken Shinai" does. The Midgard 2 architecture is more optimized
> for ODBC (and any other generic db layer...).
2.0 could be a solution to all problems. Unfortunately, latest weekly
summary sais "development of 2.0 has halted". So, let's just assume it won't
come out.
> If someone knows a stable, widely-used and fast generic database
> abstraction layer, then such a product could be used for our needs.
I understand that midgard would not need a library, just a db interface
definition. You could even say that the interface is libmysql (or whatever
it's called). Then how about PHP? It supports a large number of databases in
a reasonably consistent way. Midgard would probably need just a limited
subset of these functions.
Gene Sokolov.
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
