Support for issuing prepared statements?

[awinder]

Vertica supports prepared statements as a means of optimizing queries and providing some convenience / security benefits as of the 6.x branch (https://my.vertica.com/docs/6.1.x/HTML/index.htm#11677.htm). Is this supported in node-vertica? I saw some use of the string "prepared_statement" in the FrontendMessage class, but I was having trouble groking how this would be used (or if it was even applicable).

[wvanbergen]

When I first implemented it, it was broken on the vertica server. It only supported prepared statements with 0 parameters. Becuase that's useless, and to protocol with prepared statements is a lot more complicated, I decided to remove the implementation completely.

Not sure what version I was developing against, either 5.1 or 6.0 at the time. Maybe it is supported now.

[RickCSong]

@wvanbergen Attempted to implement prepared statements for Vertica 7.1 today. Appears to still be broken :( (i.e., only supports prepared statements with 0 parameters).

[wvanbergen]

Too bad :(

[amirtuval]

Hi Guys

I'm testing Vertica's performance, and I think having prepared statements - even without parameters - may improve performance for my use case.

Can you provide some pointers on how to implement prepared statements with the given protocol?

Thanks

[wvanbergen]

It should follow the PostgreSQL protocol: https://www.postgresql.org/docs/9.2/static/protocol-overview.html#PROTOCOL-QUERY-CONCEPTS

I managed to get it to work for 0 parameters, but when using parameters it would fail. I assume this has not changed.

[amirtuval]

I was able to get it to work - I investigated how the vertica jdbc driver does it.
Sent a pull request for it.