easyaccess: Enhanced SQL command line interpreter for astronomical surveys
Abstract
easyaccess is an enhanced command line interpreter and Python package created to facilitate access to astronomical catalogs stored in SQL Databases. It provides a custom interface with custom commands and was specifically designed to access data from the Dark Energy Survey Oracle database, including autocompletion of tables, columns, users and commands, simple ways to upload and download tables using csv, fits and HDF5 formats, iterators, search and description of tables among others. It can easily be extended to another surveys or SQL databases. The package was completely written in Python and support customized addition of commands and functionalities.
Cite
@article{arxiv.1810.02721,
title = {easyaccess: Enhanced SQL command line interpreter for astronomical surveys},
author = {M. Carrasco Kind and A. Drlica-Wagner and A. M. G. Koziol and D. Petravick},
journal= {arXiv preprint arXiv:1810.02721},
year = {2019}
}
Comments
5 pages, 3 figures. Accepted to the Journal of Open Source Software. The code and tutorial are available at https://github.com/mgckind/easyaccess