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.

5 pages, 3 figures. Accepted to the Journal of Open Source Software. The code and tutorial are available at https://github.com/mgckind/easyaccess

References in corpus (1)

• The Dark Energy Survey Data Release 1

Cited by in corpus (8)

• The Dark Energy Survey Data Release 2
• Dark Energy Survey Year 3 Results: Photometric Data Set for Cosmology
• Milky Way Satellite Census. I. The Observational Selection Function for Milky Way Satellites in DES Y3 and Pan-STARRS DR1
• A search of the full six years of the Dark Energy Survey for outer Solar System objects
• Trans-Neptunian objects found in the first four years of the Dark Energy Survey
• H0LiCOW X: Spectroscopic/imaging survey and galaxy-group identification around the strong gravitational lens system WFI2033-4723
• Identification of RR Lyrae stars in multiband, sparsely-sampled data from the Dark Energy Survey using template fitting and Random Forest classification
• Reducing ground-based astrometric errors with Gaia and Gaussian processes