Node.js with Vertica anyone?

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

[Deleted User]

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

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

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

ok - i will give it a shot - thanks

Pieter_Sheth-Vo

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/