Wed Aug 18 19:05:03 2004

Ticket #423

API/Classes + Database Abstraction


Priority: high Reporter: douglas
Severity: feature Assigned to: anonymous
Component: Campsite Server Status: new
Version: 4.0.0 Resolution:  
Milestone: 4.0.0 Keywords:  

Description by douglas:

Create API for campsite as a set of classes.  We should either use
PEAR::DB or ADODB for database layer.    I've done a short review of
these two database layers, and it looks like ADODB comes out on top.
(To my surprise)    ADODB: <a
href="http://adodb.sourceforge.net/">http://adodb.sourceforge.net/</a>
- support for transactions   - supports more databases: access, DB2,
SAP DB, LDAP, Firebird, Netezza, LDAP, ODBTP, FrontBase   - has
C-compiled PHP extension for speed   - Mambo uses it   - Supports PHP5
- Has better documentation   - Has PEAR support: has the same objects
that PEAR does if you want to use PEAR syntax even though you are
using ADODB.   - Ability to cache recordsets   - Supports cross-
tabulation    PEAR DB: <a href="http://pear.php.net/package/DB/">http:
//pear.php.net/package/DB/</a>   - Its PEAR, so somewhat 'standard'

Changelog

Tue Apr 5 19:20:03 2005: Modified by paul

  • milestone changed from 2.3.0 to 2.4.0

Wed Apr 20 17:46:42 2005: Modified by paul

  • milestone changed from 2.4.0 to 4.0.0