Skip to main content

# ADQL ADQL to Local SQL Translator

ADQL is a variant of SQL that is understood by no DBMSs, the main difference being support for sky spatial constraints.

One approach to supporting ADQL is to extend the DBMS with these ADQL-specific constructs. The alternate approach taken here is to translate the ADQL into local SQL before sending it to the DBMS.

Since we also want to make use of spatial indexing to speed up spatial searches, we include in this translation additional spatial index column constraints. This requires reference to special added columns.

The hope is that this code can be leveraged by others who either wish to add spatial indexing to their DBMS the same way we have or would like a starting place for developing code around their own DBMS.

This package is complementary to but independent of our implemetation of the IVOA Table Access Protocol (TAP); a web service for managing remote database requests for astronomy in a general way. TAP manages requests/results and is generally fed ADQL. This ADQL translator is used by our TAP implementation to turn ADQL into SQL the local DBMS can handle directly.

Since this is pure Python, the PyPI package can be built with a simple “<i>python setup.py bdist_wheel</i>”.

Metadata

Release files for ADQL 1.0.6

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Built distribution (wheel)

Table of built distributions (wheels) for ADQL 1.0.6
File Interpreter ABI Platform Actions
ADQL-1.0.6-py3-none-any.whl Python 3 none any Details for ADQL-1.0.6-py3-none-any.whl

Release files / ADQL-1.0.6-py3-none-any.whl

Download URL ADQL-1.0.6-py3-none-any.whl
Size 14.1 kB
Tags Python 3
SHA-256 checksum
How to use checksums
8565d95da7c3ca83ee64abd19c5658ef83a2ad81d4501a8646e2757fb42656fe
BLAKE2b-256 checksum
How to use checksums
e883942031a4858472b718e420060da244b0d5b2ac88e9add2de21d113824ec5
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.4.2 requests/2.19.1 setuptools/45.2.0 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.6.7

Security for ADQL 1.0.6

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page