App-DBBrowser
view release on metacpan or search on metacpan
- String functions and Postgress: convert automatically to text if a column is not char and not varchar.
- Removed backwards compatibility layer for old search_and_replace settings storage format.
2.420 2024-12-27
- New option: use aliases in 'group by', 'having' or 'order by'.
2.419 2024-12-20
- Update input filter Range_Rows.
2.418 2024-12-18
- Update input filter Choose_Rows.
- New input filter Empty_Rows.
- Text::CSV_XS: use 'getline_all' instead of 'getline'.
2.417 2024-11-17
- Confirm update/delete without where clause.
2.416 2024-10-28
- Term::Choose minimum version 1.767.
2.415 2024-09-05
Extended argument 'column': use horizontal format.
2.414 2024-06-13
- Bugfix Informix 'not matches'.
- Bugfix in 'replace' function: allow empty replacement string.
- Bugfix Informix 'day_of_week'.
2.413 2024-05-23
Bugfix import: don't check for emptiness of the first row if the file is a text file.
2.412 2024-05-21
- New scalar function 'date_subtract'.
- Oracle: bugfix in 'date_add' and 'to_epoch'.
- Oracle does not 'left' and 'right' functions.
- Bugfix in scalar function 'extract': uppercase field argument.
- Input filter 'join_columns': bugfix undefined column name.
2.411 2024-05-20
- Bugfix aliases in 'order_by'.
- Pg and SQLite: bugfix in 'dateadd'.
- Bugfix window functions arguments.
- 'group_concat': add 'order by' if available.
- Update cte.
2.410 2024-05-04
- Derived table/Cte: bugfix in 'choose_query'.
- Bugfix in 'Operators.pm'.
- Refactoring and cleanup.
- SQLite does not have the operators ANY and ALL.
- Term::Choose minimum version 1.765.
2.409 2024-04-28
- SQLite plugin: new option to set the busy timeout.
- SQLite: Renamed and modified the user defined scalar function 'truncate'.
Now 'trunc' treats any value that looks like a number as a number.
- Bugfix in the limit/offset submenu.
- New input filter 'convert datetime'.
- Quote entered numbers if the data type is not numeric and no placeholders are used.
- Added scalar convert functions.
- Epoch_to_DateTime: bugfix and updates.
- Data import: if chosen a deleted directory warn and remove the directory from history.
2.408_05 2024-04-21
- sqlite_busy_timeout.
- Bugfix limit, offset.
2.408_04 2024-04-15
- New input filter: convert_datetime.
2.408_03 2024-04-05
- Quote numbers if the data type is not numeric.
- Refactoring.
2.408_02 2024-04-01
- New: to_xxx scalar functions.
- Refactored ScalarFunctions.
- If chosen a deleted directory: warn and remove it from history.
2.408_01 2024-03-21
- Epoch_to_DateTime: bugfix and updates.
- New: Unix_Timestamp.
2.407 2024-03-11
- Bugfix: auto-increment primary key quoted twice.
2.406 2024-03-11
- New 'create table' options: 'table constraints' and 'table options'.
- Update option 'auto increment column'.
- Use storable to make deep copies.
- DB2, Oracle, Firebird: regex operator bugfix.
- DBD::SQLite minimum version '1.74'.
2.405 2024-02-12
- Bugfixes in the 'search & replace' input filter.
2.404 2024-02-01
- Update and bugfixes documentation.
2.403 2024-01-25
- Update documentation.
- Term::Choose minimum version '1.763'.
2.402 2024-01-03
- Updated input filter 'search & replace'.
- Update documentation.
- Term::TablePrint minimum version '0.162'.
2.401 2023-12-24
- Reset HAVING substatement when leaving the aggregate mode.
- Use String::Substitution in the 'search & replace' input filter.
- Now it is possible to use captured groups in the replacement part of a 'search & replace'.
2.400 2023-12-18
- Changed SQL submenu behavior.
- New scalar functions.
- New extension to set aliases for all selected columns.
- Fixes for submenus HAVING and ORDER_BY when in aggregate mode.
- Updates for option alias.
- Update aggregate mode.
- Catch table-print execute errors earlier.
- Removed backwards compatibility for old f_attached_db and f_subqueries format.
- Use Clone to backup data.
- Term::Choose::Util minimum version '0.140'.
- Update documentation.
2.345_05 2023-12-09
- Fixes for submenus HAVING and ORDER when in aggregate mode.
- Update aggregate mode.
- Update CTEs.
- Update option alias for derived tables and non-unique columns in join.
- Bugfix backup data in join.
- Update documentation.
2.345_04 2023-11-16
- Bugfixes in the HAVING submenu.
- Removed option 'fast_reset'.
- Catch table-print execute errors earlier.
2.345_03 2023-10-28
- Use Clone to backup data.
- Bugfix Postgress: single schema with metadata disabled.
- Added window functions.
2.331 2023-06-28
- Added operators ALL and ANY.
- Different fixes.
2.330 2023-06-26
- Update Union.pm.
- Update Functions.pm.
- Update 'get_stmt'.
2.329 2023-06-21
- Refactoring Functions.pm.
- Nested scalar functions: recursion instead of loop.
2.328 2023-06-15
- Some changes require to reconfigure some options.
- Some menu items have been moved to other menus.
- fill_form menus: option 'auto_up' set to 1.
- Added scalar functions 'coalesce' and 'now'.
- Modified options 'alias' and 'extensions'.
- Bugfix: having clause with subqueries.
- Bugfix: filter reparse.
- Union: option to set the union type.
2.327 2023-06-02
- Bugfix: replace comma with semi-colon.
2.326 2023-06-02
- Fixed bugtracker entry in Makefile.PL.
2.325 2023-06-01
- Added support for Oracle plugins.
- Code refactoring.
2.324 2023-05-02
- Update documentation.
2.323 2023-05-01
- New export option: table-name is default file-name.
2.322 2023-03-23
- Bugfix update/delete with unquoted table name.
2.321 2023-03-21
- Removed option alias defaults.
- Update alias menu.
- Default plugin: SQLite.
2.320 2023-03-14
- Update default aliases.
2.319 2023-03-13
- Create tables: update list of tables even if insert failed.
2.318 2023-03-13
- Bugfix update/delete info print.
2.317 2023-03-12
- Informix: add 'Epoch_to_DateTime'.
- Informix add connection attribute 'ix_EnableUTF8'.
- Pg: add schema 'public' only if db is user-db.
- New option: DB2 application code set.
- New option to disable table print warnings
- Option 'binary_filter': add hexadecimal format.
- Allow nested function.
- attached_DB.json: save attached databases as hash.
- Bugfix in 'from_col_by_col'.
- Bugfix in 'CreateDropAttach'.
2.316 2023-02-19
- Update parse-mode 'Template'.
- Update plugins 'mysql', 'MariaDB' and 'Pg'.
- Informix: use 'table_info'.
- New method 'prepare_identifier'.
2.315 2023-02-13
- Added Informix-plugin.
- Bugfix 'is_system_schema'.
- Update documentation.
- Update from_col_by_col, attach_db, alias.
- Epoch_to_datetime now with fractions of seconds.
- Bugfix: don't limit table rows in Term::TablePrint.
- Bugfix join: don't print columns twice.
- Bugfix default aliases: remove invalid characters.
2.314 2023-02-03
- New data-structure for subquery file.
- Refactoring/update Subqueries, Filter, GetContent
- Bugfix/update filter search_and_replace.
- Simplified formation info-output.
- Update sql_limit.
2.313 2023-01-13
- Bugfix in first_column_is_autoincrement.
- Update attach/detach SQLite databases.
2.312 2023-01-12
- Removed option 'auto_limit'.
2.311 2023-01-12
- SQLite: 'sqlite_'-tables are system tables.
- No reconnect database after create/drop table.
- Bugfix in first_column_is_autoincrement.
- Bugfix in get_join_info.
2.310 2023-01-08
- Added DB2-plugin.
- Bugfix import and export options.
- Sort schemas.
- Tables-menu: don't separate system tables from the user tables if the schema is a system schema.
2.309 2023-01-06
- Bugfix regex operator.
- Update mysql/MariaDB system databases.
2.308 2023-01-03
- Use Text::CSV_XS.
- Bugfix/update option 'eol'.
2.307 2023-01-01
- Removed unused option 'decimal_separator'.
- Add option to config the CSV export.
- Code refactoring.
- Update documentation.
2.306 2022-12-23
- Removed stringification of the output of 'group_concat'.
2.305 2022-12-20
- Firebird: 'similar to' matches only case sensitive.
- Default alias for aggregate functions.
- Stringify the output of 'group_concat'.
- Bugfix 'update' 'join' mysql/MariaDB.
- Bugfix MariaDB: no 'offset' without 'limit'.
2.304 2022-10-12
- Term::TablePrint minimum version is '0.154'.
2.303 2022-07-22
- Bugfix insert plain.
2.302 2022-07-17
- Function Epoch_to_DateTime: handle undefined values.
2.301 2022-07-06
- Use Encode::Locale to get STDIN/STDOUT encodings.
- Win32: don't alter the terminal code page.
- Use at least DBD::SQLite 1.68.
2.300 2022-07-02
- Renamed option 'Max rows' to 'Auto Limit'.
- 'Auto Limit' defaults to 0.
- Update database-plugins.
- Update documentation.
2.299 2022-06-25
- Update Functions.pm.
- Term::Form minimum version is '0.551'.
2.298 2022-06-23
- Update and bugfixes Functions.pm.
2.297 2022-06-20
- Added Firebird-plugin.
- Update plugin-API: 'sqlite_search' is now 'search'.
- Bugfix: reading file with Text::CSV.
- Update 'from_col_by_col'.
- Update function 'Epoch_to_DateTime'.
- Refactoring Functions.pm.
- Removed backward compatibility for removed option values.
2.296 2022-05-01
- Term::Choose minimum version is '1.749'.
- Term::Form minimum version is '0.547'.
- Update documentation.
2.295 2022-03-31
- Make the code work with the new version (0.543) of Term::From.
2.294 2022-03-26
- Update plain data input.
- Bugfix in GetContent.
2.293 2022-03-08
- Bugfix encode json.
2.292 2022-03-06
- Update menu "Reset DB".
2.291 2022-01-20
- Plugin 'mysql': utf8mb4 requires DBD::mysql 4.041 or greater.
- Update year copyright.
2.290 2021-12-01
- Raised the Perl minimum version to '5.014'.
- Use the '/r' option for non-destructive substitution.
2.289 2021-11-27
- Use JSON::MaybeXS instead of JSON.
2.288 2021-11-17
- Fixed unmet dependency on App::DBBrowser::DropTable [RT #140081 - Igor Yu. Vlasenko].
2.287 2021-10-21
- Term::TablePrint minimum version is '0.148'.
2.286 2021-10-18
- New option 'truncate fractions first'.
- Update options menu.
2.285 2021-10-03
- Term::TablePrint minimum version is '0.145'.
2.284 2021-09-26
- Attached databases: do not allow 'main' and 'temp' as alias names.
- Code refactoring.
2.283 2021-09-26
- Attached databases: update tables menu.
2.282 2021-09-24
- Term::Choose minimum version is '1.739'.
- Code refactoring.
2.281 2021-08-29
- Adapt the code to the updated Term::Choose.
2.280 2021-08-24
- DBD::SQLite 1.68 or greater is required.
- print_table: table_name -> footer.
- Renamed the option 'f3' to 'search'.
- 'Ctrl-F' instead of 'F3' to open the search prompt.
- PageUP/PageDown: 'Ctrl-P'/'Ctrl-N' instead of 'Ctrl-B'/'Ctrl-F'.
2.279 2021-07-29
- Bugfix in functions Epoch_to_Date/Epoch_to_DateTime: use driver specific regex statement.
2.278 2021-07-29
- Removed the source type 'Copy&Paste'.
- Removed option 'Truncated rows'.
2.277 2021-07-28
- SQLite: replace 'sqlite_unicode' with 'sqlite_string_mode' if DBD::SQLite version >= 1.68.
- Bugfix in 'attributes': use the values not the indexes.
- Bugfix: apply DB specific setting immediately.
2.276 2021-07-20
- Update export file_name.
2.275 2021-07-19
- Update option auto-extension.
- Bugfix export file_name.
- Update UI filter.
2.274 2021-07-16
- Bugfix option auto-extension.
2.273 2021-07-16
- Option to export the result of a chosen SQL statement to a CSV-file.
- Code refactoring.
2.272 2021-07-12
- Simplified substatements extensions.
- Update option 'Alias'.
- Code refactoring.
- Update UI Functions.
- Bugfix function aliases.
2.271 2021-07-05
- Code refactoring.
- Update UI.
2.270 2021-06-30
- Bugfix in search_and_replace history.
2.269 2021-06-30
- Code refactoring.
- Update UI input filter.
2.268 2021-06-23
- Makefile.PL: fixed wrong Term::Form minimum version.
2.267 2021-06-22
- Update UI input filter.
- Removed option 'Expand info table'.
- Code refactoring.
2.266 2021-06-17
- Removed option 'show_table_name'.
2.265 2021-06-11
- Removed options 'grid' and 'keep_header'.
2.264 2021-06-04
- Update option 'Expand table'.
( run in 1.076 second using v1.01-cache-2.11-cpan-39bf76dae61 )