Skip to main content

Using PostgreSQL connection

  • October 3, 2017
  • 1 reply
  • 4 views
malachheb

Hi,
I trying to connect a REST API developed with Ruby to vertica database.
I found a ruby gems for vertica connection but it's not a vertica official project and it's not too match used, so we can't use it in production latre.
I think vertica is compatible with PostgreSQL but not 100%.
It's safe to use a PostgreSQL ruby connector for vertica ( only for select queries ) ?
if no, what is the disadvantage of using a PostgreSQL connector ?

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • October 4, 2017

    Hi,

    I use a PostgreSQL connector to interface with Vertica from a development tool called XOJO without issue. There could be times where the driver expects a schema to exist, but as a work around, you can create it in Vertica. Although, I have not seen that issue with recent PostgreSQL drivers.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement