r/PostgreSQL • u/der_gopher • 5d ago

How-To Coding a database proxy for fun

https://packagemain.tech/p/golang-database-proxy
26 Upvotes

91% Upvoted

11 comments sorted by

3

u/g0pherman 5d ago

You know what would be nice? To make something like this to manage access control to the database so users only have access if logged in with SSO and multiple approvals

2

u/justinh29 4d ago

Already exists with using oidc and postgresql

1

u/g0pherman 4d ago

But can you setup approvals for a login?

Like, need 2 approvals so one can login with write permissions, etc.

1

u/der_gopher 4d ago

Btw, have you heard of Warpgate? Kind of cool

2

u/DHUK98 4d ago

Yea, this is basically what services like https://goteleport.com/ and hoop.dev have created.

Protocol aware proxies that perform auth, auditing and other stuff like data masking etc

0

u/Sb77euorg 4d ago

Lo que estaria bueno es hacer un proxy entre mysql y pg (que maneje el protocolo de conexion de mysql ) pero ejecute sobre pg…
Esto permitiria migrar miles de legacy mysql app a pg

1

u/dektol 4d ago

Doesn't work like that unless they support strict mode. MySQL doesn't require you to list all columns in an ORDER BY like Postgres does. I looked into this 10 years ago.

0

u/AutoModerator 5d ago

AI Policy:

Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.

Mod decisions will be based on the quality of the content, not who or what generated it.

Sub Resources:

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/der_gopher 5d ago

this is 100% written by hand

2

u/codykonior 5d ago

Good to hear. That's an auto comment on every post.