early present

[caption id="attachment_468" align="alignright" width="300" caption="open source software, the gift for everyone!"][/caption]

There is an early Christmas present for anyone using prosper, a new release, Version 0.7! You can get it hot off the GitHub or download here.

Version 0.7 has a lot of exciting new features, the biggest 2 were spurred on by Ian Potter and Jeremiah Peschka. The phpDoc has been updated (if you are still using version 0.6 you can find the old documentation here). The big news is that prosper uses Prepared Statements by default now, gracefully and transparently falling back to string interpolation where Prepared Statements are not available. The second new feature is the introduction of Explicit Transaction Management.

[php]
try {
Prosper\Query::begin();

//Do a bunch of stuff

Prosper\Query::commit();
} catch (Exception $e) {
Prosper\Query::rollback();
}
[/php]

Only some of the adapters support this, the ones that do not simply ignore the call to begin(), commit(), and rollback(). You can use the has_transactions() functions to check if the current adapter supports transactions.

Database	Supported by Prosper	Prepared Statements	Transaction Support
dBase	YES	NO	NO
DB++	NO	NO	NO
FrontBase	YES	NO	YES
filePro	NO	NO	NO
Firebird / Interbase	YES	YES	YES
Informix	YES	NO	NO
IBM DB2	YES	YES	YES
Ingres	YES	YES	YES
MaxDB	YES	YES	YES
Mongo	NO	NO	NO
mSQL	YES	NO	NO
MS-SQL	YES	NO	NO
MySQL	YES	YES	YES
OCI8 (Oracle)	YES	YES	YES
Ovrimos	YES	YES	YES
Paradox	YES	NO	NO
PostgreSQL	YES	YES	NO
SQLite	YES	NO	NO
Sybase	YES	NO	NO
Tokyo Tyrant	NO	NO	NO

Happy Holidays, and Happy Coding!