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 LAMP-style single persistent connections for use in non-threaded MPMs, using #if APR_HAS_THREADS. That basically means each database module is an ap_provider for "dbd", and implements a common API. 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 that's going to prove feasible, but perhaps my current draft can serve as a startingpoint. What I'd really like at this stage is feedback from other developers connecting Apache to an SQL backend. Description and source code at http://apache.webthing.com/database/ -- Nick Kew
