Database Abstraction Layer for PHP / News: Recent posts

Today i started writing a little script for which i used dal. By accident i ran this script under PHP 5 and came to a 'not so nice' conclusion. PHP 5 breaks dal.
The drivers won't get parsed because of the reassigning of $this that takes place in it. Solved that issue quite easy (copied all vars instead of reassigning $this) but there's more that breaks. For example the fetchObject function of the postgres driver starts complaining. Don't know what it is and will look into it when i have the time but for now the conclusion is you can't use dal with PHP 5.

A new release of DAL has just been uploaded. Not many fixes/enhancements in this release. Jusr a change of used php function names in the postgres driver. The depreciated ones are changed for their new ones.

Ok, currently the only thing that needs implementing is the building of the tree with where clauses and searching on disk for the data.
Pretty busy with work so i hope it will be done before new year.
When the textdriver is completed there will be a new release.

Just a little progress update.

The textdriver is being built, it can already perform the create tasks, so creatng a db/table. And dropping of db's /table's. Inserting of data is also possible and the driver even tries to lock the tables. ;)
I'm working on the select. update and delete statements but that shouldn't be too hard to implement. I got a new job so development has been going very slow. Hope i will manage it to create a release next month.

It has been a while since there was a release of DAL for PHP.
I'm happy to announce that development has resumed. I've returned from a trip through australia and new zealand. Have a lot of idea's to implement so stay tuned ;) I'm currently without a job so i also have plenty of time to implement the new features.
One of the first things wil be a text driver.

Patrick

Today version 0.4.3 of DAL is released.
This version contains a fix to the main dal class to detect describe queries as queries which produce a rowcount.
If you are making use of this type of queries you're advised to upgrade.

Release 0.4.1 is released today.
This is a bugfix release, it fixes a bug in the rowseeking code of the MySQL and mSQL drivers.

DAL version 0.4.0 is released.
This is the stable version of development tree 0.3, so the features from that tree exist in the 0.4 release.
Some highlights: msql, mysql and postgreSQL drivers, extensions, row seeking and more.

Please also take the survey located at: http://sourceforge.net/survey/survey.php?group_id=26282&survey_id=12466

Not planned but its nescessary. Probably some cvs merge went wrong or something but it seemed that the mysql and msql driver got the same bug inserted into the code. Which gave much errors on queries. (they were executed but gave an error in return). Its fixed along with some other stuff (see changelog) and documentation updates.
Next release will be 0.4, i hope ;-))

Released development version 0.3.5.
This is the last planned release before stable 0.4 release. Only updates planned are documentation updates, code cleaning and testing. When stable this version becomes 0.4
Check Changelog for new features and changes

Patched a bug in the mysql driver which prevents the fetchlastinsert function to get confused by comma's in the input for the database table.
Thanks goes to Bharat for noticing and providing a patch.

This is a release to fix a bug in the mysql driver which prevented dal to connect.
Thanks goes to Jose Pinto for reporting.

Maybe you already noticed but there aren't any cvs commits the last week. There will be a suspension in development for i guess 3 weeks. This due the fact i have a ripped muscle in my arm and therefore can;t program.

If you want to ride on the edge and want to have the latest version as soon as it's available. Or you just want to know what's happening in the cvstree. You now can monitor the cvs messages via the dal-cvsmessages mailinglist. The contents of the list are also archived so if you want to view the past commits that's the place to be.

New features include:
* Multiple database config
* Row Seeking
* Bug fixes

Please note: This is the development tree, it can always contain bugs (even obscure ones). It also contains not finished things like extension loading.

Fixed a small issue where with the newest php versions where the associative array function returned double values. You got an associative array and an enumerated array together in one array.

dal 0.2.3 is released. This update contains a new config as a security update. The config is now located in it's own dir (config) and is now named .php instead of .phps. This to prevent webusers from reading it. The config is also splitted up into 2 files, all the messages are now located in a seperate file to make translations easier.
According to this release also the development version is updated with the same construction.... read more

This patch squishes a very little bug in the mysql driver which caused the fetchlastinsert to fail when you were using queries with spaces between values and the values and no ;

-- Updated 30 may 23.20 (GMT+1)
For some obscure reason the 0.2.2 tar won't show up on the files page. It's also available from: dal.sourceforge.net/files

Patch 0.2.1 for DAL is released.
It fixes a small bug with the regular expressions which are checking what type of statement you're executing.

DAL, Database Abstraction Layer, is a front-end written entirely in php. It provides a general way for connecting to databases and is extendible via 'drivers'. This makes changing the DBMS very easy.

Release 0.2.0 is the first stable release of DAL. It contains 2 drivers, mysql and postgres. In the future more drivers will be written and the current drivers extended.
It can be download from http://sourceforge.net/projects/dal... read more