https://github.com/retifrav/tap-adql-sandbox
GUI application for executing ADQL queries via TAP interface.
Science Score: 26.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
○CITATION.cff file
-
✓codemeta.json file
Found codemeta.json file -
✓.zenodo.json file
Found .zenodo.json file -
○DOI references
-
○Academic publication links
-
○Committers with academic emails
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (8.9%) to scientific vocabulary
Keywords
Repository
GUI application for executing ADQL queries via TAP interface.
Basic Info
Statistics
- Stars: 8
- Watchers: 3
- Forks: 1
- Open Issues: 4
- Releases: 0
Topics
Metadata Files
README.md
TAP ADQL sandbox
About
A sandbox application for executing ADQL queries via TAP interface of various data sources, such as astronomical databases. Essentially, it's just a GUI for PyVO.

More details in this article.
Demonstration
https://user-images.githubusercontent.com/6904927/154367260-db2dc02c-ee88-4fe2-b500-cae14d51bd08.mp4
Installing
From PyPI
sh
$ pip install tap-adql-sandbox
From sources
sh
$ cd /path/to/repository/
$ pip install ./
or:
sh
$ cd /path/to/repository/
$ python -m build
$ pip install ./dist/tap_adql_sandbox-VERSION-py3-none-any.whl
Running
sh
$ tap-adql-sandbox --help
Platforms
Tested on:
- Mac OS:
- 11.6.4, Intel
- 12.2.1, Apple silicon
- Windows:
- 10
- 11
- GNU/Linux:
- Ubuntu 20.04
Known problems
Application tries to connect to remote hosts on startup and sometimes crashes
Sometimes when you are just launching the application, so you didn't even have a chance to execute any queries, you might notice that it tries to reach various remote hosts on the internet, such as obspm.fr, ietf.org or probably others.
This is because of the Astropy package, which is an indirect dependency through PyVO, which is a direct dependency of this project. Specifically, it's the hosts listed in this file. Looks harmless enough, apparently just updating some astronomical data.
Denying access to these hosts might lead to the application crash, because Astropy doesn't handle such situation properly:
AttributeError: module 'IPython.utils.io' has no attribute 'stdout'
If you get the application crashing even when access to those is allowed, try to update the Astropy (and probably also PyVO) package:
sh
$ pip install astropy -U
I had this problem with Astropy v4.2, and it was gone after updating to Astropy v5.1. Or perhaps the problem isn't really gone, but the new package version just came with updated data, so for now there is no need for updating.
Queries might fail with UnicodeDecodeError
If query results from a TAP service contain non-ASCII symbols, then PyVO will raise an exception. The application won't crash, but you won't get query results either.
3rd-party
Dependencies
- Python
3.6or later- or at least it should work with
3.6, but the oldest tested version was actually3.7, and that was quite some time ago, so you better stick with a more recent version
- or at least it should work with
- Dear PyGui - application window and UI controls
- PyVO - handling TAP ADQL requests
- Astroquery - looking up IDs in Simbad
- pandas - processing results and saving to pickle
- tabulate - printing results to stdout (with
--debug) - transitive (dependencies of dependencies):
- NumPy comes through Astroquery(?) and has certain incompatibilities with various versions of Astroquery and pandas, but they all should work fine together if you (re)install the latest versions of all of those
Resources
- JetBrains Mono font
- an icon of unknown origin
Owner
- Name: retif
- Login: retifrav
- Kind: user
- Location: 127.0.0.1
- Company: Declaration of VAR
- Website: https://decovar.dev
- Repositories: 66
- Profile: https://github.com/retifrav
int x = 0; int y = 5 / x;
GitHub Events
Total
- Issues event: 5
- Watch event: 3
- Delete event: 1
- Issue comment event: 1
- Push event: 10
- Create event: 3
Last Year
- Issues event: 5
- Watch event: 3
- Delete event: 1
- Issue comment event: 1
- Push event: 10
- Create event: 3
Issues and Pull Requests
Last synced: 6 months ago
All Time
- Total issues: 25
- Total pull requests: 0
- Average time to close issues: 4 months
- Average time to close pull requests: N/A
- Total issue authors: 2
- Total pull request authors: 0
- Average comments per issue: 0.72
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0
Past Year
- Issues: 2
- Pull requests: 0
- Average time to close issues: about 3 hours
- Average time to close pull requests: N/A
- Issue authors: 1
- Pull request authors: 0
- Average comments per issue: 0.0
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0
Top Authors
Issue Authors
- retifrav (24)
- bandit-masked (1)
Pull Request Authors
Top Labels
Issue Labels
Pull Request Labels
Packages
- Total packages: 1
-
Total downloads:
- pypi 28 last-month
- Total dependent packages: 0
- Total dependent repositories: 1
- Total versions: 9
- Total maintainers: 1
pypi.org: tap-adql-sandbox
A sandbox application for executing ADQL queries via TAP interface
- Homepage: https://github.com/retifrav/tap-adql-sandbox
- Documentation: https://tap-adql-sandbox.readthedocs.io/
- License: GNU General Public License v3 (GPLv3)
-
Latest release: 0.8.2
published about 1 year ago