Skip to main content

Node.js with Vertica anyone?

  • May 16, 2013
  • 5 replies
  • 6 views
Klaus_Baumecker
Node.js is becoming a serious player for server-side development. The NoSQL wave has brought a lot of drivers into the Node package catalog. Now I wonder if someone has started playing with Node and Vertica and maybe has started developing a driver for it. Regards, klaus

    5 replies

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • May 21, 2013
    Hi Klaus, Yes, in fact, there's a Vertica driver in npm: https://npmjs.org/package/vertica It's not an official driver, and it doesn't appear to yet support all of Vertica's functionality. I also haven't actually used it, though I've used node.js. But it looks like it works. It'd be great if you could try it out and post your experiences here.
    RobertA
    • RobertA
    • New Participant
    • November 13, 2015

    i tried to use it but ran into this issue:

     

    Auth invalid password when using MD5 password

     

    Apparently support for that is lacking

     

    https://github.com/wvanbergen/node-vertica/issues/13

    Pieter_Sheth-Vo
    Forum|alt.badge.img+2
    • Pieter_Sheth-Vo
    • Participating Frequently
    • November 15, 2015

    I've found thatNode-vertica library works great and also used that  driver against PostgresQL.  The author of the library once pointed out that Vertica is a fork of PostgresQL and you can actually use Postgres drivers directly with Vertica.  So you might try https://github.com/brianc/node-postgres as it supports MD5.

     

    RobertA
    • RobertA
    • New Participant
    • November 16, 2015

    ok - i will give it a shot - thanks

    Pieter_Sheth-Vo
    Forum|alt.badge.img+2
    • Pieter_Sheth-Vo
    • Participating Frequently
    • February 24, 2023

    Updating an old post, there is now an official Vertica Node.js driver.

    It supports both current ES6 syntax (with "import" and "async/await") as well as conventional Node.js syntax (with "require" and callback functions). It supports individual connections and pools. I didn't write it, just happy to see it and see it work simply .

    https://github.com/vertica/vertica-nodejs
    https://www.vertica.com/docs/12.0.x/HTML/Content/Authoring/ConnectingToVertica/ClientNode/ClientNode.htm
    https://www.vertica.com/blog/announcing-the-availability-of-vertica-javascript-driver-vertica-nodejs/

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement