From: Reini Urban <rurban@x-...> - 2004-04-16 14:31:11
In CVS is now the latest adodb library 4.22 with all drivers and a
stripped down basic library.
I changed the default fetchmode from assoc to numeric, which is faster
and easier to handle for the customized statements in $DBAuthParams.
The page iterators still use ASSOC keys, but this might by changed also
later. (This is really a hack)
adodb doesn't support table locking, but transactions. I've implemented
a lot of mysql specific and some sqlite specific optimizations, to
avoid locks, but for some destructive operations we will have to add
some kind of locking manually as before. But this will not be as global
as before, only the tables which are really affected.
* fixes for older mysql (no CASE support).
* better title and fulltextsearch (MATCH and REGEX, where supported)
* cleanup of the page iterator to use FETCH_NUM.
This are my notes (lib/WikiDB/backend/ADODB.php):
* Now (phpwiki-1.3.10) with adodb-4.22, by Reini Urban:
* 1) Extended to use all available database backend, not only mysql.
* 2) It uses the ultra-fast binary adodb extension if loaded.
* 3) We use FETCH_NUM instead of FETCH_ASSOC (faster and more generic)
* 4) To support generic iterators which return ASSOC fields, and to
support queries with variable columns, some trickery was needed
to use recordset specific fetchMode.
The first Execute uses the global fetchMode (ASSOC), then it's
resetted back to NUM and the recordset fetchmode is set to ASSOC.
* 5) Transaction support, but no locking yet.
ADODB basic differences to PearDB: It pre-fetches the first row into
fields, is dirtier in style, layout and more low-level ("worse is better").
It has less needed basic features (modifyQuery, locks, ...), but some
more unneeded features included: paging, monitoring and sessions, and
much more drivers.
No locking (which PearDB supports in some backends), and sequences are
very bad compared to PearDB.
From: Reini Urban <rurban@x-...> - 2004-04-16 14:35:26
Reini Urban schrieb:
> In CVS is now the latest adodb library 4.22 with all drivers and a
> stripped down basic library.
Ah, one more thing I forgot:
Numeric pagenames and even the pagename "0" is now supported.
Not yet tested with all plugins, but basic usage is okay now.
This didn't work before, so please no bugreport on this.