App-DBBrowser
view release on metacpan or search on metacpan
- Update year copyright.
2.438 2025-12-25
- Backwards incompatible changes:
Table names and column names are not quoted by default.
Saved subqueries: saved at plugin level instead at driver level.
Changes in how configuration data is saved.
- Bug fixes:
Bug fix in quoting attached databases.
Bug fixes in the Documentation.
DB2: decode only text columns.
Bugfixes in format functions.
Set the default for sqlite_string_mode to a valid value.
Bug fix in the window function frame clause.
Reset the where statement from delete/update.
Informix remove trailing spaces from table-type to fix empty table list in drop_table.
Informix: fixed system schema regexp.
- Updates:
Updated options menus.
Refactoring options.
Update plugins.
Refactoring scalar functions.
Removed comment from the App::DBBrowser::DB documentation.
Added 'tables_info' to the plugin documentation.
Drop table info: use select_statement_results from Table.pm the get the data.
Pg epoch_to_timestamp: removed timestamptz cast from to_timestamp.
Extensions.pm: replaced requires with uses.
Unlink empty config files.
- New:
ODBC: query the DBMS name and set the appropriate SQL dialect.
Added SQL dialects for MSSQL and DuckDB.
2.437_05 2025-12-17
- Bugfix: reset where statement from delete/update.
- Bugfix in window function frame clause.
- ODBC: removed option to set the appropriate SQL dialect.
- ODBC: query the dbms name and set the appropriate SQL dialect.
2.437_04 2025-12-15
- Bugfix default value sqlite_string_mode.
- ODBC: new option to set the appropriate SQL dialect.
- Code adjustments for MSSQL.
2.437_03 2025-12-04
- Added 'tables_info' to the plugin documentation.
- Removed comment from the App::DBBrowser::DB POD.
- Bugfix in App::DBBrowser::Opt::Set::set_options.
- Bugfixes in format functions.
- Code adjustments for DuckDB.
- Refactoring scalar functions.
- DB2: decode only text columns.
- Update options menus.
- Unifying options.
- Bugfix quoting attached databases.
- Bugfixes documentation.
- Update plugins.
- Table names and column names are not quoted by default.
- Saved subqueries: saved at plugin level instead at driver level.
2.436 2025-10-24
- Skip unnecessary step when extended values/arguments are disabled.
2.435 2025-10-14
- Input filter empty columns: bugfix and update.
- DBD::ODBC: added odbc_ignore_named_placeholders attribute.
2.434 2025-10-05
- Allow existing CTEs to be used in the WHERE clause of UPDATE and DELETE statements.
- DBD::Oracle: fixed DSN setup.
- DBD::Oracle: new option "AskIfSid".
2.433 2025-09-29
- SQLite: Respect the "sqlite_see_if_its_a_number" option when quoting constants.
2.432 2025-09-26
- Firebird: bugfix in add-database.
- Pg: update auto-convert-to-text.
- Bugfix: don't allow different quoting for column names and aliases, as aliases could be used as column names later on.
- Bugfix: set the default for "add alias for tables in join" to auto.
- Unicode 17.
2.431 2025-06-06
- Update history for date_add and data_substract.
- Update available columns for extended expressions.
- Makefile.PL: added back the 'dist' section.
2.430 2025-05-13
- Update aggregate functions 'count' and 'group_concat'.
- Term::TablePrint minimum version 0.172.
- New option 'maximum with expanded table row'.
2.429 2025-05-05
- Term::TablePrint minimum version 0.171.
- Added 'List::MoreUtils::XS' to prereq_pm.
- New option 'Pad Row Edges'.
2.428 2025-04-27
- Perl minimum version 5.16.0.
- Term::TablePrint minimum version 0.170.
- Bugfix for Perls prior to 5.26.0: do not use ternary operator with bare length.
- Check the 'realpath' return value.
2.427 2025-04-10
- Term::TablePrint minimum version 0.169.
- Term::Choose::Util minimum version 0.145.
- Update aggregate mode in group_by.
- Code refactoring.
2.426 2025-03-24
- Term::Choose minimum version 1.769.
- Update 'line_fold'.
- Bugfix in input filter 'merge_rows' info output.
2.425 2025-03-23
- Filter 'convert date': skip empty cells.
- Union: the option 'edit statement' replaces the option 'where'.
- Refactored union.
- Bugfix in group_by.
- Improved info output functions.
- Update menus.
( run in 1.767 second using v1.01-cache-2.11-cpan-39bf76dae61 )