Nice! Share it here and we'll repost it around, if you like.
Nice! Share it here and we'll repost it around, if you like.
Dya I'm doing it for the SEO, so please do share and ideally link. 
ADon't hate the player, hate the game.
D@AJR Is there a way I can create a Hyperdrive without needing a valid password?
ANo, there is not.
Dbtw, so happy that the permissions required now shows up in the API docs!!
DI think this is new?
AThere 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.
DI was going to hassle you to ask you about what permissions were neated, but nope, not needed!
D@AJR Sanity check, what does
Inactive
ANo queries in the last.... 24 hours? Hang on let me check. No recent traffic, in any case.
AAh, yeah. Last 24 hours.
DA Hyperdrive config with the given name already existsuh
Dam I not allowed to reuse names?
Dai.moda
Learn how to automatically manage rotating credentials and AWS IAM tokens for PostgreSQL databases using Cloudflare Workers and Hyperdrive.
ACorrect! 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
Deven after deleting?
ANo, should be fine after deleting...
AHmmmm. I see what happened here. I'll file a bug. Thanks for the catch
ANice, very well written. Let me crosspost that a bit.
JWe're seeing a spike of errors causing
postgresedbe490e790c44389774f0c88667e221
DIn what timeframe?
Jstarting around 25 minutes ago, at 00:07 UTC. It's looking like our DB at Neon might be the cause here though and not Hyperdrive
Dah yeah, that's Neon for you.
DI would recommend looking at AWS RDS Aurora Serverless v2. It's really nice IMO.
Dwe did have PostgreSQL errors around this time, but I don't know if it was the database or Hyperdrive causing the errors.
ALet me take a look
A@James what's your Hyperdrive ID?
ANot seeing anything widespread in our logging or metrics
Jedbe490e790c44389774f0c88667e221- but after disabling Hyperdrive it looks like we're just timing out to Neon us-east-2
JSo not a Hyperdrive issue thankfully, but thank you
ASucks, hope you get it sorted.
II checked Neon's status page and there's nothing, annoying that there's random errors :\
Mjust basic RDS Postgres has been brilliant for my side project, 4 years without downtime
DLook at switching to Aurora Serverless v2; it now supports scaling to zero, which is great for side projects that don't need to be on all the time. (Takes <30 seconds to turn back on.)
https://aws.amazon.com/blogs/database/introducing-scaling-to-0-capacity-with-amazon-aurora-serverless-v2/
And it also has zero-downtime patching (ZDP)!
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.MinorUpgrade.html#USER_UpgradeDBInstance.PostgreSQL.Minor.zdp
https://aws.amazon.com/blogs/database/introducing-scaling-to-0-capacity-with-amazon-aurora-serverless-v2/
And it also has zero-downtime patching (ZDP)!
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.MinorUpgrade.html#USER_UpgradeDBInstance.PostgreSQL.Minor.zdp
HI don't know if I'm looking in the right place, but $132.54 a month for a Side Project seems very expensive...
DShould be $43.8/m for 0.5 ACUs (assuming you never scale to zero) + $3.65/m for IPv4. Then there's some extra costs for bandwidth and I/O, but it's pretty small for (most?) workloads.
HYeah, idk what Max is running, but side project, in my mind at least, is something that would fit on a free-tier Supabase/Xata/Neon(also since you probably don't need redundancy or other jazz)
HIf you bundled many projects together onto a single database, it might be more worth it, but imo it's still a lot more pricy than the hobby alternatives.
DNeon is $69/m for 750 hours
HNot necessarily? You should be fine for a whole month if you go 0.25 vCPU, 2 GB RAM. Or, too, there is the scale to zero, which again, for a side project, you might not need 24/7 uptime
HI sure know every project I have deployed(other than WDOL) has DBs cold-starting, because I definitely don't have enough usage to keep them alive all the time. YMMV may vary of course, depending on your project
DRDS can scale down to about $5/m in that case though.
DAh agreed, if you want a bunch of separate instances/projects, Neon is cheaper for dev use.
DIs it possible for Hyperdrive to pool connections from different databases if the username/password is the same? Or is this a PostgreSQL limitation?
DAnswer: PostgreSQL limitation.
AWell, we get to cheat a little, with the runtime-generated connection strings.
We probably could if we wanted to. Not saying it's something we'll do, but I'm curious and have never considered that before. What would be the use case for something like that?
We probably could if we wanted to. Not saying it's something we'll do, but I'm curious and have never considered that before. What would be the use case for something like that?
FI just entered the app, I don’t understand anything yet
LHi, I can see only 20 hyperdrive connections's on Cloudflare Console. There is any way to see all of them?
LWith wrangler's command, I can't see more than 20 too