Easyaccess

2017-APR-16
- Refactor and huge clean up, now bin/ folder has the startup script (see PR 113 and 111)
- Fix metadata and cache lookup for autocompletion (see 92, 94, 93)
- Add estimate number of rows on describe_table when available (see 75)
- Toggle color mode without exiting interpreter (see PR 110)
- 80 character loading bar (see PR 103)
- Added more information to help command (see PR 100 and 109)
- Fix config option and boolean values (see Pr 115)
- Justify comments to the left in describe_table i(105)
- Added `change_db` option switch between dabatases without logging out (see PR 90 , 86)
- Fixes authentication and des service files
- Added api to access descut services directly (see PR 87)
- Fix readline issues related with some OS X (see 88 and 112)

2016-MAY-24
- Adds optional purge to drop_table (see PR 74)
- Fix a bug setting prefetch parameters using config set 76
- Improve import functionality for inline queries (see PR 78)
- Add option to upload files in chunk of memory (in addition to the chunk by rows), using --memsize option.
This calculates an approximate number of rows to upload on each trip, avoiding memory issues. (see PR 79)

2016-MAY-09
- Fixes a bug with python2/3 compatibility (see Pull-request 36)
- Removes ; from query for python API (query_* functions) issue 37
- Added execproc to run sql/pl procedures, see help execproc for more information (see PR 48)
- Fix show_index and describe_table commands and queries (no more repeated rows) (see PR 42 and 43)
- Case insensitive options (PR 45)
- Reorganization of the structure of the code, this way is much simpler to develop (PR 49)
- Conda installation
- In-query python functions (beta) write your own function and call it from query67
- Query and execution information in FITS header 50
- Fix bug when loading sql from file 55
- Dealing better with trailing white space 52
- Fix several minor issues: 37, 40
- configuration options at command line (reset and configuration per session) with --config
- Improved python API , added some extra functions (pandas_to_db) and imprived docs68
- Load big files in chunks -- very useful to load big files in chunks without running into memory issues 66
- Fix find_tables (to include owners) and describe_table (data_type) commands
- Added unittest suites 65 70
- Added --no_refresh option in command line to quick start up

2015-OCT-01
- Fixes several issues, like: 35, 34, 30, 26 25 among others
- Does not clear screen after query
- Added a message when password has not been set in the last 200 days (added extra columns to whoami as well)
- Fix problem with connection after entering a wrong query which used to hangs in some networks
- Bugfixes (show_index, change display setting without restarting, others)
- Added explain option to see the execution plan, i.e. DESDB ~> SELECT * FROM TABLE; < explain
- Added extra configuration option for column width (useful when printing large text columns)
- Added optional user/password from command line (using --user <user> and --password <password>)
- Added size info to mytables command
- Added append_tables option to append data to existing tables
- Minor changes in uploading tables
- **python 3 compatible**
- **change config.ini folder, from .easyacess/ to .easyaccess (typo)**
- move multiprocess import call depending on whether the loading bar is set

2015-APR-28
- **Change pyfits to fitsio**
- Added autocommit as configuration option to commit changes or not by default (default = yes)
- Added timeout (1 min) to initial metadata cache loading

2015-APR-27
- Fixed bug with single character for fits
- Fix enconding issues (between ASCII and UTF-8)
- Loading bar termination issue fixed
- Added message after loading table for sharing tables
- Started migratrion from pyfits to fitsio
- Set max limit for output files in MB
- Add python API features for key commands and bugfix (All commnands can still be accessed from python API)