Viewing profile — isignal

Two concurrent deductions of inventory do contend but only during the actual DB update. That is just normal DB locking for SQL isolation levels. The blog refers to explicit locking…

Yes, at a high level. It doesn't rely on skip locked, which is not cheap at DB level. DB has to still typically run query and keep going until it finds an unlocked item. Deducting …

It seems there could be a simpler solution. 1. Deduct the reservation from the inventory when the user starts to order, but in the same txn also maintain a separate row for the in …

The EB5 visa, by comparison, has much more clear requirements. It is not sure if this intended as a backdoor to EB5 or a replacement.

There already was such a system with more concrete requirements. It is called the EB5 visa and has a path to green card. What does this new method bring to the table?

Processes can die independently so the state of a concurrent shared memory data structure when a process dies while modifying this under a lock can be difficult to manage. Postgres…

Thanks for the pointers!

Aren't the alternatives you mentioned - icerberg and duckdb - both storage solutions while spark is a way to express distributed compute? I'm a bit out of touch with this space, is…

https://www.patentlyapple.com/2024/04/apple-now-makes-14-of-... You are incorrect. > Apple Inc has assembled $14 billion worth of iPhones in India in fiscal 2024, Bloomberg News re…

Postgres supports indexing an arbitrary json document. https://www.postgresql.org/docs/current/datatype-json.html Not sure if the query capabilities and syntax match azure docdb bu…

The transaction log maintained from time 0 would be equivalent but too expensive to store compared to the tables.

Resale values are lower in US because they factor in the 7.5k USD tax credit and the state tax credit mostly, there is plenty of demand for used teslas for example.

Consumer side can allow you to run ads and get Google like revenue in the future.

Intel also had a later chance when Apple tried to get off the Qualcomm percent per handset model. This was far after the original iPhone. Apple also got sued for allegedly sharing …

Are they cheekily quoting the CEO who made a similar statement last week?

Just a note that this requires the admin to enable linger if the units need to be started before the user logs in and run after they logout.

Microsoft, Facebook, google, Apple, Amazon etc are all hugely profitable companies. If anyone can afford to ride out wall streets short term thinking, it is them.

For a key value store you expect server side latencies less than 5 ms for point gets and writes.

Even if wages did catch up, retired folks are permanently disadvantaged. There’s a reason why the Fed targets a low inflation rate by default than letting it float freely.

Body scan meditation is one particular form of meditation that I’ve found effective for sleep.

He did condemn the attacks, not sure why you think he didn’t take the context into account. https://twitter.com/paddycosgrave/status/1713659060153618680

Is it a leak driving this? Trudeau apparently brought it up in the G20 summit so it wasn’t a last minute call. I would expect internal pressure from his political partners.

Where there’s lack of sleep, willpower is one of the first things to be affected. So the authors advice only applies in a narrow set of cases. Exercise, for example, might be a bet…

Wouldn’t say they missed the boat. ISRO did launch some of the OneWeb constellation recently https://en.m.wikipedia.org/wiki/NewSpace_India_Limited It’s just a slow ramp up. India’…

Yes, that part is unfortunate. It requires full routing number and account number. Maybe the phone number to account number mapping might be seen as a privacy risk in USA.