just basic RDS Postgres has been brilliant for my side project, 4 years without downtime
just 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
LThe max number is 25
LAnother topic, I think there is a bug in delete hyperdrive feature: after delete a hyperdrive, I can't create another hyperdrive with the same name, because it's already exists.
AKnown bug, the fix for that is releasing this week.
ASorry, I'm not following. Historically Hyperdrive has allowed 20 connections per region per Hyperdrive. What maximum are you referring to?
LThe maximum is 25 (right now I've 24, but I can see only 20)
AWhat maximum?
LThe quantity of Hyderdrive objects
AOh, you're referring to the number of Hyperdrive configs! Sorry, took me a second.
You can use the list API to see them all.
You can use the list API to see them all.
Lbut with wrangler hyderdrive list I can't see all
LAPI list by postman you say?
ANot sure why wrangler would be truncating those, I'll check with the team.
Any http client really. I just use curl
Any http client really. I just use curl
LOkki! I need retrieve de config Id... I'll try
AList API for your account should return the IDs as part of the json
MYou should be able to see multiple pages of results now (in the dashboard)
LYeah, thanks!
DThere’s also nice typescript bindings now.
You can see me using them here: https://www.ai.moda/en/blog/automate-hyperdrive-iam-auth-with-workers
You can see me using them here: https://www.ai.moda/en/blog/automate-hyperdrive-iam-auth-with-workers
AThis is fixed now.
FYI also @dave | ai.moda
FYI also @dave | ai.moda
AHey all! Today we released the final step in a fairly large rearchitecture of Hyperdrive. We'll be getting into the details in a full length blog post a little down the road, but for now here are the takeaways.
- All newly created Hyperdrives will perform substantially more efficiently. This goes double for users with the origin database in APAC.
- This should primarily manifest as lower latencies and fewer disconnects.
- This will affect all Hyperdrives with or without caching.
- We will be backfilling this solution to existing Hyperdrives progressively, over the course of the next couple weeks, starting next Monday. If you want yours handled sooner, please feel free to message me or respond in a thread here.
DI've done some search on this channel and it seems like cache busting/purging is still WIP? I ran into a bug today that took me awhile to figure out it was being caused by hyperdrive - user creates a comment, the query client then invalidates the comments query, it refetches the stale data causing my optimistic comment to disappear. This makes sense given hyperdrive caching. I'm just curious as to what my workaround should be given that cache purging isn't a thing (yet).
DIt'd be a little contrived for me to add some volatile function to the query given that it'd have to originate from the client and then drill through the api router and modify queries in a weird way
AThe alternative is likely just a second hyperdrive config with caching disabled, and direct your queries to whichever is appropriate at the application level.
Not a great alternative, we're aware.
Not a great alternative, we're aware.
Diirc
ORDER BY random()it'd also cause strange query results 
DStill no defined list of IP addresses that Hyperdrive connects from, right?
DTotally depends on what you're doing. If you are sorting by a date column, but are returning the date column anyway, you can sort it in JavaScript after.
DNot if you're paginating
DI just turned off caching for now, I'll wait until cache purging is shipped, I don't love modifying the application layer in weird ways to get expected query behavior
Dhmm, there's probably another trick you could use with random(). Like
WHERE random() >= 0;I think at that point it'd make more sense to just use a scond hyderdrive config with caching disabled for queries that you're doing that to
DIs there a reason why you aren't returning the comment in the same query where the user creates it?
DI am, but think about the user that gets a push notification and looks at their phone immediately, that comment won't be loaded in
Ddelay the notification by the cache duration?
DI think the two hyperdrive configs is a pretty good solution, since in my case it's really there's a set of resources that frequently are mutated and should never be cached, and sets of resources that can be cached
DCache purging would just allow optimization of this
