Rust sqlx: Use sqlx pooler or Neon pooler?

Rust crate

sqlx

sqlx

has a built in connection pool: https://docs.rs/sqlx/latest/sqlx/pool/index.html. You use it like this:

let pool = PgPoolOptions::new()
  .max_connections(5)
  .connect(database_url).await?;

let pool = PgPoolOptions::new()
  .max_connections(5)
  .connect(database_url).await?;

Should I just set

max_connections

max_connections

, and use the Neon pooler host? Or create some amount of connections with the

sqlx

sqlx

PgPool

PgPool

, and use the non-pooled Neon host? Or perhaps a combination of the two?

May not be a straightforward answer, and may be better suited for the

sqlx

sqlx

maintainers. But wondering if you had any ideas off the bat. To further complicate this, the Rust code here will be running from AWS Lambda.

Neon•2y ago•

4 replies

urgent-maroon