dataobject
| From: | Lukas Smith | Date: | Mon, 11 Oct 2004 12:34:09 +0000 |
| Subject: | dataobject | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-33768@lists.php.net to get a copy of this message | ||
Hi Alan,
just wanted to let you know that I ported DataObject to MDB2 in a few hours while sitting in a farm house in switzerland :-)
The current code can be found here:
www.backendmedia.com/MDB2/MDB2_DataObject.zip
Dunno if its possible to fit this into your plans regarding a DO ext.
Anyways here are a few notes I made along the way:
- numrows is expensive in combination with unbuffered queries
- use MDB2 quote method for all datatypes (only use type constants internally -
they seem very useful for complex types like "email" and should probably be
integrated into MDB2 itself for internal use)
- use MDB2::singleton and db_index to manage MDB2 objects
- use MDB2 internal debugging capabilities
- can we model raiseError after MDB2's raiseError()
- can we get rid of extends PEAR in MDB2 (loosing expect() error) by a custom raiseError()
- insert/update/delete should return affected rows
- use MDB2 manager (reverse) to read database infos
- integrate xml schema format (possibly use a custom parser)
- MDB2 emulates database for oracle with users
- sequenceKey() seems overly complex
- we need file_exists($foo, $use_include_path) !!!
- how are indexes handled? how are multi column primary keys?
- instead of the generator allow custom serializer and custom fields in the manager
- use templates with generator?
- MDB2 has float type support
- MDB2 quote converts php null to sql NULL
- MDB2 has all the methods needed to create tables
- MDB2 has replace() support
- add support to accept existing MDB2 objects
regards,
Lukas Smith
smith@backendmedia.com
_______________________________
BackendMedia
www.backendmedia.com
berlin@backendmedia.com
Linn Zwoch Smith GbR
Pariser Str. 44
D-10707 Berlin
Tel +49 30 83 22 50 00
Fax +49 30 83 22 50 07