skysight-inc/HackerNews huggingface dataset:
I responded in a twitter thread[1], unrolled here here:

As all good things in life, and programming, this is a tradeoff. GraphQL is better when what you are requesting is best expressed as a tree (or a "graph", though only the DAG variety). This is not always the case, but it very often is when building API:s for production use.

Of course, you can express tree structures in table form, but it is not very convenient for clients to consume. In particular if your client is rendering nested component views, what you want is very often something hierarchical.

Another aspect of GraphQL that is better for us production people is that the performance is more predictable, exactly because the language is more restricted. You can't just join in all the things, or select billions of rows by accident. The schema dictates what is allowed.

Of course, again, it is possible to restrict this in SQL, just configure your schemas, limits etc appropriately, but SQL is anything-goes by default, whereas GraphQL is nothing is allowed by default. Whitelist vs Blacklist.

This said, as a language, SQL is clearly superior. It is the most (only?) successful 4GL (declarative) language. I wish more languages were this well-designed, and that there would be more language innovation in this direction.

The way I see it, GraphQL is a DSL for flexibly requesting hierarchical data from API:s in JSON format, optimized for complex evolving API:s. SQL is a full-fledged generic language for relational data transformation. They have different niches, but SQL has a much bigger one.

[1] https://twitter.com/joakimlundborg/status/125091692202945740...
AMD's 4000 APUs are monolithic and don't use separate chiplets and IO die. The chiplet + infinity fabric has higher latency than Intel, but that's not a problem for the APUs.
I have a 2015 13" MacBook Pro, and I'm on 85% after 940 cycles (5560/6559mAh - I guess the battery was smaller back then). I most often run it on the charger, but fairly often run it on battery down to a low percentagr too.
Ethereum is basically one big cloud computer, with a shared runtime.

Everyone gets a copy of the code AND all the data/state, and can execute all instructions.

Problem is that it’s too slow/expensive to do anything useful.

But perhaps the killer app for blockchain is buried somewhere in this concept.
Almost certainly, yes. I didn't note the capacity out of the box, so that 98% from spec is a bit handwavy for sure.

That said, Apple's usually pretty good about shipping things erring over spec, and publishing the low side of the real range. It was probably at least the spec amount when I got it.
You may be interested in the short-squeeze hypothesis, which suggests the current rally was triggered by technical factors and will soon peak and evaporate.
Yes. Earth used to have a lot more CO2. Then photosynthesis in the oceans created an oxygen crisis.
>I just treat the fediverse as a big chatroom/reddit thread that can never be deleted.

Treat the whole internet that way. You can't forcefully delete things from other peoples computers/minds. The best you can do is request.

I deal with this by posting almost nothing under my real name and switching usernames regularly.
It’s versioned, which is an improvement on “agility”
QM math is bunk!
Randall Mills of brilliantlightpower.com has figured out a classical model of the atom that works far better than the Schroedinger electron is everywhere at once model. Theory has many astonishing consequences - oscillating universe, unlimited energy (working prototypes exist) from atomic hydrogen transition to smaller hydrinos, dark matter is hydrogen in form of hydrinos, etc. Wikipedia says it is nonsense, but Wikipedia is policed by uber skeptics that won't even allow pro-hydrino rebuttal to be added to the page so is not an unbiased source. Proof is in the experimental videos and accompanying verification paper by independent scientists.
I’ve owned a restaurant before so I can speak to this: you’re right about chefs- they’re very hard to find. What I imagine happening in the long run is a lot of restaurants shutting their doors 6-12 months from now. Stimulus and PPP will keep them afloat for a big, but the damage will be done, and chefs (who were way underpaid to begin with) will command slightly higher pay when all these restaurants start hiring again.
Ah, the old "Read the code" version of documentation. Guess what? That's not documentation. That's douchebag for "I didn't write documentation"
The internet is hanging in there despite the coronavirus
This is a thing I've been thinking about a lot. We're quick to say "We're not testing enough", but also quick to throw statistics around "disproving" the amount of asymptomatic cases. I am on the side of "It's probably orders of magnitude widespread than most countries think", and the number of totally asymptomatic cases is actually far far higher. You can't test only the old and the already sick and then accurately assess likelihood to develop symptoms. Your sample is totally wrong.
It’s worse than this; employees who helped build the company are systematically shut out of reaping the rewards. Things like 90 day exercise windows, no information on exit timelines, and more dilution like this, pitched as if it was some forgone conclusion will prevent people who should see immense value from this company from seeing anything other than a token sum.
Please please please make this work for the UK!
Famous YouTube UI Consistency
Venus has no plain oxygen because oxygen is reactive. It probably requires life to break apart CO2 and cast off the O2 into the atmosphere. Certainly it required life to do that on Earth.
Yes.

Another tidbit: Distribution kills a company, not the product.

Learn to sell (and make your product great) and everything will work out.
That study did their research in a town that was already infected, meaning that our understanding of the infection rate for Covid-19 is probably lower than reality.
I'm curious. If a person qualifies for the stimulus check but has enough in savings to get through the next few months, do you believe they should refuse because it comes from the sweat of taxpayers as well?
I recall working at companies where the ops or DevOps teams would run their own IRC servers pre-slack. It was basically the only way to get stuff done if you had a desktop PC and needed to work closely with anyone. The problem is that most companies don't know how to do due diligence on a tool like IRC and the clients aren't very friendly. The lack of commercialisation of the space is what prevented companies from paying for it, and that meant no easy and rich clients got built, which meant it never got commercialised, etc etc..
That wasn't even managing the battery, per-se(although it is power management, it wasn't strictly about health). It was reducing clock speeds to extend the amount of time the device would be on. They still do it even if the device has a healthy battery: drain the phone to 1% and you will see. Rather than running at full blast and shutting down, you can extract more runtime.

Some EVs do something similar: the Nissan Leaf, when the battery gets really low(and I mean it, far past the point where you lost all percentage and mileage indicators), will enter a reduced power mode (or popularly called "turtle mode"). This allows it to eke out a few more miles out of an otherwise mostly dead battery. There is a "turtle" that lights up on the screen, maybe Apple could just do that.

Turns out batteries hate when they are almost empty and you are trying to extract full power from them, voltage drops even more. So there are some compromises that have to be made.
Simpler times my friend.
No amount of lowering the IFR will change what has happened and is happening in New York, Italy and Spain
...at the cost of speed. A big % of a computer's performance comes from its turbo clocks. For instance, the 16" MBP with 6 cores is 2.6GHz base, up to 4.5GHz turbo. Disabling turbo in this means you're slowing down the computer as much as 40%.

Also, it's questionable whether running at lower clocks saves power overall. Apparently it's more efficient to run higher clocks, but for shorter periods of time than it is to run medium clocks for extended periods of time.

[1] https://en.wikichip.org/wiki/race-to-sleep
Please show me the data you have so we can have a shared understanding of the facts. Until then, there is no reason to continue this discussion.
"Understood" is a strong word. There are lots of people with a basic understanding of SQL but who can't write complex queries to do things like represent tree structures and cyclic relationships. I don't think your average analyst can do that.

And even if all the analysts in the world could do such a thing, that doesn't matter if they're not building the applications.
It could be trending away from that, but historically https://www.ycombinator.com/ is the center of bay area startup culture, and then those startups grew into bay area tech culture as a whole.

Ycombinator comes from Stanford which centers around creating CEOs, creating most of the companies in the bay area. Most non-yc bay area companies still have Stanford at its roots. I don't have a direct data point, but almost every company I've interviewed for in the last 10 years and have worked with, their CEO or CTO or some other c-suite "club" is strongly tied to Stanford and from that directly or indirectly tied to YC.
Ya, I believe 2014 was the peak when it comes to seed deals per year so fair, we are below peak. But there was a TREMENDOUS rise starting in about 2005 or so (a combination of coming out of the dotcom bust then the rise of mobile with iOS/Android).

Overall I see the availability of seed funding as still quite high.

Very much agree with your last point about overvaluing funding. It's never been easier to bootstrap something for a year or two. Get an actual product working, maybe have a few users, and then go for funding to scale up. We see this in the data too with median company ages at the time of seed funding rising.
> Although the repository was protected with a password, a misconfigured setting allowed anyone to register as a new user to log in to the system storing the code.
In theory, laptop manufacturers that use aluminum in their chassis could just put the CPU die right up against the chassis, Remove the bottom feet, and then tell you to only ever use it sitting on top of a table designed to function as a top-down heat pipe (i.e. the kind they use to make “scraped” frozen yoghurt.) The table would become the CPU’s direct-contact heatsink.

Not practical at all, of course, but this is well within the laws of physics. (And people do lesser things all the time, using e.g. those laptop “cooling stands” with clearance and fans built in.)
> 5) SARS-CoV-2 as a species maybe drifting genetically towards more communicability but less virulence. H1N1, HIV and others have also shown this pattern.

This is not true for either of those diseases.
While I was studying engineering I worked in a machine shop. In that time I hand scraped or lapped a good few bearings and surfaces. Fast forward six years, researching optical sensing, and I've had to pull those old tricks out of the bag recently. For some reason, of all the skills and techniques I've learned, manual or academic, making a properly flat surface remains the most satisfying.
Ah, for a return to the (early?) 90s when the smallest phones were the "pro" models, and priced accordingly. And people would be amazed: "it's so tiny! Don't want to ask what it must have cost, though."
I don't know about willing to dismiss but you're making assumptions about facts not in evidence. For all you know the poster is cooking for 6 adults.

Moreover, ... whats wrong with a three months supply of flour? For the last few years we've maintained that much flour at my house-- just because its a convenient level to purchase/manage for us, nothing to do with preparedness (which, incidentally, is virtuous), and certainly not any kind of hording.
IRC is still alive in the fact that people still use it, but its dying (less people use it over time) in a way that will never be overcome.

IRC is lacking so many critical features that people consider the fundamentals of IM now. IRCv3 has been in development for forever and they still aren't done and even if they finished it it would never make it to all the irc servers and clients.

At this point it makes sense to join most other open source projects in moving to Matrix which still has active development and the ability to actually push out new spec changes in the current decade.
That's interesting to read. I'm in the US and every time i go through a site that uses Stripe I have to use one particular credit card because all others get denied. So I just assumed Stripe had strong anti fraud settings. I wonder if it's actually the card issuer denying Stripe now.
Interesting you used Wozniak as the model. I get the impression from everything I’ve read about him is that he is very forgiving of people less knowledgable/experienced than himself. I take your comment to be even more poignant in that light, since the people who might aspire to be more like him, are ignoring the value of his personable personailty.
Open notebooks from command line in the best available server
At this point, I think anything you do is going to not be better than what the system could automatically do for itself. Their change will basically give you that 80% bit.

There's something to be said for occasionally running the battery down to zero and charging it all the way back up, of course, but I wouldn't think of it as an effective regimen with current battery tech.

I'm also not sure how quickly it's expected to drop in capacity. IIRC, batteries drop a notch when they start getting used, plateau there for a while where it mostly depends on environment (try not to charge them when it's 110deg ambient, for example, overheating will kill a battery fast); then eventually drop again and start heading on down.

And, of course, all of this scales by how cold it currently is ambient because lithium batteries have reduced charging capacities cold (though I don't think it damages them permanently like heat does).

For all I know, 95% (roughly where you're at) is the expected amount once all factors are concerned I wouldn't worry too much. Maybe just get some comparative specs on MacRumors or with one of the utilities (some benchmark against everyone else iirc)
It's literally on the form. There's criminal liability for mis-stating.
Thanks! The $1,095 price tag is pretty steep. It's a lot of money to part with for some data that I'm not sure I'll find valuable. I'll look into doing a free trial with them though.
It sounds like your life might be harder than most right now. I hope you’re safe and getting what you need.
No, the conventional belief is that only a very small proportion of extremely rare events have a major impact, as measured by standard criteria of the importance of impact. Taleb is arguing that a much larger proportion them do.
It's interesting to see smaller companies adapt though. Local cafes in Australia are selling toilet paper and soap.

Overall I agree with your point. Many have shut their doors and I don't know if they'll reopen.
Explain the bodies piled up on hospital hallways.
The fact that the paper uses “CalTech” was the big clue for me. Also check out the references at the end. Some big clues there too.
Electric utilities have pushed back on the potential loosening of mercury requirements, saying they have already invested in expensive technology to cut emissions of the dangerous pollutant, and had sought and secured rate increases from power consumers to cover the costs.

But the U.S. coal industry has railed against the mercury rule, and blamed it for putting hundreds of coal-fired power plants out of business in recent years.

- https://www.reuters.com/article/us-usa-epa-coal-mercury/trum...
Why was it even allowed? Isn't there some requirement for a trial to be called Phase 3?

A Google search resulted in this:

The third step in testing an experimental drug (or other treatment) in humans. Phase 3 trials are conducted to confirm and expand on safety and effectiveness results from Phase 1 and 2 trials, to compare the drug to standard therapies for the disease or condition being studied, and to evaluate the overall risks and benefits of the drug.

https://clinicaltrials.gov/ct2/show/NCT04292899

,,Study to Evaluate the Safety and Antiviral Activity of Remdesivir (GS-5734™) in Participants With Severe Coronavirus Disease (COVID-19)''

The title doesn't contain Efficacy :(

A better clinical trial (but with fewer participants) will be run in Norwegia, but we're supposed to get results only in August. I don't understand why we're losing so much time by not running studies all the time.

https://clinicaltrials.gov/ct2/show/NCT04321616?term=Remdesi...
>Without all the spam

You must remember a different IRC to me. Spam bots were a semi frequent thing.
Had a business requirement to deploy an object storage container running Minio (S3 clone) with all the objects preloaded. It was not possible to simply upload to the container after it had been deployed.
The mere fact that we always see several people jumping in to assert how IRC is alive and kicking is in fact a giveaway that it, if not actually dying, is at least starting to smell a bit funny. (And frankly I say - good riddance! It's a protocol that's at least a decade past it's sell-by date, modern options are so much better)
When editing files, there's no really perceived latency because the files are cached locally. Only drawbacks is having pre-installed programs (on a shared server) and navigating through folders via a terminal.
Show HN: Adaptive CSS Theme for Hacker News
Marketing is probably the most important skill for a founder to have. You have to market to raise money. You have to market to hire employees. You have to market to get customers. It's especially hard at the beginning when you have to get the first of all of those things.

If you want to start a company, you should get good at it.
I also use mosh to maintain a constant connection to a remote server with an irc client
http://tsdr.uspto.gov/#caseNumber=87289033&caseType=SERIAL_N...

> Mark Literal Elements: EGRESS

> The mark consists of standard characters without claim to any particular font style, size, or color.

> For: Computer software and mobile device software for application and database integration; computer software and mobile device software for use in data security, namely, email and data classification, email and data encryption, secure file transfer, secure automated file transfer, secure online collaboration, secure access to encrypted email and data, secure email and data management, and secure email and data backup, archive and recovery

(I guess you'll have to redo the search for case number 87289033 yourself. I'm so glad the government keeps up to date with modern single-page-web-app design principles for what is literally just a document store. >_> )
Originally codenamed Project Blackbox, they were eventually released as the Sun Modular Mobile Data Center (MDC)[https://en.wikipedia.org/wiki/Sun_Modular_Datacenter]. Famously, The Internet Archive runs off of one [ https://upload.wikimedia.org/wikipedia/commons/thumb/e/eb/In...].

AFAIK they weren't built out of repurposed containers, but new ones. But I could be wrong.
Bill Gates says Trump's decision to halt WHO funding is 'dangerous as sounds'
Totally.

The problem is that most mix "SQL" the QUERY language, and the RDBMS on top of it. So the problem is how "constrain" the SQL as query language so it not allow to DROP tables.

So, most app will benefit from:

CLIENT(SQL) -> RDBMS(SQL)

but, as normal is instead:

RDBMS(SQL)

and that is the problem.

So, in typical fashion in our industry, we build a impedance mismatched solution!

CLIENT(GRAPHQL) -> CLIENT(SQL) -> RDBMS(SQL)

yep, more logical.

P.D: And seriously, the SQL guys also are part to blame. Somehow, along the line, the FACT sql is a query lang made for humans/developers have been ignored, and can't make a better version of it. For example, SQL can't be composed except with string mangling.
a number of commenters are relying on a misperception that we all need to avoid everyone else as much as possible. that's incorrect, and leads to this rush to overload curbside pickup options and crowd out people who particularly need to avoid the risk of infection: those with co-morbidities.

what most of us need to do is avoid coughing and breathing into each others' noses/mouths, and that's what the (better) guidelines are meant to prevent. keeping distance doesn't need to be perfect, but best effort, as long as we generally avoid standing face-to-face and talking (especially for prolonged periods, closely, and/or loudly).

it's really fine to go to the grocery store if you don't live with someone sick or immuno-compromised and can mostly avoid other people's spit in your face.
White House gives guidelines on reopening economy
Why do you care so much about pure speed out of context?
If you can use that energy to mine bitcoin, why not use it to power a data center or put it into the grid? Theres nothing unique about crypto here, its just one potential way to use recaptured efficiency, and not necessarily the highest ROI method either. Especially for oil companies, where this is outside their core competency and not something they would likely want complicating their balance sheet with all the mark to market requirements and all that would make holding crypto a particular sort of pain
Humanity's understanding of this disease is much more sophisticated than the two comments above this would imply.

Researchers are not stupidly looking at Diamond Princess and getting confused because the population is old.

Rather it's a powerful dataset because it enables us to quantify the asymptomatic people of all ages, because people were tested fairly exhaustively before being allowed leave, regardless of symptoms, and because we've had enough time for many of the cases to play out.

The diamond princess data revealed a large number of asymptomatic cases in China, the absence of which were skewing the detected cases in China much older.

Anyway, you don't need to think anything complicated about correcting for ages, etc

You can just look at the data from the Netherlands where they conclude they have 3% population infection, by looking at the random serological testing, and then look at the number of confirmed deaths they have, and do the very simple math.

It's very hard to do that and then say we're missing say 10x higher numbers of asymptomatic cases all over the place.

This blog post I wrote a while back is Ireland specific but has figures on CFR and IFR I think are still valid, and references to the academic articles I got them from: https://medium.com/@fergal.reid/predicting-the-impact-of-cor...
Lots of people in NYC are getting dragged out of their homes in body bags that will never get tested.

https://www.yahoo.com/news/teams-retrieving-280-bodies-day-1...
Show HN: Play Hearts – Open-source, made with Vue and web sockets
How do we KNOW it's controlled? Asymptomatic people are not, as a rule, tested, so actual infection rates could be massive.
I get great enjoyment out of Tony, but the dry humour of Mr Pete really does it for me.
https://www.youtube.com/channel/UCKLIIdKEpjAnn8E76KP7sQg
I was slightly frustrated that all of the themes for Hacker News went far above and beyond simply adding a dark theme, many of them completely change the UI of the site.

I've attempted to create a theme which I think only minimally changes the design (to aid readibility in dark mode) and only activates dark mode when your OS instructs the browser via the `prefers-color-scheme: dark` media-query.

Would appreciate any feedback/suggestions :)
The Hungarian Statistician Behind Three Volumes of Visualization Masterpieces