bijowo1676

5 ms·

31.
by bijowo1676 2mo ago
Great move for AWS, does it mean AWS wants to build competitor to clickhouse ?
32.
by bijowo1676 2mo ago
US is running a more than a Trillion dollar trade deficit, what do you think happens when other countries will demand something real, like Gold, instead of freshly printed dollar? does US have a trillion dollar worth of Gold reserves every
33.
by bijowo1676 2mo ago
if other people stop accepting your printed currency, it quickly turns into Weimar or Zimbabwe
34.
by bijowo1676 2mo ago
US can always print currency to cover existing debt, the problem is convincing investors to keep lending money to the US and keep buying US bonds
35.
by bijowo1676 2mo ago
How much did anthropic pay to book publishers, and everybody else whose content they stole, for stealing their content ???
36.
by bijowo1676 2mo ago
The cheerleading part was a human consent to spend more tokens and explore the space I would love to see the breakdown on token spend between each or Jared’s “go on spend more tokens, continue experiment, believe in yourself”
37.
by bijowo1676 2mo ago
L226ET looks like a literal geohash A lot of GIS computer systems and apps like Uber use these to locate person/building
38.
by bijowo1676 2mo ago
Martin Fowler's overview of LMAX Disruptor is one of the best reads on this subject re high-load system design https://martinfowler.com/articles/lmax.html
39.
by bijowo1676 2mo ago
shopify is wrapping their entire dance with locking and moving rows inside a transaction. if you wrap step 1-3 inside transaction you will get same atomicity guarantee but again, my idea was: 1) do not use throwaway placeholder rows to
40.
by bijowo1676 2mo ago
settlement is a different process, what exchanges are doing is they match Buy and Sell orders. you have an open Sell 1 APPL for $100.0. Millions of other HFT orders rush to scalp your single order. How do you think exchange matches your Sel
41.
by bijowo1676 2mo ago
ok, lets model situation of 100 customers and one last remaining item. Who will get the last item? in shopify's design, it is a user who was the first to lock the row and have successful payment. Sounds good, but how often does it happ
42.
by bijowo1676 2mo ago
Modeling after physical shopping process is actually the proper way to design a eshop system. Imagine you are at Walmart store and go to checkout stage, you would have to pick item from the shelf and take it from availability for other shop
43.
by bijowo1676 2mo ago
i dont know about the world, by authorize.net and Stripe, which work globally and work with global credit cards, they do support separate authorize and separate capture, which seems to be part of PCI standard https://docs.stripe.
44.
by bijowo1676 2mo ago
> civilian casualties in a war is a normal part > Targeting civilians for death is not acceptable or justifiable. so we have numerous evidence of US and its allied forces deliberatly murdering civilians and nothing happens. Why do you
45.
by bijowo1676 2mo ago
i also work in big tech and know that a lot of bullshit design creeps into system design and prod, because everyone is overworked, overstressed, wants to just get things done for the quarterly performance review as to not get shitcanned wi
46.
by bijowo1676 2mo ago
that's why I mentioned active carts in my post, there are ways to define active cart to get rid of abandoned carts ( ignore carts where last user action was > N seconds ago). Ok, let's accept the design goal that whoever paid f
47.
by bijowo1676 2mo ago
think about for a moment what that skip locked actually means, all these 1000 rows per SKU are logically equivalent to a Inventory table with a single row where available_units=1000 per SKU. now let's think again, do we need to lock 90
48.
by bijowo1676 2mo ago
how does current design resolve concurrent actors fighting for the last item ? there is ultimately needs to be some global mechanism resolving this conflict. Currently it is an order in which db engine processes transactions by locking rows
49.
by bijowo1676 2mo ago
explained below in https://news.ycombinator.com/item?id=49228432
50.
by bijowo1676 2mo ago
there is no need to lock the row, since you a dealing with a shopping cart, not individual item piece. when you run aggregate functions, lock is no needed, it is actually better to run it with SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTE
51.
by bijowo1676 2mo ago
per my reading of the article, the protection is only needed for a few seconds, while payment is being processed by the payment system. so the row is inserted when Payment is initiated, and row is deleted when Payment succeeds What is o
52.
by bijowo1676 2mo ago
replenishment is an unnecessary cludge that only exists due to poor design. an "algorithmical smell" if you wish
53.
by bijowo1676 2mo ago
you should, their design is not the best. There is middle ground between "one row per SKU" and "1000 rows per SKU". Its called one row per shopping cart*SKU combo. if two people order 100 and 500 items of the same SKU, r
54.
by bijowo1676 2mo ago
not the best design to have 1000 rows for each shop*SKU combination. If a candidate proposed this solution during Shopify's System Design interview, i doubt he would be vetted for Senior+ position. Instead of having 1000 rows per shop*
55.
by bijowo1676 2mo ago
or they just got tired of feeding data into Palantir that results in hundreds of civilians being butchered
56.
by bijowo1676 2mo ago
you are justifying 9/11 attack on the US, the similar logic to yours was used by Al-Qaeda
57.
by bijowo1676 2mo ago
its a quote of a person, so the usage is justified
58.
by bijowo1676 2mo ago
how about tools like Lovable ? is Lovable used internally to create and improve Lovable product itself ?
59.
by bijowo1676 2mo ago
it is profitable to sell McDoubles, since they are popular and cheap, but McDonalds CEO doesnt eat its own burgers https://www.reddit.com/r/popculturechat/comments/1rhug58/mcd... so it is profitable to s
60.
by bijowo1676 2mo ago
it is profitable to sell McDoubles, since they are popular and cheap, but McDonalds CEO doesnt eat its own burgers so it is profitable to sell vibecoding tools, but its unlikely to be consumed by "serious organizations"

More ›