Releases | Open Source Science

Scientific Software - Peer-reviewed - Python
Published by mgckind over 7 years ago

Scientific Software - Peer-reviewed - Python
Published by mgckind over 7 years ago

Scientific Software - Peer-reviewed - Python
Published by mgckind over 7 years ago

Improved version to work with public release DB
Update dtypes to match Y3 tables (PR #149)
Fix bytes to unicode issue for py3 when writing h5 files
Fix bug with Oracle types NUMBER with no scale/digits
Add desdr database and remove oldoper
Fix HDF5 output files, (see #140)
Add compression option to configuration, gzip is applied to .csv,.tab,.fits (latter only for 1 DB trip), bzip2 for hdf5 fits can be opened in append mode when they are compressed, workaround is to increase prefetch

Scientific Software - Peer-reviewed - Python
Published by mgckind almost 8 years ago

Reduce the number of tries for connection
Add options to connect to new desoper and remove oldsci, passwords not longer linked (PR #136)
Allow describe_table to work for materialized views (see #135)

Scientific Software - Peer-reviewed - Python
Published by mgckind almost 9 years ago

Scientific Software - Peer-reviewed - Python
Published by mgckind about 9 years ago

Scientific Software - Peer-reviewed - Python
Published by mgckind about 9 years ago

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)

Scientific Software - Peer-reviewed - Python
Published by mgckind about 9 years ago

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)

Scientific Software - Peer-reviewed - Python
Published by mgckind about 10 years ago

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 showindex and describetable 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 query#67
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 (pandastodb) and imprived docs#68
Load big files in chunks -- very useful to load big files in chunks without running into memory issues #66
Fix findtables (to include owners) and describetable (data_type) commands
Added unittest suites #65 #70
Added --no_refresh option in command line to quick start up

Scientific Software - Peer-reviewed - Python
Published by mgckind about 10 years ago

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 and --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

Scientific Software - Peer-reviewed - Python
Published by mgckind over 10 years ago