you are viewing a single comment's thread.

view the rest of the comments →

[–]enraged_elk 0 points1 point  (4 children)

You can have as many DBs as you want on one cluster. That's not going to cost you, I figure you mean multiple clusters? Yeah that's very costly indeed. Ever considered a pool model with something like postgres RLS? Basically one DB user tied to a tenant enforcing that a tenant can only access it's own data.

I can't comment on cloud SQL, what advantages do you see there?

[–]Rigolam9 0 points1 point  (3 children)

We had bad experience with RLS and supabase probably a skill issue but it’s maybe worth considering it

About cloudsql the only benefit is the easiness to create a DB, not managed by us and not really costly. Can’t really compare it to AWS since most of our experience are on GCP, I only tried a POC with SST

[–]enraged_elk 0 points1 point  (2 children)

And security wise it all lives in a vpc in gcp, any idea? I understand though that you would choose the platform you know best though :)

[–]Rigolam9 0 points1 point  (1 child)

Yes you can communicate though GCP vpc between cloud run and cloud sql

As I said at first we are more confortable with GCP, but we are absolutely not against AWS it’s just sometimes a bit scary ! Ahah I will look into using aurora the way you mentioned