There's Amazon Aurora DSQL too

daveOP•1/30/25, 5:06 AM

That said, I found the limitations too hard to work with.. Takes away a lot of the things I love about using PostgreSQL (making sure I don't shoot myself in the foot).

daveOP•1/30/25, 5:07 AM

AWS RDS Aurora Serverless v2 is my goto. Scales to zero as well, which is very nice for dev instances

Agung Vivekananda•1/30/25, 8:00 AM

Hello,
Currently i'm using hyperdrive with direct connection to supabase.

But sometimes i got Database error: Error: write CONNECTION_CLOSED 86ec870f264501983a0.hyperdrive.local:5432

it its any fix for this? Or the problem its on supabase

Ddave There's Amazon Aurora DSQL too

AJR•1/30/25, 12:09 PM

They do actually work over Hyperdrive, that one we checked. The needing to refresh an IAM token every 7 days isn't great though, we'd need to build some AWS IAM integrations to automate that to really call them "supported", imo.

AAJR They do actually work over Hyperdrive, that one we checked. The needing to refre...

daveOP•1/30/25, 5:50 PM

That's pretty easy to do. I already wrote a function for refreshing the IAM token, so I'd just need to use one of these endpoints to update it every 24 hours (to be safe to avoid long lasting connections from expiring).

https://developers.cloudflare.com/api/resources/hyperdrive/subresources/configs/methods/edit/

https://developers.cloudflare.com/api/resources/hyperdrive/subresources/configs/methods/update/

What's the difference between edit and update?

Cloudflare API | Hyperdrive › Configs › Patch Hyperdrive

Interact with Cloudflare's products and services via the Cloudflare API

Cloudflare API | Hyperdrive › Configs › Update Hyperdrive

Interact with Cloudflare's products and services via the Cloudflare API

Ddave That's pretty easy to do. I already wrote a function for refreshing the IAM toke...

AJR•1/30/25, 5:51 PM

PATCH vs PUT. PATCH will only update the things that were changed. PUT will update/overwrite the whole config, and trigger revalidation.

More practically, it's because PATCH in terraform is a pain so we felt it would be most efficient to just have both.

AAJR PATCH vs PUT. PATCH will only update the things that were changed. PUT will upd...

daveOP•1/30/25, 5:52 PM

ah, so I'd want to use PATCH here?

AJR•1/30/25, 5:54 PM

IIRC refreshing the token gives you a new DSQL connection string, so there's not much difference between them in this scenario. New conn string will trigger revalidation anyways, since that's the stuff that affects whether hyperdrive can still connect.

AJR•1/30/25, 5:54 PM

The dash uses PATCH, can't change anything there that would change our ability to connect so it can skip the revalidation traffic.

AAJR IIRC refreshing the token gives you a new DSQL connection string, so there's not...

daveOP•1/30/25, 5:55 PM

I only need to update the the password. Everything else stays the same.

AJR•1/30/25, 5:55 PM

Ah, neat. I misunderstood what DSQL was doing there.

Same answer though. Typos when entering a password is like half the reason that we do the config-time validation in the first place.

AAJR IIRC refreshing the token gives you a new DSQL connection string, so there's not...

daveOP•1/30/25, 5:56 PM

To confirm, does changing the password with either PATCH or PUT cause a trigger revalidation?

AJR•1/30/25, 5:58 PM

Yes it does.

daveOP•1/30/25, 5:59 PM

cool, I'll do a blog post on it.

AJR•1/30/25, 5:59 PM

Nice! Share it here and we'll repost it around, if you like.

daveOP•1/30/25, 6:00 PM

ya I'm doing it for the SEO, so please do share and ideally link.

AJR•1/30/25, 6:00 PM

Don't hate the player, hate the game.

daveOP•1/30/25, 6:48 PM

@AJR Is there a way I can create a Hyperdrive without needing a valid password?

AJR•1/30/25, 6:49 PM

No, there is not.

daveOP•1/30/25, 6:55 PM

btw, so happy that the permissions required now shows up in the API docs!!

daveOP•1/30/25, 6:55 PM

I think this is new?

AJR•1/30/25, 6:56 PM

There was a big docs revamp recently, if I recall. All generated from our internal schemas. Very slick, and much less toil on our end. I really appreciate that team shouldering the project.

daveOP•1/30/25, 7:00 PM

I was going to hassle you to ask you about what permissions were neated, but nope, not needed!

daveOP•1/30/25, 8:05 PM

@AJR Sanity check, what does InactiveInactive mean?

Ddave @AJR Sanity check, what does `Inactive` mean?

AJR•1/30/25, 8:06 PM

No queries in the last.... 24 hours? Hang on let me check. No recent traffic, in any case.

AAJR No queries in the last.... 24 hours? Hang on let me check. No recent traffic, ...

AJR•1/30/25, 8:08 PM

Ah, yeah. Last 24 hours.

daveOP•1/30/25, 8:53 PM

A Hyperdrive config with the given name already existsA Hyperdrive config with the given name already exists

daveOP•1/30/25, 8:53 PM

am I not allowed to reuse names?

AAJR Nice! Share it here and we'll repost it around, if you like.

daveOP•1/30/25, 9:58 PM

https://www.ai.moda/en/blog/automate-hyperdrive-iam-auth-with-workers

ai.moda

Automate Hyperdrive IAM Authentication with Workers

Learn how to automatically manage rotating credentials and AWS IAM tokens for PostgreSQL databases using Cloudflare Workers and Hyperdrive.

Ddave am I not allowed to reuse names?

AJR•1/30/25, 10:09 PM

Correct! We enforce unique names. We don't use it for any actual logic in Hyperdrive itself, but it makes life way simpler for things like wrangler or the dash

AAJR Correct! We enforce unique names. We don't use it for any actual logic in Hype...

daveOP•1/30/25, 10:10 PM

even after deleting?

AJR•1/30/25, 10:10 PM

No, should be fine after deleting...

AJR•1/30/25, 10:12 PM

Hmmmm. I see what happened here. I'll file a bug. Thanks for the catch

Ddave https://www.ai.moda/en/blog/automate-hyperdrive-iam-auth-with-workers

AJR•1/30/25, 10:20 PM

Nice, very well written. Let me crosspost that a bit.

James•1/31/25, 12:27 AM

We're seeing a spike of errors causing postgrespostgres to internally explode: https://i.james.pub/file/2025/01/d4f49e0e-2876-40a2-98e3-a84eaa719bdc.png. DB ID edbe490e790c44389774f0c88667e221edbe490e790c44389774f0c88667e221. Anyone else?