I was asked this question in an interview and was unable to answer it. How does FB messenger order the messages on user side when two messages are concurrent in order to avoid view difference in di...

I tried the following code as a naive attempt to implement swapping of R and B bytes in an ABGR word #include <stdio.h> #include <stdint.h> uint32_t ABGR_to_ARGB(uint32_t abgr) { ret...

So I've read here: https://mcmap.net/q/109883/-is-it-legal-to-use-the-increment-operator-in-a-c-function-call that this is illegal: foo(i++, i++); But I believe that's because there is not a for...

According to C++14 [expr.call]/4: The lifetime of a parameter ends when the function in which it is defined returns. This seems to imply that a parameter's destructor must run before the code ...

I'm playing around with calculating Levenshtein distances in Haskell, and am a little frustrated with the following performance problem. If you implement it most 'normal' way for Haskell, like belo...

I have created a function that reads lists of ID pairs (i.e. [("A","B"),("B","C"),("C","D"),...] and sequences the ID's from start to finish including any branches. Each list of ordered ID's is he...

I've got a mysql table where each row has its own sequence number in a "sequence" column. However, when a row gets deleted, it leaves a gap. So... 1 2 3 4 ...becomes... 1 2 4 Is there a nea...

The following code works and creates a temporary table with a sequence number which is restarted for every new name: with results as (select row_number() over (partition by name order BY name) as ...