News for hackers. Stuff that matters.

A comment on The surprisingly difficult problem of user-defined order in SQL. Parent comment

Re:The surprisingly difficult problem of user-defined order ... by recursive on Saturday January 16, 2021 @12:09AM (#25800221)
Just make sure there's no competing edits going on at the time that might cause a race.
[ Parent | on HN ]
Re:The surprisingly difficult problem of user-defined order ... by tehjoker on Saturday January 16, 2021 @02:30AM (#25800758)
That's what a transaction is for.
[ Parent | on HN ]
Re:The surprisingly difficult problem of user-defined order ... by bboreham on Saturday January 16, 2021 @03:24AM (#25800927)
Edits are done by the UI. You do transactions in your UI?
[ Parent | on HN ]
Re:The surprisingly difficult problem of user-defined order ... by recursive on Saturday January 16, 2021 @11:19AM (#25803195)
I do transactions for sensitive edits that are triggered from the UI. The UI itself doesn't have a database connection though.
[ Parent | on HN ]