ADQL


NameADQL JSON
Version 1.0.5 PyPI version JSON
download
home_pagehttps://github.com/Caltech-IPAC/ADQL
SummaryUtility for converting ADQL to local SQL syntax.
upload_time2020-07-02 14:32:37
maintainer
docs_urlNone
authorJohn Good
requires_python
licenseLICENSE
keywords astronomy database adql sql
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # 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>".



            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/Caltech-IPAC/ADQL",
    "name": "ADQL",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "astronomy database ADQL SQL",
    "author": "John Good",
    "author_email": "jcg@ipac.caltech.edu",
    "download_url": "",
    "platform": "",
    "description": "# ADQL\nADQL to Local SQL Translator\n\nADQL is a variant of SQL that is understood by no DBMSs, the main difference \nbeing support for sky spatial constraints.  \n\nOne approach to supporting ADQL is to extend the DBMS with these ADQL-specific\nconstructs.  The alternate approach taken here is to translate the ADQL into\nlocal SQL before sending it to the DBMS.\n\nSince we also want to make use of spatial indexing to speed up spatial searches,\nwe include in this translation additional spatial index column constraints.  \nThis requires reference to special added columns. \n\nThe hope is that this code can be leveraged by others who either wish to add\nspatial indexing to their DBMS the same way we have or would like a starting\nplace for developing code around their own DBMS.\n\nThis package is complementary to but independent of our implemetation of the\nIVOA Table Access Protocol (TAP); a web service for managing remote database\nrequests for astronomy in a general way.  TAP manages requests/results and is\ngenerally fed ADQL.  This ADQL translator is used by our TAP implementation\nto turn ADQL into SQL the local DBMS can handle directly.\n\nSince this is pure Python, the PyPI package can be built with a simple\n\"<i>python setup.py bdist_wheel</i>\".\n\n\n",
    "bugtrack_url": null,
    "license": "LICENSE",
    "summary": "Utility for converting ADQL to local SQL syntax.",
    "version": "1.0.5",
    "split_keywords": [
        "astronomy",
        "database",
        "adql",
        "sql"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "f7ba514f1d7763d142b5f57175d060a5",
                "sha256": "14fb6f58cb51930cbd7d24d6f68d6cc760ab6170fd45d72f62c561da74e97ced"
            },
            "downloads": -1,
            "filename": "ADQL-1.0.5-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "f7ba514f1d7763d142b5f57175d060a5",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 14061,
            "upload_time": "2020-07-02T14:32:37",
            "upload_time_iso_8601": "2020-07-02T14:32:37.176532Z",
            "url": "https://files.pythonhosted.org/packages/f4/62/e1cc27d8ec952815daa627c1c8a25ebee94fef71835dd7543ca423e28545/ADQL-1.0.5-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2020-07-02 14:32:37",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "github_user": null,
    "github_project": "Caltech-IPAC",
    "error": "Could not fetch GitHub repository",
    "lcname": "adql"
}
        
Elapsed time: 0.13621s