Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Lukas Smith's Blog:
New PEAR releases
Aug 22, 2006 @ 15:23:13

Lukas Smith has posted about some updates for the MDB2 PEAR package he maintains, including many bug fixes and the addition of the SQLite driver.

I got annoyed be seeing the driver fail so many of the unit tests because there is no support for ALTER TABLE in SQLite version 2 that I sat down and wrote up an emulation for it. Maybe someone has use for it.

There is a lot of tricky code in there to properly read the current table layout like fields, indexes and constraints as well as the data which all should be merged with the changes if everything goes as planned. Needless to say its a somewhat risky operation, especially since SQLite does not support transactions for DDL operaitons.

He also talks about some updates he's made to the LiveUser and LiveUser_Admin packages to correct bugs found there. His next release will be the MDB2_Schema package, with some new DML additions.

tagged: pear release mdb2 mdb2_schema liveuser liveuser_admin sqlite pear release mdb2 mdb2_schema liveuser liveuser_admin sqlite

Link:

Lukas Smith's Blog:
New PEAR releases
Aug 22, 2006 @ 15:23:13

Lukas Smith has posted about some updates for the MDB2 PEAR package he maintains, including many bug fixes and the addition of the SQLite driver.

I got annoyed be seeing the driver fail so many of the unit tests because there is no support for ALTER TABLE in SQLite version 2 that I sat down and wrote up an emulation for it. Maybe someone has use for it.

There is a lot of tricky code in there to properly read the current table layout like fields, indexes and constraints as well as the data which all should be merged with the changes if everything goes as planned. Needless to say its a somewhat risky operation, especially since SQLite does not support transactions for DDL operaitons.

He also talks about some updates he's made to the LiveUser and LiveUser_Admin packages to correct bugs found there. His next release will be the MDB2_Schema package, with some new DML additions.

tagged: pear release mdb2 mdb2_schema liveuser liveuser_admin sqlite pear release mdb2 mdb2_schema liveuser liveuser_admin sqlite

Link:

Lukas Smith's Blog:
LiveUser installer and MDB2_Schema magic
Feb 09, 2006 @ 06:41:59

Lukas Smith, in his latest blog entry spotlights a feature added a while back to the MDB2 database package he develops - the ability to disable the execution of SQL queries.

A long while ago I added a seemingly idiotic feature to MDB2: The ability to disable the execution of queries.

The idea was that with the combination of a debug handler it would be possible for people to create a dump of SQL queries generated by MDB2_Schema during the installation or updating of a schema. All you would need to do is write up a debug handler for MDB2. Finally you would set the "disable_query" parameter when calling MDB2_Schema::updateDatabase() to true.

He also includes some brief code and some notes about the further development of the idea and its inclusion into other apps (LiveUser). There's also some sample output from one of his scripts to give you an idea of what the end result will be.

tagged: liveuser installer MDB2 mdb2_schema megic liveuser installer MDB2 mdb2_schema megic

Link:

Lukas Smith's Blog:
LiveUser installer and MDB2_Schema magic
Feb 09, 2006 @ 06:41:59

Lukas Smith, in his latest blog entry spotlights a feature added a while back to the MDB2 database package he develops - the ability to disable the execution of SQL queries.

A long while ago I added a seemingly idiotic feature to MDB2: The ability to disable the execution of queries.

The idea was that with the combination of a debug handler it would be possible for people to create a dump of SQL queries generated by MDB2_Schema during the installation or updating of a schema. All you would need to do is write up a debug handler for MDB2. Finally you would set the "disable_query" parameter when calling MDB2_Schema::updateDatabase() to true.

He also includes some brief code and some notes about the further development of the idea and its inclusion into other apps (LiveUser). There's also some sample output from one of his scripts to give you an idea of what the end result will be.

tagged: liveuser installer MDB2 mdb2_schema megic liveuser installer MDB2 mdb2_schema megic

Link: