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