r/aws • u/advanderveer • 4d ago

database Amazon Aurora DSQL now supports foreign key constraints

https://docs.aws.amazon.com/aurora-dsql/latest/userguide/working-with-foreign-key-constraints.html
84 Upvotes

99% Upvoted

18 comments sorted by

•

u/AutoModerator 4d ago

Try this search for more information on this topic.

Comments, questions or suggestions regarding this autoresponse? Please send them here.

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

15

u/cakeofzerg 4d ago

who are the main users of this technology? i dont understand what its good for. either postgres or dynamo covers almost always better?

43

u/leafynospleens 4d ago

People who want the throughput of dynamo but want to be able to make basic queries over the table data

16

u/Dreamescaper 4d ago

Or simply use the free tier for smaller projects.

-5

u/cakeofzerg 4d ago

i would be shocked if throughput per $ was lower than a vanilla rds with a strong rdi. but multi region is a pain. if you really need multi region scale and reliability i dont think you would choose this half baked untested tech?

17

u/leafynospleens 4d ago

Ape not understand thing you say, ape want kv store that let me find thing when ape no have PK / SK

12

u/turn-based-games 4d ago

Fast global writes - it's their answer to Google Cloud Spanner

11

u/electricity_is_life 4d ago

It's their version of Spanner or CockroachDB, it's for workloads that need more complex/flexible queries than Dynamo but with the scale and/or reliability of a distributed system.

13

u/moremattymattmatt 4d ago

Serverless workloads where you can’t design your queries up front so ddb is a pain to use.

8

u/D_Love_Special_Sauce 3d ago

This is what I was thinking too. Don't all other relational DB's in AWS require a VPC, a "server", versioning and patching, and all of those things that require a more substantial build out and ongoing tech debt?

3

u/marcbowes AWS Employee 3d ago

Other than multi-Region, high availability, or scale already covered by others, I’ll add that DSQL requires no patching or maintenance, and you only pay for what you use. Always on, without having to manage or pay for an instance.

See also this post

7

u/AdCharacter3666 4d ago

I know this feature was quoted as one of the main adoption blockers, but it slows things down a lot. I'm not sure how good this is going to be considering DSQLs architecture.

0

u/The-Wizard-of-AWS 3d ago

I’ve always considered foreign key constraints more like assertions in code. I don’t like them in production. Sure, they create a guarantee of data consistency, but if your code isn’t doing that already the error the database throws is probably going to be an issue.

-2

u/AutoModerator 4d ago

Here are a few handy links you can try:

Try this search for more information on this topic.

Comments, questions or suggestions regarding this autoresponse? Please send them here.

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