search

CaltechOpticalObservatories / NGPS

NGPS Software
2 stars 0 forks source link

2 GAIA databases in use #24

Open chazshapiro opened 1 year ago

chazshapiro commented 1 year ago

I believe the A&G GUI uses the PostgreSQL database in /home/gaia to display star positions. Meanwhile, the astrometry solver now uses the (faster, bigger, simpler - no daemon) catsHTM database in /data/GAIA . Consider finding a way to remove PostgreSQL.

The conesearch command (in developer PATH) will query catsHTM and write the results to STDOUT and a CSV file:

$ conesearch RA DEC RADIUS <OUTPUTFILE> (all units in decimal deg)

E.g. $ conesearch 10 -10 .05 output.csv

jenniferwillow commented 1 year ago

Does this "other" copy also use a database interface? Can I access that directly as I do the Postgres version?

chazshapiro commented 1 year ago

No, probably need to use the command line.

This is not a priority since it's currently working as-is. I'm just taking a moment to take an inventory of various issues.