Revision history for App-DBBrowser
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'".
2.030 2018-11-28
- Update documentation.
2.029 2018-11-27
- Update documentation.
2.028 2018-11-25
- New option to disable "File::Find" warnings.
2.027 2018-11-23
- Added option 'color'.
- "Term::Choose" => '1.634'.
- "Term::Choose::Util" => '0.068'.
- "Term::Form" => '0.502'.
- "Term::TablePrint" => '0.100'.
2.026 2018-11-11
- File::Find: disable warnings if OS is MSWin32.
2.025 2018-08-13
- Removed "Term::ProgressBar" from the dependencies since "Term::TablePrint" has now its own progress bar module.
- Minimum version "Term::TablePrint" is "0.072".
2.024 2018-08-11
- Add "Term::ProgressBar" to the dependencies (because "Term::ProgressBar" is now optional in "Term::TablePrint").
2.023 2018-08-07
- The Insert key goes back 25 pages, the Delete key goes forward 25 pages.
- Minimum version "Term::Choose" is "1.621".
- Minimum version "Term::TablePrint" is "0.070".
2.022 2018-08-04
- Bugfix in 'add_subqueries'.
2.021 2018-07-20
- Output tweaking.
- Bugfix regexp.
- Minimum version "Term::Form" is "0.321".
2.020 2018-07-15
- Output tweaking.
- Minimum version "Term::Choose" is "1.604".
- Minimum version "Term::Choose::Util" is "0.066".
- Minimum version "Term::TablePrint" is "0.069".
2.019 2018-07-13
- Close an open parentheses automatically on OK.
- Regexp: show the operator already before entering the pattern.
2.018 2018-07-09
- Don't put Version in every pm.
- Bugfix join-menu.
2.017 2018-07-06
- Bugfix undefined database.
- New option 'squash spaces'.
- Minimum version "Term::TablePrint" is "0.068".
2.016 2018-07-03
- Minimum version "Term::Choose" is "1.600".
- Minimum version "Term::Choose::Util" is "0.065".
- Minimum version "Term::TablePrint" is "0.067".
- Minimum version "Term::Form" is "0.316".
2.015 2018-06-19
- 'no_spacebar' to 'meta_items'.
2.014 2018-04-20
- Improved documentation.
2.013 2018-04-16
- Fixes documentation format.
2.012 2018-04-08
- Rearranged option menu.
2.011 2018-04-06
- Minimum version "Term::Choose::Util" is "0.062".
2.010 2018-04-04
- Code refactoring.
- Update documentation.
2.009 2018-03-27
- Subquery as a table.
- Auto-increment for SQLite databases.
- Update documentation.
2.008 2018-03-24
- Refactoring aggregate and subqueries.
- Update documentation.
2.007 2018-03-23
- subqueries as 'SET' value in 'UPDATE' stmt.
- Minimum version "Term::Choose" is "1.514".
- Minimum version "Term::Choose::Util" is "0.061".
2.006 2018-03-15
- Option to enbable/disable write access.
- Update documentation.
2.005 2018-03-14
- The option 'alias' now also affects aggregate functions, join and union.
- Minimum version "Term::Form" is "0.315".
2.004 2018-03-12
- Code refactoring.
- New experimental features: subqueries, aggregate in select
- Removed "Files dir" option.
- Update documentation.
- Minimum version "Term::Form" is "0.314".
2.003 2018-03-04
- Update Insert module.
2.002 2018-03-02
- Bugfix in Insert module.
- Bugfix in Table module.
2.001 2018-03-01
- Bugfix: don't close the Temp file handle zu early.
- Minimum version "Term::Choose::Util" is "0.057".
- Removed option "SQLite_directories"
2.000 2018-02-28
- New feature for SQLite: Attach database.
- New option: "quote identifiers".
- New option: "qualified table names".
- Database Plugins: backward incompatible changes.
- Bugfixes and Improvements.
- Code refactoring
- Update documentation.
- Minimum version "Term::TablePrint" is "0.064".
- Minimum version "Term::Choose" is "1.512".
- Minimum version "Term::Choose::Util" is "0.056".
- Minimum version "Term::Form" is "0.313".
1.060_06 2018-02-26
- Developer release
1.060_05 2018-02-25
- Developer release
1.060_04 2018-02-23
- Developer release
1.060_03 2018-02-22
- Developer release
1.060_02 2018-02-20
- Developer release
1.060_01 2018-02-18
- Developer release
1.059 2018-01-25
- Bugfix: set_insert back to config_insert.
1.058 2018-01-22
- No "Auto Limit" when showing the table before drop table.
1.057 2018-01-22
- Bugfix in delete table: show the right row number.
- Code refactoring.
1.056 2018-01-11
- Minimum version "Term::TablePrint" is "0.058".
- Minimum version "Term::Choose" is "1.509".
- Minimum version "Term::Choose::Util" is "0.053".
1.055 2018-01-07
- Update documentation.
1.054 2018-01-07
- Update documentation.
1.053 2017-04-21
- New option "grid".
- Minimum version "Term::TablePrint" is "0.053".
- Update documentation.
- Update year copyright.
1.052 2016-08-30
- Use "Term::Form" instead of "Term::ReadLine::Simple".
1.051 2016-05-13
- Fixed option "File History".
1.050 2016-02-21
- Bugfix: minimum plugin API version is "1.5".
- PREREQ_PM: raised required version of different modules.
1.018_01 2016-02-14
- Code refactoring.
- Requires "Term::Choose::LineFold".
- Update year copyright.
1.018 2015-12-21
- New option to set the default input-file-search-directory.
- Update documentation.
1.017 2015-12-15
- Create table: options to set the default data type and the name of the id col.
- Stable release.
- Update documentation.
1.016_07 2015-12-09
- SQLite: reconnect to the DB only before dropping or creating a DB.
1.016_06 2015-12-08
- SQLite: reconnect to the DB before writing to the DB.
- Code refactoring.
- Minimum version "Term::Choose::Util" is "0.027".
- Filename: choose instead of reading.
1.016_05 2015-12-06
- Bugfix: UPDATE after INSERT: only inserted cols for UPDATE.
- Code refactoring.
- Update documentation.
1.016_04 2015-12-01
- SELECT: add "$sth->finish()" where no rows are fetched.
- Code refactoring.
1.016_03 2015-11-27
- Update module "CreateTable".
- Minimum version "Term::TablePrint" is "0.025".
1.016_02 2015-11-26
- Removed "\K" - not available before 5.10.
- Fixed bug in backwards-compatibility-code.
1.016_01 2015-11-23
- SQLite: new feature "create table" and "drop table".
- Code refactoring.
- Update documentation.
1.016 2015-11-10
- Update Insert-package.
- Code refactoring and cleanup.
- Update documentation.
1.015 2015-11-08
- Update Insert-package.
- Removed the "location of the configuration directory has changed"-message.
- Update documentation.
1.014 2015-08-17
- Raised "Term::TablePrint" minimum version to "0.024".
1.013 2015-08-17
- Removed support for the plugin api version "1.3".
- The option "Table rows" has now 3 different settings instead of 2. The default behavior has changed.
1.012 2015-04-13
- New dependency "File::Which";
- config dir is $XDG_CONFIG_HOME if which( xdg-user-dir ).
- the config dir is now called "db_browser" instead of "db_browser_conf".
- Update documentation.
1.011 2015-03-28
- "Term::ReadLine::Simple" minimum version "0.300".
1.010 2015-03-25
- Refactoring options.
- Removed dependency on "File::Slurp" [RT #103037 - Karen Etheridge (ETHER)].
- "Term::Choose::Util" minimum version "0.025".
- Update documentation.
1.009 2015-03-19
- "Term::ReadLine::Simple" minimum version "0.208".
- Code refactoring.
1.008 2015-02-25
- New plugin api (1.4).
- Removed support for the plugin api version "1.1" and "1.2".
- Bugfix "Database settings": display the global setting if database specific setting is undefined.
- Update documentation.
1.007 2015-02-23
- Do not offer "Insert", "Update", "Delete" when not supported (union, join).
- Update documentation.
1.006 2015-02-16
- Code refactoring (join alias tables/idx).
1.005 2015-02-14
- Re-enable "AutoCommit" because no "commit"s in db plugins (where required: "begin_work" disables "AutoCommit" automatically).
1.004 2015-02-11
- JOIN: add the tablename to the column names.
1.003 2015-02-06
- Bugfix option "mouse".
- Support Debug plugin.
- Update "INSERT" menu.
- Update documentation.
1.002 2015-02-03
- Bugfix options.
- DB plugins: "AutoCommit" to 0.
1.001 2015-01-31
- Read db configuration file if db_plugin settings have changed.
- Bugfix options insert.
- Code refactoring.
- Update documentation.
0.999 2015-01-29
- Changed available operators.
- Handle missing "sql_regexp" and "concatenate" method.
- Code refactoring.
0.998 2015-01-28
- Bugfix in"App::DBBrowser::DB::SQLite" (search directories).
- Code refactoring (schema).
0.997 2015-01-27
- Bugfix in LIMIT;
- Don't ask to choose if only one database.
- Code refactoring.
- Plugin API version 1.3.
- Update documentation.
0.996 2015-01-25
- Code refactoring.
- Update documentation.
0.995 2015-01-22
- Removed option "sssc_mode".
- Update documentation.
0.994 2015-01-22
- Bugfixes database setting default values.
- Bugfixes in "__read_config_files" and "__write_config_files".
- Plugin API version 1.2.
- Code refactoring.
- Update documentation.
0.993 2015-01-09
- Bugfix: Table/hidden menu.
- Plugin API version 1.1.
- Code refactoring.
- Update documentation.
0.992 2015-01-04
- Bugfix: "sssc_mode" in "Insert".
- Bugfix: column menu in "union".
- New plugin method "plugin_api_version".
- Removed option "Input filter" (now always enabled).
- Code refactoring.
- Update documentation.
0.991 2014-12-24
- Bugfix in hidden menu.
- Use 'catfile' to build the glob pattern for the search of the installed db drivers.
- Code refactoring.
0.990 2014-12-22
- SQLite: @ARGV are now databases instead of directories.
- Bugfix in "prepare_connect_parameter".
- Regexp: use different "operators" for case (in)sensitivity instead of an option.
- SQLite: move "regexp case sensitivity"-code into the database plugin.
- Code refactoring.
- Update documentation.
0.049_09 2014-12-21
- Code refactoring.
- Back to the old plugin name format.
- Update documentation.
0.049_08 2014-12-19
- Code refactoring.
- Changed plugin name format.
- Update documentation.
0.049_07 2014-12-18
- Code refactoring.
- Update documentation.
0.049_06 2014-12-11
- Code refactoring.
- Update documentation.
0.049_05 2014-12-08
- Code refactoring.
- Update documentation.
- Minimum Perl version "5.8.3".
- "Term::TablePrint": minimum version "0.021".
- Fixed typo in method name [github #3 - Ivan Baidakou (basiliscos)].
0.049_04 2014-12-05
- Bugfix inf sub "read_json": "JSON::XS" -> "JSON".
- "Term::TablePrint": minimum version "0.020".
- Minimum Perl version "5.8.9".
0.049_03 2014-12-04
- Code refactoring.
0.049_02 2014-12-01
- "App::DBBrowser::DB": a module for each driver.
0.049_01 2014-11-29
- Code refactoring.
0.049 2014-11-28
- Code refactoring.
- "Term::Choose-Util" minimum version "0.017".
0.048 2014-11-20
- Update documentation.
- "Term::Choose" minimum version "1.117".
0.047 2014-11-11
- New option "Debug".
- Code refactoring.
- Update documentation.
0.046_01 2014-11-08
- Added file history.
- Choose parse module: Textfiles instead of only CSV files.
- Update documentation.
0.046 2014-11-07
- Support file formats supported by "Spreadsheet::Read".
- New dependencies: "Spreadsheet::Read" and "Text::ParseWords".
- Code refactoring.
- Update documentation.
0.045 2014-10-29
- Code refactoring.
0.044_03 2014-10-28
- Switched back to "Text::CSV".
- Added missing dependency in the "Makefile.PL".
- Bugfix.
- Update documentation.
0.044_02 2014-10-28
- Refactoring input.
0.044_01 2014-10-27
- Bugfixes input.
0.044 2014-10-27
- Use of "Text::ParseWords" instead of "Text::CSV" to parse rows.
- Update documentation.
0.043 2014-10-02
- Bugfix "print_error_message" [github #2 - Mark Lawrence].
- Don't print all filenames when searching SQLite databases.
0.042 2014-10-01
- Handle undefined input filename.
0.041_02 2014-09-29
- Insert: additional option to choose single rows.
- Modified menu behavior.
0.041_01 2014-09-27
- Let "SET" sub-statement behave like similar other sql sub-statements.
0.041 2014-09-26
- Code cleanup.
- Improved documentation.
0.040_05 2014-09-23
- Bugfix row-col filter.
- Bugfix temp csv config.
- Update menu navigation.
0.040_04 2014-09-23
- Update menu navigation.
- Update documentation.
0.040_03 2014-09-23
- Update "INSERT INTO".
- Code refactoring.
- Update documentation.
0.040_02 2014-09-20
- Bugfix "print_error_message".
0.040_01 2014-09-19
- Added experimental sql features (update, delete, insert into).
- Update documentation.
0.040 2014-09-03
- Menu memory for config and SQL menus.
- Replaced "Term::ReadLine::Tiny" with "Term::ReadLine::Simple".
- Update documentation.
0.039 2014-08-16
- Perl minimum version from "5.10.1" to "5.10.0".
0.038 2014-08-16
- Improved documentation.
0.037 2014-07-28
- Bugfix: regex case sensitivity setting.
- New dependency: "Term::ReadLine::Tiny".
- "use JSON" instead of "use JSON::XS".
- Update Makefile.PL.
- Code refactoring.
- Update documentation.
0.036 2014-07-10
- Required minimum version of "Term::Choose::Util" is now "0.011".
- Update documentation.
0.035_04 2014-07-09
- Required minimum version of "Term::Choose::Util" is now "0.010".
- Some read line changes.
- Update documentation.
0.035_03 2014-07-08
- Bugfix in JSON encoding.
- Update "Reset".
- Code refactoring.
- Update documentation.
0.035_02 2014-07-05
- Code refactoring.
- Fixed option "HELP".
0.035_01 2014-07-04
- New configuration file format: each database driver has now its own file.
- One option ("Menus") instead of three to set table/schema/database menu memory behavior.
- The fetching of the required data for connecting to databases has changed.
- 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
- The "mouse mode" is now already effective in the "option" menu.
- Option "login": removed the choice "for every connection".
- Update license.
- Update documentation.
0.010 2014-01-20
- Removed experimental typecast (Pg - aggregate).
- Keep track of the terminal width instead of using "SIGWINCH".
- Adapted "db-browser" to the new "Term::Choose" (version 1.070): "choose" has now set no "limit" by default.
- "sql_regex": typecast to "text" for "Pg".
- Bugfix: if "select" is empty when leaving "aggregate" or "group by" set "select_type" to "*".
- If a field contains a reference replace the reference with the reference type plus ' REF'.
- Code refactoring.
0.009 2014-01-16
- New option "Parentheses". Enable parentheses in "WHERE" or/and "HAVING TO" clause.
- New database options to set "host" and "port" (untested).
- Bugfix: quoting alias in "aggregate" with "quote_identifier" instead of "quote".
- Experimental: typecast to "numeric" in aggregate function if driver is 'Pg'.
- Hidden: added function "BIT_LENGTH" and "CHAR_LENGTH".
- Updated documentation.
0.008 2014-01-12
- Added link to the GitHub repo "App-DBBrowser".
- Code refactoring.
0.007 2014-01-11
- Bugfixed undefined "sqlite_master" primary and foreign keys by replacing in "primary_and_foreign_keys" the parsing of "sqlite_master" with "pragma foreign_key_list(table)".
- Bugfix: regexp for SQLite systemtables from "/sqlite/i" to "/sqlite_/i".
- Changed application directory: from "$HOME/.db_browser_conf" to "File::HomeDir->my_data/db_browser_conf".
- Added option "Path" which shows the path of the "db-browser" and the application directory.
- Code update of limit "Max Rows".
- Updated documentation.
0.006 2014-01-07
- Bugfix: reset cached data if db settings have changed.
- Code refactoring and update - e.g. move db-specific code in the db-section; add "WHERE 1 = 0" to the "SELECT" query where only the column names are needed.
- Improved documentation.
0.005 2014-01-06
- Bugfix.
- Code update and refactoring.
- Improved documentation.
0.004 2014-01-05
- Changed some error handling.
- Code clean up and refactoring.
- Improved documentation.
0.003 2014-01-04
- Fixed documentation.
0.002 2014-01-04
- Code clean up.
0.001 2014-01-04
- First release on CPAN.