Skip to content
Sign in
Artwork for My Weird Prompts
My Weird Prompts · Monday · 28 min

Connecting Postgres to Google Workspace

Rita runs a two-person business on Google Workspace and wants a real business layer on top of it. This episode walks through the integration architecture: why PostgreSQL owns the relationships while Google stays authoritative for documents, messages and events; how service accounts and domain-wide delegation actually differ; and why service accounts can't own Drive files — a constraint that forks the entire folder design. Plus the real costs of Cloud Run plus Cloud SQL, and what Google's new Workspace API quotas mean for small firms. Episode 5909 — myweirdprompts.com/n/5909 (permanent short link: myweirdprompts.com/133931)

0:00 · Intro-28:29
Play in
Transcript file

transcript

No transcript — this publisher did not publish one.

show notes

Rita runs a two-person business on Google Workspace and wants a real business layer on top of it. This episode walks through the integration architecture: why PostgreSQL owns the relationships while Google stays authoritative for documents, messages and events; how service accounts and domain-wide delegation actually differ; and why service accounts can't own Drive files — a constraint that forks the entire folder design. Plus the real costs of Cloud Run plus Cloud SQL, and what Google's new Workspace API quotas mean for small firms.

Episode 5909 — myweirdprompts.com/n/5909 (permanent short link: myweirdprompts.com/133931)

chapters

5 chapters

more episodes

All episodes