search

sosedoff / pgweb

Cross-platform client for PostgreSQL databases
https://sosedoff.github.io/pgweb
MIT License
8.53k stars 724 forks source link

Documentation for hosting pgweb in cloudrun #655

Closed anovis closed 1 year ago

anovis commented 1 year ago

First off great project. I was able to host pgweb in GCP's Cloudrun with a connection to Cloudsql using a cloudsql connector. This took me way too long, but think this is a great use case that I would like to share back. Would you like me to add a pr to the readme adding some info or add something to the wiki.

Essentially I was able to host a completely serverless solution on GCP in Cloudrun (super cheap) and used IAP for the auth layer.

I am also planning on writing a quick blog on medium, so could always just link there.

sosedoff commented 1 year ago

I currently disabled WIKI edits to collaborators only due to rogue edits. If you have a writeup - you can submit it in here with a link to your gist (or whatever).

anovis commented 1 year ago

Ended up posting the writeup to medium. Feel free to include wherever, or if you have any questions on it. hopefully it can be useful for some people.

https://engineering.premise.com/hosting-a-fully-serverless-web-based-postgres-admin-client-on-gcp-using-pgweb-cloud-run-iap-cff0ce8f471b

sosedoff commented 1 year ago

Added https://github.com/sosedoff/pgweb/wiki/Community-Resources