I am trying to set up a connection to an RDS Postgres DB that is in a VPC. I believe I have set everything up that I need. I am able to select the instance ID of the relevant DB from the select list. But when I try and select a connection type it says “chose a VPC connection” but I don’t get any options.
So I have created a Python script that writes the data to a local DB. My original idea was to port all of this to AWS and do the reports in Quicksite. I think it might make sense to put my data elsewhere. Is there a particular technology that you would recommend for that? Something that would be secure and scalable. Right now there isn’t that much data, maybe 10-20k rows and another table with maybe 1-200k rows.