Jean-Pierre wrote:
> Emiliano Heyns a �crit :
>
> > Gene Sokolov wrote:
> > >
> > > I understand that Midgard does not support anything but mysql as its
primary
> > > depository and no such support is planned for 1.x branch. Since Midgard
2.0
> > > is not coming out any time soon and there is interest to add Oracle
support,
> > > it might be useful to consider an abstraction layer in 1.x for adding
other
> > > databases as well. We are using postgresql as our main database because of
> > > support for transactions and that its 7.0 version is substantially
improved
> > > both in performance and stability. What would it take to add support for
> > > postgres:
> > >
> > > 1. Port calls from mysql lib to support libpg? Are these calls isolated
in a
> > > single module or scattered throughout the code?
> > > 2. Rewrite SQL statements?
> > > 3. Anything else?
> > >
> > > Is there anything particularly difficult in adding such support? Any
> > > mysql-isms which are hard or impossible to replicate with other databases?
> >
> > Talk to Jean-Pierre about the Oracle connectivity. Chances are that he's
> > met
> > most of the hurdles by now and routed around the MySQL-specific regions.
> >
> > Emile
> >
>
> I don't know about postgres, but it cannot be worse than Oracle.
> 4 points about difficulties:
> - Oracle datatypes, 32Kbytes field doesn't exist and more than one LONG (4Mb)
> field by table is excluded
> - mysql date function conversion
> - auto_increment column
> - number of rows after a select
>
> The Midgard lib source will be ok next week.
I should point out that this Midgard library will be compatible with Midgard
1.2.5 only. There is no cross-DB rewritten midgard-lib for upcoming 1.4
(1.2.6beta2 now) because porting to Oracle was started from different source.
It will be very interesting and generally good to include DB-aware function
mapping into 1.4 at least for MySQL, PostgreSQL, Interbase (as it will be free
for Linux), and Oracle. This mapping could be hard-coded at compile stage for
first release (it is simpler and we can do this using #define-s for actual
mgd_xxx functions which will be mapped to real in-compiled DB module's ones)
and will be extended for next. But the main task is to re-organize all SQL
queries and table structure to be general.
--
Alexander
---------------------------------------------
This message was sent via BSPU MailMan server.
http://www.bspu.unibel.by/MailMan/
--
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]
