NeonN
Neon•15mo ago•
4 replies
urgent-maroon

Rust sqlx: Use sqlx pooler or Neon pooler?

Rust crate 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?;

Should I just set max_connections to 1, and use the Neon pooler host? Or create some amount of connections with the sqlx 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 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.
Was this page helpful?