Version 00.08 finalized and now on testing

[Andrea Rimicci]

Hello everyone, to keep you updated with the project will now let you know about the next release, 00.08.

First thing any PHP developer have noticed, MSSQL support have been dropped from PHP 5.3+ project because now Microsoft will support directly its databases with their own drivers for PHP, that means the actual 'mssql' db type now reaches the status of "legacy".

I will NOT drop mssql for the time being, but as a legacy driver it is recommended to move to the new following driver, because the legacy may be dropped in the future (before drop it, there will be a release with mssql 'deprecated' status, first).

To let continue use Microsoft's databases, PHPCOMDB 00.08 now supports the new Microsoft drivers, and the db type target is named 'sqlsrv', so all your work is safe ;)

All that you need to do is install and configure the new drivers on your PHP installation, then change your dbtype from 'mssql' to 'sqlsrv' and it must work flawless.

Those drivers have requisites and all, it is recommended you backup your config before making upgrades.

Here is the almost finalized changelog, there will be no new functions and any changes before release will be just bug fixes, if any, coming from some web sites up and running in production and heavily tested.

development

• NEW: added support for SQL Server 2008 and above (dbtype='sqlsrv')
• NEW: Improved sql_list_tables definition on phpcomdb-function-reference.txt
• NEW: implemented function: string sql_cast_column ($col,$to,[PLI $pli])
• NEW: implemented function: string sql_date_add (string $start,string $part,int $value[,PLI $pli])
• NEW: implemented function: string sql_get_timestamp_fn ([PLI $pli])
• NEW: implemented function: bool sql_create_table (string $table, string $columnsdef[, PLI $pli])
• NEW: implemented function: bool sql_set_primary_key (string $table, string $columns[, PLI $pli])
• NEW: implemented function: bool sql_set_default_value (string $table, string $column, string $default[, PLI $pli])
• NEW: implemented function: bool sql_close_transaction([$commit[,PLI $pli]])
• NEW: implemented function: bool sql_open_transaction([PLI $pli])
• NEW: implemented function: QRI sql_select_nrows(string $query,int $nrows[,PLI $pli]])
• NEW: added favicon.ico and phpcomdb.png project icons in webtest folder
• NEW: phpcomdb.porting.from.mysql.txt modified to include latest updates
• NEW: added readme.txt in webtest folder
• NEW: added copyright notice on source files head
• OTHER: PHPCOMDB sets the supported 'sqlsrv' dbtype target from Microsoft SQL Server 2008 and greater
• OTHER: PHPCOMDB sets the supported 'mssql' dbtype target to 'legacy' status

NOTES: some new implemented functions were added to ease the portability of code with DDL calls (as create tables, setup primary keys or default values for a colums, and alike) and transactions management
NOTES: support for SQL Server 2008 and above requires Microsoft Drivers for PHP for SQL Server version 3.2 or above, not provided by PHP distro

[Andrea Rimicci]

Today the version 00.08 has been pushed out.

"sqlsrv" dbtype haven't omitted on error, it still needs being carefully tested and will be released when tests are done.

You you like playing with experimental features, you can use it, anyway, its file(s) are included into the release.

The deprecation of MSSQL will be committed on release 00.09.