Re: Towards a generic database connection API

2004-12-14 Thread Enrico Weigelt
big_snip / Aehm, what kind of database access are we talking about ? Full SQL quering or just something like sendmail's map-API ? If we really need full SQL, I would suggest something like unixodbc or perl DBI. But I'm not in favour of reinventing the wheel and having yet another SQL framework

Re: Towards a generic database connection API

2004-12-13 Thread Enrico Weigelt
* Paul Querna [EMAIL PROTECTED] wrote: snip LGPL`ed, and I have never seen it used from an Apache Module. something bad on lgpl ? It looks quite heavy... the APR DBD api is just a loose wrapper around the low level calls, its a different target than unixODBC, which looks to be much much

Re: Towards a generic database connection API

2004-12-13 Thread André Malo
* Enrico Weigelt wrote: As long as httpd brings its own expat and pcre, we dont need to discuss about the heavyliness of unixodbc. Fine. Nobody here even wants to discuss it. nd -- die (eval q-qq[Just Another Perl Hacker ] ;-) # André Malo, http://pub.perlig.de/ #

Re: Towards a generic database connection API

2004-12-13 Thread Greg Stein
On Fri, Dec 03, 2004 at 12:33:59PM +, Nick Kew wrote: I've updated the proposed DBD API, and written a better description of it at URL:http://www.apache.org/~niq/dbd.html. This defines only the API, decoupled from my software implementing it. ... Bearing this in mind, I'd like to

Re: Towards a generic database connection API

2004-12-13 Thread Paul Querna
Enrico Weigelt wrote: * Paul Querna [EMAIL PROTECTED] wrote: snip LGPL`ed, and I have never seen it used from an Apache Module. something bad on lgpl ? Yes, but this is not the place to dicuss philosophical differences on open source. It looks quite heavy... the APR DBD api is just a loose

Re: Towards a generic database connection API

2004-12-13 Thread Greg Stein
On Mon, Nov 29, 2004 at 10:08:26AM +, Nick Kew wrote: ... Several folks on IRC favour an apr_dbi layer. That's great, but it's a different project, and I'd certainly want to look at harnessing existing DBI projects rather than reinventing that wheel. Yes, but what you're seeing is a bunch

Re: Towards a generic database connection API

2004-12-13 Thread Nick Kew
On Mon, 13 Dec 2004, Greg Stein wrote: On Fri, Dec 03, 2004 at 12:33:59PM +, Nick Kew wrote: I've updated the proposed DBD API, and written a better description of it at URL:http://www.apache.org/~niq/dbd.html. This defines only the API, decoupled from my software implementing it.

Re: Towards a generic database connection API

2004-12-12 Thread Enrico Weigelt
* Nick Kew [EMAIL PROTECTED] wrote: snip I'd like the DBD API to be generic, and to work for other modules that use an SQL backend, ranging from specific modules such as SQL-based authentication and logging to general frameworks such as Perl, Python and PHP. I don't know to what extent

Re: Towards a generic database connection API

2004-12-12 Thread Paul Querna
Enrico Weigelt wrote: * Nick Kew [EMAIL PROTECTED] wrote: snip I'd like the DBD API to be generic, and to work for other modules that use an SQL backend, ranging from specific modules such as SQL-based authentication and logging to general frameworks such as Perl, Python and PHP. I don't know to

Re: Towards a generic database connection API

2004-12-03 Thread Nick Kew
I've updated the proposed DBD API, and written a better description of it at URL:http://www.apache.org/~niq/dbd.html. This defines only the API, decoupled from my software implementing it. The only material change to the software is that I have added random-access to SELECT result sets, as

Re: Towards a generic database connection API

2004-11-29 Thread Nick Kew
On Sun, 28 Nov 2004, Stas Bekman wrote: Please take a look at DBDI Project. http://groups.google.com/[EMAIL PROTECTED] which already targets Perl6 DBI, Python DBI, Ruby DBI, PHP DBI etc. Hmmm. Interesting in principle, but there's not sufficient information at that URL to determine whether

Re: Towards a generic database connection API

2004-11-29 Thread Stas Bekman
Nick Kew wrote: On Sun, 28 Nov 2004, Stas Bekman wrote: Please take a look at DBDI Project. http://groups.google.com/[EMAIL PROTECTED] which already targets Perl6 DBI, Python DBI, Ruby DBI, PHP DBI etc. Hmmm. Interesting in principle, but there's not sufficient information at that URL to

Re: Towards a generic database connection API

2004-11-28 Thread Nick Kew
On Sat, 27 Nov 2004, Paul Querna wrote: Nick Kew wrote: I have recently developed a first-draft namespace module mod_sql for incorporating SQL into HTML/XML pages with mod_publisher or mod_xmlns. In doing so, I revisited the existing database connection pooling modules, and

Re: Towards a generic database connection API

2004-11-28 Thread Stas Bekman
Paul Querna wrote: Nick Kew wrote: I have recently developed a first-draft namespace module mod_sql for incorporating SQL into HTML/XML pages with mod_publisher or mod_xmlns. In doing so, I revisited the existing database connection pooling modules, and reclassified them as drivers for mod_sql.

Re: Towards a generic database connection API

2004-11-28 Thread Garrett Rooney
Paul Querna wrote: An API to use as a starting point might be libdbi. Its public interface is at http://libdbi.sourceforge.net/docs/programmers-guide/ They also have a set of documentation on the design of the Database Driver's API at http://libdbi.sourceforge.net/docs/driver-guide/ I really

Towards a generic database connection API

2004-11-27 Thread Nick Kew
I have recently developed a first-draft namespace module mod_sql for incorporating SQL into HTML/XML pages with mod_publisher or mod_xmlns. In doing so, I revisited the existing database connection pooling modules, and reclassified them as drivers for mod_sql. I also added support for

Re: Towards a generic database connection API

2004-11-27 Thread Paul Querna
Nick Kew wrote: I have recently developed a first-draft namespace module mod_sql for incorporating SQL into HTML/XML pages with mod_publisher or mod_xmlns. In doing so, I revisited the existing database connection pooling modules, and reclassified them as drivers for mod_sql. I also added support