SQLite Query Language: upsert

Re:SQLite Query Language: upsert by jedberg on Thursday May 10, 2018 @04:23PM (#17042625)

I would say in this day of high scalability and microservices, a good engineer should be skilled at dealing with these types of errors, as they would be one of the most common types.

Edit: I find it interesting that this comment has fluctuated between -2 and +2 points. Apparently saying that engineers should be able to handle concurrency errors is controversial?

[ Parent | on HN ]

Re:SQLite Query Language: upsert by anarazel on Thursday May 10, 2018 @04:27PM (#17042661)

I bet that at least 9/10 experienced engineers in the space will come up with a solution that has at least one of a) incorrect behaviour under concurrency b) unnecessary deadlocks c) extreme slowness d) break w/ triggers, row level security etc.

[ Parent | on HN ]

Re:SQLite Query Language: upsert by anarazel on Thursday May 10, 2018 @05:42PM (#17043222)

> Apparently saying that engineers should be able to handle concurrency errors is controversial?

I didn't vote either way. But perhaps it's less the fact that they should be able to handle concurrency, and more that replicating the necessary non-trivial logic in several applications isn't a good plan.

[ Parent | on HN ]