Re: [Webware-devel] PostgreSQL support for MiddleKit

[<dru...@re...>]

Good stuff!

On Mon, 3 Jun 2002, Ingo Luetkebohle wrote:

> Hi,
>
> attached is a patch against MiddleKit to provide preliminary support
> for PostgreSQL.  We are using the patch locally, it seems to work
> just fine.  Its a bit unpolished but, well,... here it is :-)
>
> Known issues:
> 	- sample data not supported
> 	- requires a patch against the PostgreSQL python bindings
> 	  (only 7.2+ supported)
>
> The reason that a patch against the PostgreSQL python bindings is required
> is that MiddleKit makes uses of a database-assigned ID for newly
> inserted database objects.  It retrieves this through a MySQL-specific
> server function.  Postgres has an equivalent in the 'C' glue for its
> binding but this equivalent is not exposed by the python-part of the driver.
> (its called 'lastoid').
>
> The second reason is that we put mxDateTime support into the python
> part of the Postgres driver so that some assumptions MiddleKit makes
> about the type of the returned data of datetime columns hold.  I suppose
> there is a way to do that little bit of processing in the MiddleKit patch
> directly and if anyone can point me in the right direction there, I would
> truly appreciate it.
>
> any and all feedback very welcome!
>
> Ingo
>