Skip to main content

Utility for converting ADQL to local SQL syntax.

Project description

# 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>”.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

ADQL-1.0.6-py3-none-any.whl (14.1 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page