News for hackers. Stuff that matters.

A comment on Things I wished more developers knew about databases. Parent comment

Re:Things I wished more developers knew about databases by earhart on Wednesday April 22, 2020 @10:55AM (#22946174)
That gets tricky if one of the writes fails.
[ Parent | on HN ]
Re:Things I wished more developers knew about databases by hobs on Wednesday April 22, 2020 @10:59AM (#22946246)
Generally you get two phase commit involved here, or an asynch mirror that you can restore over if there's failure.
[ Parent | on HN ]
Re:Things I wished more developers knew about databases by smilliken on Wednesday April 22, 2020 @11:26AM (#22946548)
Two phase commit makes a promise it can't keep. CAP theorem is not amused.

It's slow, complex, a leaky abstraction, and ahould be avoided for better consistency models.

[ Parent | on HN ]
Re:Things I wished more developers knew about databases by hobs on Wednesday April 22, 2020 @11:31AM (#22946610)
I generally couldn't agree more, but yet its the first tool in the toolbox for a lot of databases.
[ Parent | on HN ]