Gtk2::Ex::Datasheet::DBI is a Perl module enabling data-aware datasheet function within Gtk2::Perl.
This module is responsible for managing querying, navigating records, applying updates to the database, and error handling. In the latest release, there are several new features and improvements that have been added.
One improvement is an overhaul of SQL clause handling. All SQL-related stuff is now in the 'sql' hash. Additionally, support for placeholders in the where clause has been added, along with the detection of the primary key from column_info() for MySQL and SQL Server only.
A destroy method has been added, which destroys all signal handlers that have been created and then destroys itself (although it's not working yet). The $model_setup->{table} has also been renamed to $model_setup->{from} in dynamic models.
Other new features include legacy mode to support 1.x requests, dynamic models processed out of order when querying (no need to queue them for later), a revert() method which is a synonym of undo(), graceful handling of failure of $dbh->column_info (it warns to console what's happened), and a warning to console if $dbh->column_info fails and there is no primary_key definition.
It only asks to apply changes if the application is not read_only. There's also an added missing schema request to self, which is harmless anyway because automatic renderer selection for MySQL is currently the only option supported.
Finally, the documentation has been updated and cleaned up for easier use by programmers. With all these new features and improvements, Gtk2::Ex::Datasheet::DBI is an excellent choice for those looking for data-aware "datasheet" functionality for their Perl GUI applications.
Version 2.0: N/A