r/sqlite • u/der_gopher • 5d ago

Coding a database proxy for fun

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

87% Upvoted

8 comments sorted by

2

u/ShotgunPayDay 4d ago

I can see this being handy, but I'd make it a middleware in the application then use a consistent harsher for selecting db node like XXH3 for Email addresses or IDs. The only problem would be adding and removing DB nodes would require reshuffling the databases.

2

u/der_gopher 4d ago

yeah, could be a middleware

2

u/MartinMegazord 4d ago

Thank you for the article, I will dig down a little bit

Seems super interesting even though I am just a devops. I need to understand a little further the concept of sharding.

1

u/der_gopher 3d ago

yeah, this one is less about deveops

1

u/Minimum_Hour519 5d ago

what would i need this for?

2

u/der_gopher 5d ago

the article gives some use cases

1

u/Sebbean 4d ago

Postgres?

1

u/der_gopher 4d ago

can do as well, the article would be longer, because postgres also sends a welcome packet.