App-DBBrowser
view release on metacpan or search on metacpan
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.
- New option 'fast_reset'.
2.345_02 2023-10-23
- Bugfixes, updates and cleanups.
2.345_01 2023-10-21
- Changed SQL submenu behavior.
- Removed backwards compatibility for old f_attached_db and f_subqueries format.
- Added scalar new functions.
- Added extension to set aliases for all selected columns.
- Update option alias.
- Term::Choose::Util minimum version '0.140'.
2.344 2023-10-15
- Bugfix: no table alias in update/insert/delete.
2.343 2023-10-05
- Split option 'quote identifier' into 'quote table names', 'quote column names' and 'quote aliases'.
- New option: enable/disable aliases for non-unique columns in join.
- Derived table and Cte are available as extension.
- Make a 'Change dir' in the file import menu permanent.
- Order by: add aggregate function aliases.
- Enter aliases for complex columns in 'group by' and use them in 'select'.
- Function 'extract': added support for the field 'quarter'.
- Term::Choose::Util minimum version '0.139'.
- Refactored Join.pm and Union.pm.
- Bugfixes.
- Update documentation.
2.342 2023-09-28
- Bugfix: don't remove outer parentheses in Subqueries.pm.
- Bugfix: wrong format of auto generated aliases in Union.pm.
- Bugfix in table alias: undefined variable.
2.341 2023-09-20
- Bugfix Update: 'set' was missing a parameter.
- Bugfix in Join.pm and Union.pm: uninitialized array references.
- Use CTEs instead of subqueries for derived tables.
2.340 2023-08-26
- Fix in where/having/when: add parentheses only at the top level.
- Allow window function everywhere in select and order_by.
2.339_01 2023-08-24
- Fix in where/having/when: add parentheses only at the top level.
- Allow window function everywhere in select and order_by.
2.339 2023-08-20
- Added ODBC plugin.
- Update alias derived tables.
- Rearrangements in the option menu.
- Bugfix: removed support for the environment variable DBI_DSN.
- Renamed function 'instr' to 'position'.
2.338_03 2023-08-19
- Added ODBC-plugin.
- Bugfix: removed support for the environment variable DBI_DSN.
- Refactoring limit-offset and scalar functions.
- Renamed function 'instr' to 'position'.
2.053 2019-02-04
- Drop table: sort table list.
- Drop table: don't change info behavior if the table is empty.
- Replace spaces in the default table name.
- Don't ask for aliases in set|where|having|group_by|oder_by clauses.
2.052 2019-02-02
- Check for duplicate column names.
2.051 2019-02-01
- Extenstions for "order by".
2.050 2019-01-31
- Bugfix default table name.
2.049 2019-01-29
- Set the default value for the options 'grid' and 'keep_header' to 1.
- Add the sheet name to the default table name if the content is from a spreadsheet.
- Rename the subquery-menu-entry in table/join/union menus.
2.048 2019-01-28
- Update subquery menu.
2.047 2019-01-26
- Use the whole terminal width (by upgrading Term::TablePrint).
- Bugfix in subqueries.
2.046 2019-01-25
- DBD::mysql: 'mysql_enable_utf8mb4' enabled by default, 'mysql_enable_utf8' disabled by default.
- New input filter 'Add Column'.
2.045 2019-01-20
- Bugfix: make the mouse work also in the help menu.
- Parse mode 'split': new option to trim records.
2.044 2019-01-19
- Union: allow to use tables more than one time.
- Union: possibility to use a subquery instead of a table.
- Postgress: change aliases to lowercase if 'quote_identifiers' is disabled.
- Postgress: with 'meta data' disabled and no user schemas: set schema to 'public'.
- Bugfix in option 'extensions'.
- Bugfix in 'Subqueries': avoid duplicate entries.
2.043 2019-01-16
- Bugfix: file name encoding.
- Bugfix: parentheses in 'Subqueries'.
- New input filter: convert empty fields to NULL.
- New itemt in option 'Extensions SET': '=N' to set a field to NULL.
- Make it possible to enter a "\t" as the 'Text-CSV-sep_char' value.
- New option 'Info'.
- Update write access.
2.042 2019-01-11
- Join: possibility to use a subquery instead of a table.
- Join: option to choose the comparison operator.
- Remove duplicates in history.
- Bugfix: avoid double quoting in saved subqueries.
2.041 2019-01-09
- Bugfix in join: backup aliases.
- Update join menus.
- Attached databases: make menus less noisy.
- Code refactoring.
2.040 2019-01-07
- MySQL and Pg databases: added 'autoincrement' options.
- Bugfix in 'get_schemas'.
2.039 2019-01-06
- Bugfix in join.
2.038 2019-01-06
- Tables: filter out tables of the type 'index'.
- New: choose the join type.
- Bugfix in parse mode split: add negative limit to preserve trailing empty fields.
- Parse mode split: empty fields to 'undef' to avoid conflicts with non-string data types.
2.037 2019-01-06
- Update aggregate/group by.
- Update subqueries/functions.
- Update options.
- Allow self join.
- New function: 'concatenate'.
- New aggregate function: 'group_concat'.
- Replaced 'lock' with 'reset'.
- Tables: don't filter out views.
2.036 2018-12-30
- Update subqueries.
- New file name for saved subqueries.
- SQLite: 'truncate' returns a numeric value.
- SQLite: 'truncate' returns the value without rounding.
- Bugfix in SQLite: the autoincrement column constraint could contain the keyword 'autoincrement'.
- Bugfix in SQLite's 'bit_length': return bits not bytes.
- Bugfix in HAVING clause with operator 'LIKE col': use group results as arguments.
- Bugfixes in 'col_function' and print history.
- Union "All tables": don't include system tables.
2.035 2018-12-20
- "DBD::MariaDB" database plugin.
2.034 2018-12-19
- New option "guess data type".
- Update option "auto increment column".
- Bugfix in "insert_into" menu.
- Filename extension: max length from 3 to 4.
- Select columns: allow to select more than one column at a time.
2.033 2018-12-10
- "Term::Choose" minimum version: '1.638'.
- "Term::TablePrint" mininum version: '0.104'.
2.032 2018-12-09
- New option 'decimal_separator'.
2.031 2018-11-29
- MSWin32: set codepage temporarily to 65001.
- Removed "no warnings 'utf8'".
- Changed "Reset" option.
- Required minimum version of "Term::TablePrint" is now "0.013".
- Required minimum version of "Term::Choose::Util" is now "0.009".
0.035 2014-06-29
- Required minimum version of "Term::Choose::Util" is now "0.008".
- New option to set the default directories where "db-browser" searches for SQLite databases.
- Update documentation.
0.034 2014-06-18
- Bugfix in LIMIT-submenu.
- Update documentation.
0.033 2014-06-15
- Raised the required minimum version of "Term::TablePrint" and "Term::Choose::Util".
- Changed the layout of the "Path" output.
- Fixed: a change of the setting of the option "mouse" is immediately effective.
0.032 2014-05-30
- Printing the table header on each page is not enabled by default.
0.031 2014-05-28
- Fixed bug in the option code.
0.030 2014-05-28
- Added an option to reset the database specific settings back to "Database defaults".
- Code refactoring.
- Update documentation.
0.029_02 2014-05-25
- Fixed option "Binary Filter".
- Removed the extra code which moved "YES" before "NO".
- Code refactoring.
- Update documentation.
0.029_01 2014-05-21
- Each package has now its own file.
- Renamed the option "Expand" to "Enchant"
- Added the option "Table Header" in "Enchant".
- Update documentation.
0.029 2014-05-05
- Parentheses: the user can choose if the parentheses menu entry is located before or after the column names.
- Update documentation.
0.028 2014-04-28
- Bugfix documentation.
0.027 2014-04-28
- Improved documentation.
0.026 2014-04-28
- Improved documentation.
0.025 2014-04-26
- SQL menu entry "COLUMNS" is now called "SELECT".
- Code refactoring.
- Improved documentation.
0.024 2014-04-21
- Bugfix in "backup_in_hidd".
- It is possible now also with "GROUP BY" to choose more than one column at once.
- Update documentation.
0.023 2014-04-10
- Update documentation.
0.022 2014-03-24
- Update "ALL TABLES" in UNION.
- Mininum version of "Term::TablePrint" is now 0.005.
- Update Makefile.PL
0.021 2014-03-22
- Bugfix in UNION.
- New: "ALL TABLES" in UNION.
0.020 2014-03-21
- Rewritten in OO style.
- Outsourced code to "Term::Choose::Util".
0.019 2014-03-08
- "COLUMNS": it is now possible to choose more than one column at once for the "SELECT" statement (experimental).
- Update documentation.
0.018 2014-03-07
- "App::DBBrowser" requires "Term::Choose" version 1.100 or higher.
- Outsourced the table print function in its own module: "Term::TablePrint".
- Code refactoring.
0.017 2014-02-19
- Added new option "ENV DBI" which allows the use of DBI_USER and DBI_PASS to login.
- Removed the option "Default user".
- Removed the option "Separator"
- "pg_enable_utf8" can always be set to "auto" (with "DBD::Pg" < 3.0.0 "auto" is mapped to "enabled").
- Use "FinBin" the get the path of the program.
- Code refactoring.
- Update documentation.
0.016 2014-02-08
- Bugfix and update in setting "pg_enable_utf8".
0.015 2014-02-07
- Fixed bug in "search SQLite databases".
- "pg_enable_utf8" can be set to "auto" if "DBD::Pg" >= 3.x.x.
- Added release test "year_copyright.t".
- Update documentation.
0.014 2014-02-04
- Detect encodings.
- Refactoring system/meta filter.
- Added LICENSE file.
- Improved documentation.
0.013 2014-01-28
- Scalar functions applicable also to "GROUP BY" columns.
0.012 2014-01-27
- "SQLite" is selected if @ARGV.
- Added support for MSWin32 OS.
0.011 2014-01-24
( run in 0.659 second using v1.01-cache-2.11-cpan-39bf76dae61 )