App-DBBrowser
view release on metacpan or search on metacpan
Revision history for App-DBBrowser
2.442 2026-05-22
- Term::TablePrint minimum version 0.182.
2.441 2026-05-15
- Raised required minimum version for Term::TablePrint (Bugfix header stringification).
- SQLite: bugfix in checking table name duplicates in create table with qualified table names.
- Update option menu.
2.440 2026-04-11
- Raised required minimum version for Term::TablePrint (Bugfix scientific notation).
2.439 2026-02-23
- Raised required minimum version for Term::Choose and Term::TablePrint.
- New output option expanded line spacing.
- 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.
- Let the user decide which ctes to remove.
2.424 2025-03-09
- Update aggregate mode.
- Bugfix SQLite, first_column_is_autoincrement: tablenames in sqlite_master are not qualified.
- Refactored ScalarFunctions.
- Improved info nested functions.
- New date functions.
- Different bugfixes.
- New sql options.
- Don not restrict 'On clause' operators.
- Limit and offset: each has its own sql-menu entry.
- Term::Choose minimum version 1.768.
2.423 2025-01-27
- Bugfix undefined data type.
- Bugfix where clause: reset and/or connector.
- Added multi-column extension.
- Bugfix extended columns: use normal columns if inside an aggregate functions.
- Subqueries in ctes: do not show ctes twice.
2.422 2025-01-23
- Extension 'Column': it is now possible to use a column from a chosen table.
- A new way to create subqueries: build the subquery using the sql menu.
- Update input filter Range_Rows
- Added the exists and not exists operator.
- Update and delete statement: do not remove the table alias.
2.421 2025-01-09
- Update join condition.
( run in 1.157 second using v1.01-cache-2.11-cpan-5623c5533a1 )