I know linking is done w/o lib prefix. But it was an error in the Postgres patch. This was not particularly directed to anybody special except the ones who want to use that patch.
About generic SQL support like dbpool_oracle.c: That was exactly what I was talking about. I dont like the select syntax solution like in libsdb dlr support so much. Like for instance some DB's not only use other names to call an animal. But also put those names in different places (compare: 'select ... limit X' with 'select top X ....'). The adodb style PHP abstraction layer that is really popular has seperate .select and .select_limit methods *shrugs*... A different method for every different kind of statement is also not ideal. But it is better than a different method for every db system. Just my 2 cts. Rene Kluwen Chimit -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alexander Malysh Sent: dinsdag 3 februari 2004 15:52 To: Rene Kluwen; Stipe Tolj Cc: [EMAIL PROTECTED] Subject: 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] > 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
