{"repo":"segasai/q3c","free":true,"listed":false,"github":"https://github.com/segasai/q3c","clone":"git clone https://github.com/segasai/q3c.git","description":"PostgreSQL extension for spatial indexing on a sphere","language":"C","stars":90,"topics":["postgresql","sphere","astronomy","nearest-neighbors","query","coordinates"],"license":"GPL-2.0","category":"databases-storage","readme_excerpt":"Q3C Author: Sergey Koposov, University of Edinburgh Copyright (c) 2004-2026 Sergey Koposov Email: skoposov AT ed DOT ac DOT uk Fresh versions of the software could be obtained here: https://github.com/segasai/q3c To read more about the Q3C indexing, you can check out the paper published in ADASS conference proceedings http://adsabs.harvard.edu/abs/2006ASPC..351..735K The citation is \"Koposov, S., & Bartunov, O. 2006, Astronomical Society of the Pacific Conference Series, 351, 735\". Q3C is also registered in the ASCL library https://ascl.net/1905.008 . If you use Q3C, you are kindly asked to cite the 2006 paper. I am also always happy to hear about any usage of Q3C. Prerequisites In order to use Q3C you need to have a PostgreSQL database installed (version 9.1 or later). If you have PostgreSQL version lower than 9.1, you will need to use an older version of Q3C (1.4.x). To successfully compile Q3C you must have pg config in your PATH (that means that you may need to install the -devel versions of PostgreSQL packages) Installation - make - make install - Execute \"CREATE EXTENSION q3c\" in the PostgreSQL client(psql) for the database where you plan to use q3c After the installation you will have several new functions in PostgreSQL. All names of these functions start with the \"q3c \" prefix. Updating If you are updating from previous version of q3c, you still need to do the make, make install steps, but after that you need to do - ALTER EXTENSION q3c UPDATE TO 'A.B.C'; instead of '","default_branch":null,"files":null,"tree":[],"storefront":"/r/segasai","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/segasai/q3c/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}