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/
|
