Hey all, hope you're doing well. Looking for opini...
# help
j
Hey all, hope you're doing well. Looking for opinions. I want to build a web app and I'm shopping around. SST looks great so far and is something I'd be interested in trying. But this is my concern. I have a hard requirement to use RDS (not aurora serverless) for my DB and I can't find an SST example for that yet. Since I want to develop with lambdas and use SST at its fullest, is this supported (e.g. lambda debugging)? Is it feasible? Does it make for a good developer experience, compared to developing with a regular web framework? Would really appreciate to hear your thoughts. Thanks in advance!
t
We have a lot of folks in here who use RDS! There's nothing particular with SST that makes it harder to use RDS but there are a few constraints you should be aware of. • Lambdas will need to be a VPC for production - SST lets you conditionally put them in a vpc for relevant stages • For local development your RDS cluster should be placed outside of a VPC, again easy to do in SST. This is so your functions can talk to it. • Alternatively for local development you can also use a local postgres instance (through docker or whatever) • You likely want to setup Data Proxy as well - this is fairly trivial to do in sst and I can send you some sample code Generally we recommend using aurora serverless if you're using serverless. It uses an HTTP based data api which hides all connection management issues away from you. It also is secured through normal IAM so your lambdas don't need to be in the same vpc
j
Alright, seems worth a try. And absolutely, all code samples are welcome. : ) Thanks a lot for the detailed response!
s
Hey John, I use SST with RDS for Postgres. I have my lambdas within the vpc during development (I'm on a VPN) and it works well. I found it tricky to set up, but that was due to me having to learn more about AWS networking, not SST. Although, some of that could be avoided by placing the lambdas outside the vpc as @thdxr recommends. I've also used a local docker container with Postgres installed, which also worked well. Plenty of us do this, so don't be shy about asking questions as you get started. It's a pretty awesome setup!
j
Got it. I'm mostly new to most of the AWS stuff, so I have plenty of look ups to perform first. Thank you!