Re:Ask HN: How do you deploy your weekend project in 2022?
by 1776smithadam on Friday September 09, 2022 @01:26PM
(#32782254)
We just posted our first Show HN ever with your exact same setup, but s/python/go. If you're running it in Docker, then this might work for you too:
1) CloudRun ( run a Docker container exposing a port to the web )
It can autoscale.
2) CloudSQL ( managed Postgres and some other SQL choices )
We faced some friction getting the two connected. CloudSQL is available on an IP address, then in our code we have PSQL library which we specify the IP address to. The complication was that CloudRun instances can't actually "see" the CloudSQL. After navigating the GCP documentation, website, and some trial and error, it magically worked.
It was painful to get setup but it's running smooth now.
1) CloudRun ( run a Docker container exposing a port to the web )
It can autoscale.
2) CloudSQL ( managed Postgres and some other SQL choices )
We faced some friction getting the two connected. CloudSQL is available on an IP address, then in our code we have PSQL library which we specify the IP address to. The complication was that CloudRun instances can't actually "see" the CloudSQL. After navigating the GCP documentation, website, and some trial and error, it magically worked.
It was painful to get setup but it's running smooth now.