[pmwiki-users] RFC- Database access via cookbook - agnostic? Re: SelectQuery development: database records as pages?
crisses at kinhost.org
Sat Sep 30 07:34:42 CDT 2006
On Sep 29, 2006, at 8:42 PM, Kathryn Andersen wrote:
> But having something that can act as an easy portal to a database
> better if it is database-agnostic, since I tend to use SQLite rather
> than MySQL for website databases) that could use the power of the
> database for selecting and sorting, but the convenience of pagelist
> templates for formatting its records, that would be great!
Ben Wilson and I have discussed (and agreed on the benefits of) using
ADODB for creating a database-agnostic version of AuthUserDbase that
includes options for the features I added to create self-sign-up,
email validation, etc.
I'm not sure when that's going to happen as he's working on a degree,
and I'm working on paying my rent. If one additional person in my
household gets a job, I'll be able to put more effort towards PmWiki
modules (justifiable because nothing looks so good in my portfolio as
my involvement in this community LOL).
I think it's a good idea to use a tool like ADODB, however, for
something like SelectQuery as well. I'd be more than willing to talk
to the package maintainer(s) about it.
As long as we can all agree on one call to include ADODB it should
all be good ;) And that would allow you to use SQLite instead of
mysql/postgresql, etc. since that's one of the databases that ADODB
Does anyone object to the use of a tool like ADODB for some recipes?
1) same license as PmWiki 2) 2.7 MB installed (currently) 3) one of
the better open-source database abstraction layers 4) supports MANY
databases: http://phplens.com/adodb/supported.databases.html (some
only on Windows, or with a plug-in) (may even include LDAP, but
they're not very clear on that one)
So essentially I'm asking cookbook authors if we can all agree on one
database abstraction layer for PmWiki -- for use when we're going to
deal with external databases. It would be quite helpful if we all
agreed, and greatly extend the cookbook's support for a variety of
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pmwiki-users