Revision history for App-DBBrowser


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.