ADQL-2.1 internal draft

Patrick Dowler patrick.dowler at nrc-cnrc.gc.ca
Fri Jun 12 22:40:56 CEST 2015


CADC uses PostgreSQL primarily, but we did have a sybase-backed TAP 
service at one time (that bit is defunct).

Pat

On 12/06/15 07:01 AM, Dave Morris wrote:
> Hi all,
>
> To start the process .. an initial list of platforms and sites using
> them:
>
>       PostgreSQL      GAVO, ESAC/GACS, CDS
>       MySQL
>       MariaDB
>       SQLServer       ROE
>       Sybase          CADC
>       Oracle          Caltech
>       SQLite          Caltech
>       HyperSQL
>       Derby
>
> If you have any others to add let me know.
>
> I'm happy to test and verify things on SQLServer. Any volunteers to
> provide testing and verification for the others ?
>
> Suggested acceptance criteria for SQL features, e.g. bitwise or set
> operations.
>
>       1) Must be implementable(*) on the target platforms
>       2) Must have a clearly defined grammar
>       3) Must have a clear description of the behaviour
>       4) ... ?
>
> Acceptance criteria for astronomy features, e.g. IN_UNIT and cross match
>
>       1) Do we need two independent implementations ?
>       2) Must have a clearly defined grammar
>       3) Must have a clear description of the behaviour
>       4) ... ?
>
> Acceptance criteria for database extensions, e.g. module to implement
> XOR
>
>       1) ... ?
>
> All suggestions and comments welcome, by email or in the ADQL session at
> the conference.
>
> Cheers,
> Dave
>
>
>
> --------
> Dave Morris
> Senior Troll
> Wide Field Astronomy Unit
> Institute for Astronomy
> University of Edinburgh
> --------
>

-- 

Patrick Dowler
Canadian Astronomy Data Centre
National Research Council Canada
5071 West Saanich Road
Victoria, BC V9E 2E7

250-363-0044 (office) 250-363-0045 (fax)


More information about the dal mailing list