[Phpwiki-talk] Pear DB updated

[Reini U. <ru...@x-...>]

I added now DB_Session support and
updated Pear DB to version 1.3 into CVS. Should be in tomorrows nightly 
snapshot. Todays snapshot has a bug with DB_Session which needed to 
large Pear DB update.

DB_Session needs PEAR DB, ie. DBParams['dbtype'] = 'SQL'. No ADODB yet.
The latest Pear DB is of comparable speed as the old ADODB.

DB_sessions are faster than filebased sessions and probably easier to 
setup. (No common shared /tmp dir needed as on sorceforge.net or other 
larger ISP's with load-balanced servers.)

The mysql session table schema is:

drop table if exists session;
CREATE TABLE session (
     sess_id varchar(32) not null default '',
     sess_data blob not null,
     sess_date timestamp,
     PRIMARY KEY (sess_id)
);

pgsql accordingly.

The new PearDB (and PhpWiki 1.3.4) supports now the following databases:
Mysql:      mysql
Postgres:   pqsql
FrontBase:  fbsql
Interbase:  ibase
Sybase:     sybase
ODBC:       odbc (also for the navision driver)
Oracle 8:   oci8
Microsoft SQL Server: mssql
Mini-SQL:   msql
LDAP:       ldap
Informix:   ifx

Plans:
Missing is "flatfile" and Pear support for DBM.
Testing should be done for all new drivers and CVS. I only tested DBM 
and mysql so far. I will be able to test additionally odbc (plain and 
navision) on Windows and Linux.

UserPreferences needs some minor bugfixes with the session and cookie 
code, which I hope to do this  weekend. When UserAuthentication is 
stable, page based EmailNotification and PagePermissions will be 
implemented.
Then some extensions for PageList, probably something like Pear 
DB_Pager. (That's why it is in CVS now also. If not we can remove it.)
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/