[pmwiki-users] RFC- Database access via cookbook - agnostic? Re: SelectQuery development: database records as pages?

[marc]

Pico said...
> Crisses wrote:
>
> > 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 
> > supports.
> > 
> > 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)
> 
> How does ADOdb compare with Pear db?

I found it much easier to use when I compared the packages and committed 
to ADODB.

> Most shared hosting servers provide php and mySQL, but I do not know the 
> extent to which ADOdb or Pear db are included and, if not, whether they 
> must be installed by the hosting provider (since shared hosting accounts 
> typically have no command line access and ability to install executables).

ADODB is php-based, so installation is a case of copying the files a la 
PmWiki. You then:

  include('adodb/adodb.inc.php');

and start using it. 

I presume that Ben and Crisses intend to put this in PmWiki's config, 
along with the code to open the db.

-- 
Best,
Marc