skysight-inc/HackerNews huggingface dataset:
tl;dr The chief complaint is that SQL DBMSs support more features than a strict relational model, though you don't have to use those features.

1. Column names. SQL is very flexible so you can do things like SELECT * from joined tables. Perhaps a bit sloppy, but not bizarre IMO.

2. NULL. This is purely a performance optimization. You can have a optional foreign key to another table, without introducing an entirely new table.

3. ISBL and BS12 were obscure and had proprietary IBM baggage.

If you want to use a SQL DBMS will unique column name and no NULL, you can.

If I were going to write an article, I would include a legit deficiency, like no convenient anti-join.
> our expenses would be more steady

Don't you have a 30 year fixed-rate mortgage? The increase in rent every year over the next 30 years is going to be way more than whatever maintenance costs you have.

Rent is "steady" in the short term, but every year you are exposed to market volatility and inflation.
spinning up a new trust chain is not so hard, but deploying that trust chain to thousands of servers around the world when your automation tool isn't available to do it with is really, really hard.
How do you distinguish cause and blame then?
Whoa, who’s calling for nvidia’s head? Not me.

My point was that the PC architecture of separate system and GPU memory is hitting a wall that means inefficiency and higher prices.

I have little doubt that Nvidia’s attempted acquisition of ARM was in part because nvidia recognized this. I expect they are exploring other UMA approaches. But it will be hard in the fragmented, not-vertically-integrated model.

Apple’s advantage here is one platform that can scale: it is hard to imagine Grace and similar running Windows on developer’s desktops. Maybe!

But my point was that, shockingly, Apple has a chance here. A small chance, as I said, but I don’t think anyone (including Apple) saw just how soon UMA was going to become a competitive advantage.
Mark Zuckerberg bets on Facebooks’s mixed-reality headset to secure his legacy ...
Another tech CEO realizing that the only way to sustain growth is to reject reality.
Yeah, at a bare minimum you're looking at 6% in agent fees.
I didn't mean to imply you aren't taking it seriously. Just pointing out what I'd be doing today.

Glad to hear you're focusing on getting that money flowing through to your employees.

Sorry you're in this situation. I know how frustrating it can be when you have to enter a reactive state that takes your attention away from your core mission.
I think this is the make-or-break moment for consumer VR/AR. Valve's attempt flopped, Facebook's attempt is flopping, Sony's attempt is about to flop (see their recently cut projections for PSVR2). If even Apple can't do it, I think it's headed for the dustbin, at least for the next decade or three.

I'm not ready to make a guess either way at whether they'll be successful. Apple does have a history of pulling these kinds of things off after others' failures, but a $3k price tag and the article saying execs are rushing the product to market over internal objections points to another story. We'll see.
> What benefit does that have over ordering delivery from a restaurant?

For me, there were two keys:

1. I love cooking and find it to be a nice meditative experience, but back then I was working 16-18 hour days and I simply didn't have the energy to deal with all of the other stuff you gotta do before and after you cook. This was a good middle ground.

2. I could adjust the ingredients to my liking - don't put in the cilantro, for example, or add some extra chili to make the sauce spicier.
https://www.nerdwallet.com/best/banking/savings-accounts
First Republic Bank shares plunge, trading halts as startups process SVB crash
> Granted my master is in a different field but I spent several years at university with the subject and fitting read one course titled History of Science due to a childhood dream of becoming an archaeologist.

My wife is a history professor. Her qualifying exams involved reading more than 250 academic books in various subfields related to hers. This is before she even really started her major research. History professors really do have just a completely different level of background than somebody who took a single course at university. Like, I would expect the typical history professor to have read something resembling 1000x the amount of academic work than somebody who took a single course.

So yeah, I'd expect a review written by a historian of a book written by a historian intended to be read by other historians will have wildly different context about the way that a subfield has evolved and been used or abused by various people over time.
It's quite bizarre and I'm also wondering this. I have no idea if it's possible to deposit into SVB. But they claim that the bank is operating normally.
Npmjs.com Is Down
turning your child into "the product" is pretty close to "child labor"
I am sorry and you are correct. I blindly assumed that "inflation" means "price inflation", but you explicitly specified "monetary inflation", which is something completely different (though sometimes related).

My apologies for reading incorrectly. My comment is true only for price inflation.
I imagine it was "which one of you wants this steaming mess?".

HSBC: [sigh], ok fine why not

The token is just to make the sale contract binding
IKEA effect. A meal that would otherwise be fairly good seems very good when you've done it yourself.

https://en.wikipedia.org/wiki/IKEA_effect
Reminds me of https://www.shlomifish.org/humour/by-others/funroll-loops/Ge...
Suspected Iran schoolgirl poisonings: what scientists know
This is something I'm interested in doing. Computer vision analysis of at-home food stock -> personalized shopping and recipes -> partner with grocery chains to reduce shopping times and optimize inventories. There are many other stakeholder alignments as well
It's not so much about the loss, its about the fact that banks lose their depositors. It is great for an economy that the 'savings' of people are used to safely invest in good ideas. This is the function of banks, and incidentally a function that really benefits from a profit motive.

Hence I believe the Fed was against this to keep the economy running by 'keeping money rolling'.
The only two ways I can see to make ASAT logistics work against large constellations like Starlink is if they figure out laser-based ASAT or an in-orbit attack mechanism that shoots multiple cheap missiles/bullets (avoiding expensive separate launch per target). Neither sounds impossible, though.
Ah yeah, that wasn't the situation in this case, I could still view the original comments thread and it had the same name, but no longer listed anywhere.
Exactly, been bouncing between HelloFresh and Gusto for over a year. I honestly think the services are great, excellent way to have a variety of home cooked meals that I would never have considered. As long as I don't have to pay full price for it.

I'm sure I'm the reason every speaker at Microconf says don't do B2C.
Freshly did full meals, ready to microwave. That said, they shut down this year.
But it does mean that greed doesn't explain everything, which is my point.
Just remember that if Mercury abruptly goes bankrupt, it is likely going to take days if not weeks or months for you to get access to those underlying funds from an operational perspective.

Fintechs that rely upon Banking-as-a-Service (BaaS) arrangement like this are woefully under-regulated.
The Stop & Shop app also has recipes that can add ingredients to the shopping cart. In addition, the app gives you 3 levels of pricing for ingredients: budget, regular, and premium.
The Apple Watch wasn’t quite ready for launch either. Apple didn’t know how to market it or what the hell to do with it. It took them a few generations to zone in on health and fitness and the rest is history.

The Apple VR headset has been in development for 7 years. They need to release it now and see how the world is using it and tweak it accordingly. It’s going to drastically improve the product.
Even if you are insulting their God/spiritual leader/whatnot, they still have no right to prevent you.
I lived in San Diego for many years, I'm aware of the trade-offs. My standard of living would decrease substantially if I moved back to California. Property taxes are much lower, but house prices for similar houses are much higher.

In fact, property taxes are not typically less than half of Texas. I think you mean that property tax rates are lower, but given the difference in house prices, that doesn't work out to half. For example, WalletHub[0] says that California's median home value is $573,200, resulting in property taxes of $4,279 at a rate of 0.75%. In Texas, on the other hand, the rate is more than double: 1.75%! But the median home value is $202,600, so the taxes end up being lower: $3,520.

In my case, home values in both cases would be more than double that, and so would taxes.

To be clear, we own this house outright. At this point we could sell it and invest the proceeds in index funds, and cover rent entirely by withdrawing about 3% returns per year. After the first year, that would all be long-term capital gains, too.

0. https://wallethub.com/edu/states-with-the-highest-and-lowest...
Yeah, my neighbor is blind and even though she can physically get to the grocery store just fine, she can't exactly pick out items she wants once she gets there. Having a "personal shopper" isn't a luxury for her. All this "disruption" did was make it more expensive for her to be disabled.
TBH…I think Tim Cook’s legacy is pretty secure at this point.
Is the website a play on insane asylum for audiophiles?
> I guess they think bits are bits

Wow...
>Of course, historically, we see that the rich and educated upper echelons of society have apparently always struggled with fertility.

This is exactly backwards; in the medieval and early modern era the wealthy had many more surviving kids than the poor. This has been established by birth and marriage records. The reason is because in these eras, physical survival was a challenge, and contraceptives did not exist, so the wealthy were the ones who could afford to keep their kids alive and healthy in large numbers.

This is part of why there was so much competition among siblings for the titles and positions of their parents; there was never enough to go around so the life of each person was a constant struggle against the overall flow of downward mobility.
I love when one can't tell if someone are serious or not. This made my day.
Well, hi, here's one.

Once a week we (my GF and I) quickly pick 5 meals (Netherlands, HelloFresh). If it comes in we spent 5-10 minutes checking and organising and then we have food for most of the week. Since we have a 6-month old baby we pick the meals with a shorter cook time, this week is 'the weak without meat' (is it national or international) so we pick veggie.

NO effort in deciding what to cook, NO effort in making the shopping list (let alone go out for groceries) and (almost) NO leftovers. I agree this is highly personal but all three are a big win for us. The meals are relatively easy to prepare, healthy (it seems, I am not an expert) and varied.
I see a business opportunity here in providing very expensive repackagings of compilers and libraries of "audiophile" quality.
It just needs to be really, really expensive.
>I think I'm willing to take more time to get a better meal.

Then these services aren't for you.
Azure has been nice to work with i have been comped multiple times for our own mistakes support is great im really not sure i get the hate..
There is plenty of middle path between colo and cloud as well . Providers like OVH and hetzner are super cheap too
>> A fast modern 16 core machine with 128 gig of ram can meet a lot of needs.

> True, as long as you don't care about redundancy or scalability or wasting money because you actually only use 4GB of RAM and barely any CPU.

Redundancy: you want two fast machines. More if you want them in multiple locations, but we still see a lot of people with presence only in us-east.

Scalability: You can go to 96-core per socket on commodity x86 servers now; 16 -> 96 is a lot of room to scale. You can also go up to I think 3TB per socket on Epyc Genoa.
This is a bad take on what FDIC did with SVB, and certainly not an assumption that is safe to rely on. Please do not spread this, as people who believe it carry a real risk of financial harm.

There are multiple threads trying to go into detail about the nuance of what happened, so I'll spare from rehashing it here. But it certainly was not promising FDIC coverage on all deposited funds.
Humanity seems to overestimate the progress that can be made in years, while grossly underestimating—to the point of not even understanding—the progress that can be made in decades.
They would experience neither force, nor torque.
Should we make Nirvana's Nevermind cover illegal?
I wonder why no one has said it yet but Mercury will come out the biggest winner from this mess. I can't estimate how the traffic from SVB > Mercury has been but I saw a post by Arc.tech saying they'd received hundreds of millions in deposits between 8 - 10 March.

Given Mercury was a more popular contender, I'm going to bet they had an inflow of basically double-digit billions.
Activating Developers and the New Digital Public Goods Open Source
No. Let me be abundantly clear; quiet quitting is a blessing to employers, by about a mile and a half. It's what they've always wanted employees to do, but now the employees think they're "sticking it to the man" by... doing their jobs???

There is no loss of power, there is no dynamic shift, there is no loss of profits whatsoever.

Many, many, many more employers would say that "quiet quitting" is great, like 100:1 outnumber those who are upset by it.
SSR is included? Do you have some project that is completely build with this stack. Some real life project?
I wonder what Dave Winer would say about this, the guy who invested RSS.
How is boxed null possible? The documentation for Optional.of(T value) says that it'll throw NullPointerException if value == null. https://docs.oracle.com/javase/8/docs/api/java/util/Optional...
True, but if you're insulting people, it's not nice and you should stop. Maybe they don't have a right to stop you, but I personally believe it's morally wrong.
Agreed. A single company dominating AGI could become highly dominant, and it might start to want to cut back humans in the loop (think it starts automating everything everywhere). The thing we should watch for is whether our civilization as a whole is maximizing for meaning and wellbeing of (sentient) beings, or just concentrating power and creating profit. We need to be wary, vigilant of megacorporations (and also corporations in general).

See also: https://www.lesswrong.com/posts/zdKrgxwhE5pTiDpDm/practical-...
Social media really highlights how many narcissists are among us.
is this version of memcpy gold plated and developed by Monster?
In order for this to matter, you'd need to expect the possibility of strings with huge numbers of leading spaces. Why then would you use this naive algorithm for comparison? An obvious and more straight forward improvement would be to compare 4 bytes at a time with 0x20202020. (or maybe 8) There would be a maximum of 3 spaces to identify individually.
At full price it's cheaper to just order takeout. Less healthy, at the places where it's cheaper, but still. Then you don't have to cook or clean up the mess from cooking.

I've also, personally, found these kits to be no less work than cooking normally. Sometimes, more, because the recipe will be more complex than something I'd have cooked on my own. It saves you meal planning and ordering the ingredients from the store (or going shopping), which isn't nothing, but it's not really that convenient—it'd have to also be cheap for me to want to do it very often, and at full price, they're not cheap.
Plunge in regional bank stocks triggers spate of trading halts
The focus is on value prop. and yes the docs are lacking.

Your feedback to include a comparison of our language to SQL is good. I was hoping the breakdown of the "shop admin" demo detailed the semantics of the language but looks like that it did not work for you.

The thought was that by going through the examples with the free trial one could get up top speed with SFSQL, but maybe a more formal introduction to the language is needed.

For reasons beyond our control Eric is not available for commenting at this time. He not wanting to take credit for the demos was more of a joke. Non trivial client work we have produced with SFSQL is not available for public review. I wanted public demos so I made them also to show how a novice can hook up a back-end with SFSQL sorry it came off as weird.

Also sorry we could not peak your curiosity a bit more, we will do better.
No one is bringing ski goggles around with them, especially not ski goggles with a wire running down to your pants.
BaFin Orders Moratorium on Silicon Valley Bank Germany Branch
I think this is that rare case where "begging the question" is actually apt! You are taking this as an inarguably factual premise:

> "Had depositors lost a SINGLE penny, there would be a very widespread run on bank deposits as people try to get below the $250k figure."

But whether a federal bailout was necessary to avoid that is exactly the question that people have been debating all weekend. It isn't an inarguably factual premise, it's the thing that is being discussed.

For my part, I think that if 1. A private purchaser had been found or 2. A bunch of jackasses with huge social platforms hadn't spent the weekend demanding they be bailed out, then your premise would have been false.

Both of those different outcomes was plausible on Friday. But in the universe that actually played out, I tend to agree that the bailout ended up being necessary.

But I still think it's bad that it was. And not just bad for everyone else, bad for us, here, many of whose livelihoods depend on the continued thriving of an industry that has sadly just demonstrated itself to be (to borrow a word) inept and unworthy of sympathy.
Chances are? Very unlikely as these things run in a vm that dies when the request is finished. I would be more worried about the big player who do scan your documents and share with government entities.

People are scared of the[unknown when the known is more likely
I am fat and I don’t really care.

But I don’t understand how some people come to understand that it’s healthy.
Preparing food at home allows for making things "as I like them". I'm VERY picky about certain textures and tastes. I also have a very restricted diet and suffer (biologically) from some ingredients that like to sneak into foods.

Ordering a known meal from a known restaurant is definitely easier than home prep. Ordering a "probably fine" meal from a "probably fine" restaurant requires extra cognitive load over cooking at home. (Some days I struggle with simply selecting a new meal from a restaurant. On those same days, I can happily spend an hour cooking a new-to-me recipe without any problems.)
I tried several alternatives (including one which tried to be exactly like Reader), but I didn't get used to them. Up until then I always knew what was happening in tech and global news. Since Reader was killed I ended up relying on news websites and I find features by accident, not because I read updates on blogs/media. I feel I got disconnected from the bleeding edge of the web that day.
Same as how homeopathy, flat earthers, etc can exist. Also people like to have something to call themselves special. This provides a group in which you can show off your 'knowledge' and gadgetry and so on.
The problem is that First Republic has $24 billion of off-balance sheet fair value losses, but only $4 billion of that is in securities eligible for the BTFP. $20 billion of losses is in its internal loans book. Even assuming the entire securities hole was patched, the loans losses alone makes First Republic insolvent.
I think you can do PIN + password by fiddling around with the group policy settings iirc (similar trick for PIN + TPM maybe you can find results for that first and then build on it)
AFAIK, it's empirically established that access to pornography lowers rape rates.

So maybe access to videos of lightly dressed children, icky as it may feel, lowers the rate of pedophile rape.
We had widely used grocery delivery service in Moscow (Russia) back in mid-00s, Ostrovok. The only difference with modern services was delivery time of day or two in advance, but for family grocery shopping it wasn't that much of an issue.
Why would that be the key takeaway? It says nothing about their liquidity. It just means that there are fewer people incentivized to make a run.
I have a family member who bought a house for $1 because it was about to be destroyed. He then cut the three-story house in half, got a permit to close traffic in the city for the day, and drove it on a truck to its current location, where he's lived for the past 50 years.
No. That will execute `< <(...) read` anew for every loop iteration, which in this case will cause it to print an endless stream of `a`s.
My time teaching a robot to pretend to be a human to pretend to be a robot
Simpler solutions like dedicated servers, VPS work well enough, and the service provider will take care of all the above. The problem is with things like AWS and GCP, and once you fall into their wide matrix of products you'll have a hard time escaping out of it.
That would explain it, I should’ve looked at Munich. I thought Berlin would be higher.
I think about the audiophile fringe approximately the same way I think about flat-earthers: I'm sure there is a core of true believers, but that at this point there's just massive amounts of trolling going on - and Poe's law applies: any sufficiently advanced form of trolling is indistinguishable from kookery.
> Almost every app dev would prefer that their app reacts to changes in the entities, and updates it UI accordingly.

Absolutely. I’ve been going through this tech research process now as I need near-real-time or at least reactivity and I just scratch my head and think “why is this so hard? don’t everyone need this stuff these days?”

> This is non-trivial in the relational model.

Yes, but I don’t believe that it has almost anything to do with the model, and almost everything to do with choices in RDBMSs like Postgres, which are slow moving tankers.

All the abstractions and procedures for materializing views (ie store and run the queries in a push instead of pull fashion) are both theoretically and practically well understood, and half of the support is already there.

WAL + CDC is virtually already the standard, it’s just clunky to use. The missing pieces seem to be more about multiplexing subscriptions and it’s implications on downstream protocols (probably needs wire protocol changes?).

In either case, I very much think the relational model should not be considered mutually exclusive from reactivity, and the implications of assuming that may be throwing out millions of holy babies with a little bit of bath water.
Would you expect any system with tethered cables to do anything more than flop as a wide release product? Sure, maybe a dev version might come tethered, but for general consumer product, tethering should be a non-starter
It wouldn't be the first major product steered entirely by Cook, as the sub-heading states, that would be the watch.

Within a year or two of the launch of the iPhone the tech industry went into "what have you done for me lately?" mode, on the edge of their seats for the next major iPhone level change-the-world platform from Apple. That's died down over the years. The fact that the watch merely defined the segment and was so dominant it re-shaped the watch industry is still seen in some quarters as a failure because it didn't replace the phone.

If the AR headset does launch and it just does as well and it's leading competitors that's fine. Not everything has to change the world. Maybe just having it as a really solid option for those who want one is enough.