search

gmantele / vollt

Java libraries implementing the IVOA protocol: ADQL, UWS and TAP
http://cdsportal.u-strasbg.fr/taptuto/
29 stars 28 forks source link

PostgreSQL version #111

Open scvsa opened 5 years ago

scvsa commented 5 years ago

Which is the latest tested/recommended PostgreSQL version and JDBC driver for the taplib?

gmantele commented 5 years ago

I tried with different versions: 9.1, 9.4, 9.6 and 10. I never had any issue.

The only important point is to ensure that you have the JDBC driver matching the version of PostgreSQL (and Java, of course) that you are using.

scvsa commented 5 years ago

Thank you for clarification. Regarding the postgres extensions/ modules, is something needed?

gmantele commented 5 years ago

If you need to use geometries (e.g. POINT, CIRCLE, CONTAINS, ...), I recommend to install the extension PgSphere. It is working well with taplib. Another option would be Q3C....but I do not know it very well and I do not provide any translator for it (but it is very easy to write ; if needed I could help and then benefit from this experience to enrich taplib)