Revision history for App-DBBrowser 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.