TAP, ADQL and PgSphere

[Patrick Dowler]

On Thursday 22 October 2009 06:28:19 Tom McGlynn wrote:
> At the HEASARC we've gotten a basic TAP service running now that
> supports PQL and ADQL minus the geometry extensions (aka SQL).  To add
> in the geometry support we're looking at using the PgSphere library that
> runs on top of Postgres.  Has anyone else explored using PgSphere in
> this way?

Yes, we are in the process of migrating to postgresql+pgSphere and will be 
using this as our main VO server (TAP, SIA, SSA, etc). I have run into several 
smallish issues and limitations and developed ways around them.

Maybe we can have an informal discussion at the interop, for people interested 
in using this?

-- 

Patrick Dowler
Tel/Tél: (250) 363-0044
Canadian Astronomy Data Centre
National Research Council Canada
5071 West Saanich Road
Victoria, BC V9E 2M7

Centre canadien de donnees astronomiques
Conseil national de recherches Canada
5071, chemin West Saanich
Victoria (C.-B.) V9E 2M7