Re: PostgresSQL DLR support

On Tuesday 03 February 2004 15:32, Rene Kluwen wrote:
> About the psotgres patch:
>
> In configure.in linking is done against -llibpg which should be (for
> me) -lpg.

FYI: linking is always done with -lpg (w/o lib prefix).

>
> Alexander: I saw your start of select/update abstraction. The one in which
> select takes a **List parameter. Are we talking about the same thing now?

yep... but I'm too busy to make further changes. You can look into 
dbpool_oracle.c as example (it's not a ideal solution but works ;)). Other 
ideas on how todo it are highly welcome ;)

> Implementing this won't be too hard and I can take that job upon me, as I
> am doing sqlbox now as well (mysql, postgres, mssql) which would also
> benefit from it.
>
> But.............: How about different SQL syntax of different SQL server
> implementation?
> As an example: mysql: select * from table limit 0,1; ms-msql: select top 1
> * from table;
>
> Also create table and field-types are kind of different.

yes, and it's not easy solvable problem :( We can try todo something I did for 
libsdb dlr support?

>
> Regards,
>
> Rene Kluwen
> Chimit
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]]On
> Behalf Of Stipe Tolj
> Sent: dinsdag 3 februari 2004 14:51
> Cc: [email protected]
> Subject: Re: PostgresSQL DLR support
>
> Alexander Malysh wrote:
> > hmm, that was my first attempt to get things right ;)
> > Oracle's OCI is just complex and I've introduced 'select/update' within
> > dbpool. IMO, we should abstract more, so that dbpool deal with
>
> DBConnection
>
> > and DBConnection object should implement 'select/update'.
>
> +1 on a full dbpool abstraction layer. There are projects that try to
> do this. Martin, if you can have a view into those?!
>
> Stipe
>
> mailto:[email protected]
> -------------------------------------------------------------------
> Wapme Systems AG
>
> Münsterstr. 248
> 40470 Düsseldorf, NRW, Germany
>
> phone: +49.211.74845.0
> fax: +49.211.74845.299
>
> mailto:[email protected]
> http://www.wapme-systems.de/
> -------------------------------------------------------------------
>
> -----BEGIN PGP PUBLIC KEY BLOCK-----
> Version: GnuPG v1.2.2 (Cygwin)
>
> mIsEP6mcYwEEAMDnUiUwrbb+xwTFWN6TxF2+XZu7/alwJMeCwMBRvXtPZqfjpPhS
> OkBpU0F4TrVuugz1HINTSaJTYq10AzDQXp5NkyWgckqW79nPAWuOX0dicbJk+cN2
> nM2TI4KaxUDe6u8hghNEnH/i2lXsUu9apnP/iixzV81VC2je3uc9hZpnAAYptEVT
> dGlwZSBUb2xqIChUZWNobm9sb2d5IENlbnRlciAmIFJlc2VhcmNoIExhYikgPHRv
> bGpAd2FwbWUtc3lzdGVtcy5kZT6ItAQTAQIAHgUCP6mcYwIbAwYLCQgHAwIDFQID
> AxYCAQIeAQIXgAAKCRABV0w1BqPYRuSqA/wPzsQxao2YePENCtgRTrO86U6zg3sl
> OcS6CJFI4FZP5h/xD3GRsNH1+MPSvZlomDdpFnr547DGz/Kq9MXuQwVvlVig5yWZ
> K5dtKp1r5YLhxJQBhfirZbRFFnYmf19f18J8OoS28tuFVftDl1AIwJS3HLyBTv6H
> g2HyLAEKQIp30Q==
> =aYCI
> -----END PGP PUBLIC KEY BLOCK-----

-- 
Best regards / Mit besten Grüßen aus Düsseldorf

Dipl.-Ing.
Alexander Malysh
___________________________________________

Centrium GmbH
Vogelsanger Weg 80
40470 Düsseldorf

Fon: +49 (0211) 74 84 51 80
Fax: +49 (0211) 277 49 109

email: [email protected]
web: www.centrium.de
msn: [email protected]
icq: 98063111
___________________________________________

Please avoid sending me Word, Excel or PowerPoint attachments.
See http://www.fsf.org/philosophy/no-word-attachments.html