ASPCS
 
Back to Volume
Paper: PostgreSQL: the Suitable DBMS Solution for Astronomy and Astrophysics
Volume: 314, Astronomical Data Analysis Software and Systems XIII
Page: 225
Authors: Chilingarian, I.; Bartunov, O.; Richter, J.; Sigaev, T.
Abstract: PostgreSQL, the open-source ORDBMS, is one of the best solutions for science. Compared to several available commercial and non-commercial database engines, it appears to be the most versatile. Extensibility is the most remarkable feature of PostgreSQL -- it allows to develop custom data types, queries and indexed access methods, optimized for specific tasks. We present two contribution modules for PostgreSQL: pgSphere, offering the capability for dealing with geometrical objects in spherical coordinates, and pgAstro, based on the pgSphere, providing astronomy-specific functions and methods.
Back to Volume