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.
Jean-Pierre
--
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]
