Neon•2y ago

Serverless Driver for Java

Hey!

Has their been any plan to implement the Neon Serverless Driver for Java?

Creating a AWS Lambda Java Function and the normal JDBC connection takes 2 seconds for a mere initial connection. Looking for a way to get this down

Thanks

dangerous-fuchsia•1/8/24, 7:36 PM

It'd be awesome to see if we could make improvements in this space, but I'm not aware of anything on our short term roadmap. I wonder if using something like Quarkus and GraalVM could improve the startup time? Or is it purely the JDBC layer that is slow?

precious-lavender•1/8/24, 8:24 PM

The serverless driver is just a small wrapper around the HTTP API, right? As a stop-gap solution, you could also just use the HTTP API.

Ddangerous-fuchsia It'd be awesome to see if we could make improvements in this space, but I'm not ...

skinny-azureOP•1/9/24, 2:30 AM

Purely JDBC

Pprecious-lavender The serverless driver is just a small wrapper around the HTTP API, right? As a s...

skinny-azureOP•1/9/24, 2:31 AM

I knew it existed at some point, but I couldn't find in the documentation for the life of me

skinny-azureOP•1/9/24, 2:33 AM

Would you mind linking the documentation to that?

precious-lavender•1/9/24, 2:40 AM

Let me poke the team because I can't find it either

Pprecious-lavender Let me poke the team because I can't find it either

skinny-azureOP•1/9/24, 2:55 AM

Would appreciate that

awake-maroon•1/9/24, 9:27 AM

Sorry, documentation is still in the works. Give me a few minutes and I'll give you some pointers ...

awake-maroon•1/9/24, 9:33 AM

The basic idea is that you https POST some JSON to the endpoint of your DB host, with a header:

awake-maroon•1/9/24, 9:40 AM

This returns:

awake-maroon•1/9/24, 9:42 AM

There are two optional request headers to be aware of:

`Neon-Array-Mode: true` makes the `rows` object an array of arrays instead of an array of objects (e.g. the above becomes `[["hello world"]]` instead of `[{"greeting":"hello world"}]`). This saves some bandwidth, and you can still retrieve the column names from the `fields` field.
`Neon-Raw-Text-Output: true` disables parsing Postgres arrays into JSON arrays, so that the raw Postgres text format is always returned instead. For instance, try toggling `Neon-Raw-Text-Output` from `true` to `false` here:

awake-maroon•1/9/24, 9:55 AM

Lastly, you can submit multiple queries in one transaction with one POST request, using the header. For instance:

This returns:

awake-maroon•1/9/24, 9:56 AM

Obviously you can use other isolation levels, and there are also headers and available to further configure the Postgres transaction.

awake-maroon•1/9/24, 9:57 AM

Do note that at present the key is required, and should be an empty array if no parameters need to be passed.

awake-maroon•1/9/24, 10:01 AM

(Also, if you have installed, pipe all my

curl

curl

examples into that for much more readable output).

Aawake-maroon The basic idea is that you https POST some JSON to the `/sql` endpoint of your D...

skinny-azureOP•1/10/24, 12:15 AM

Appreciate it, thanks

Aawake-maroon The basic idea is that you https POST some JSON to the `/sql` endpoint of your D...

skinny-azureOP•1/10/24, 12:19 AM

How does this pair in with Prepared statement efficiency?

Aawake-maroon Lastly, you can submit multiple queries in one transaction with one POST request...

skinny-azureOP•1/10/24, 4:29 AM

How does the response look with an

UPDATE

UPDATE

skinny-azureOP•1/11/24, 4:56 PM

@Tristan Partin

Any idea?

precious-lavender•1/11/24, 5:32 PM

@Sword | Andrew let me ping internally

precious-lavender•1/11/24, 5:34 PM

I pinged jawj internally. Note you might not hear from them until next week though

precious-lavender•1/11/24, 5:35 PM

I haven't interacted with the HTTP API before. I think the best you can do if you don't want to wait is read the serverless driver code, which I know is not a great answer

awake-maroon•1/11/24, 5:55 PM

On prepared statements: you can't use prepared statements with the HTTPS transport. I think it's rare that this would be a problem unless you're running some truly enormous joins.

awake-maroon•1/11/24, 6:07 PM

On an UPDATE response, I can send this:

and get back:

Or I could use RETURNING:

And get:

awake-maroon•1/11/24, 6:18 PM

@Sword | Andrew Hope that helps.

Aawake-maroon On an UPDATE response, I can send this: ```sh curl -v 'https://ep-adjective-nou...

skinny-azureOP•1/11/24, 6:19 PM

That exactly what I needed, appreciate it

Aawake-maroon @Sword | Andrew Hope that helps.

skinny-azureOP•1/12/24, 5:03 AM