skysight-inc/HackerNews huggingface dataset:
Druid and Clickhouse are OLAP systems. The key here is “online” as in they are optimized to answer queries in a matter of milliseconds. Maybe things have improved, but RedShift is not really an OLAP system. The last time I used RedShift was back in 2015 and it took it tens of seconds or even minutes to answer the queries that Druid could answer in just a few seconds; the Druid cluster was a third of the cost too, AWS was charging us too much.
I love BigQuery, but I look at it more as a background processor for queries over huge datasets. With BigQuery you have some real limitations on the number of concurrent queries. Even if BQ was able to answer in seconds, your users would be reaching your concurrent query limit all the time.

In RedShift you can perform joins, but in Druid and Clickhouse you cannot, your data has to be denormalized. There are quasi-joins but they are not the same. If you are going to swap Redshift with Druid or Clickhouse, then you need to denormalize the data or design around the specific quasi-join concepts of these databases that abstract dictionary lookups.

Druid is operations heavy compared to Clickhouse, while RedShift is just a few button presses. I started using Druid in 2014 and back then to set up a cluster you needed a decent understanding of orchestration. There are plenty of “minimal ops” solutions for Druid nowadays, but IMHO all they are doing is abstracting the problem and not really solving it. To run a Druid cluster, you need 5 or 6 node types and to arrive at the proper configuration of resources for your data needs will take you a lot of time. Clickhouse requires a single node type.

Ingesting data is easy in RedShift, but you will have to work a bit more with Druid and Clickhouse. Two of the druid node types are dedicated to ingestion, so your data pipelines should allocate these dynamically. Loading data into Clickhouse is as simple as asking it to ingest a file, but since it is big data, you need a dynamic place to stage such file right? All I am saying is that I wish there was an easier way to pick up the data from private S3 buckets.

Performance is a wash between Druid and Clickhouse for me. I never did a proper head to head between the two. However, the product I built on top of Clikhouse is a next get version of the product I built on top of Druid, and in my experience Clickhouse achieves the same performance for a third of the costs. However, you must account that cloud computing has gotten cheaper over the years and my numbers for Druid come from 2017 which is the last time I approved a bill.

I forgot to mention PG. I have put small analytic datasets, 80 million rows or so, in Postgres with good results, but even then the response time was never less than a few seconds.
The LA Times's investigation into Purdue Pharma in 2016 revealed internal Purdue documents demonstrating the company's culpability in fueling the opioid crisis.

> The documents provide a detailed picture of the development and marketing of OxyContin, how Purdue executives responded to complaints that its effects wear off early, and their fears about the financial impact of any departure from 12-hour dosing.

I don't have many recurring subscriptions, and I don't live in LA, but I signed up for the Times the day the reporting came out. So rare is quality investigative journalism these days.

Fast forward 3 years, and "Purdue Pharma and the Sackler family were in negotiations to settle the claims for a payment of $10-$12 billion" (Wikipedia).

As far as I know the settlement was never finalized. And I don't want to make it seem that the Times was the only organization looking into Purdue. But I wish a fraction of that settlement could be re-invested into investigative journalism.

https://www.latimes.com/projects/oxycontin-part1/
The point is to demonstrate that std::array isn't an array.
Relevant: http://existentialcomics.com/comic/337

And don't skip the article below the comic.
> We generate data-input forms automatically from the structure of schema definitions in the database

That's a lot better and clearer than "AI code generation" :)

> It's AI in the symbolic sense.

Unfortunately that AI still seems to be caught in winter. While we wait for spring to thaw a new round of hype, maybe something simpler, like "smart datagentry forms" or "data-mapper"?

Really happy about this nicely followed up show hn - logic/prolog and graph DBs seems like such an obvious complement to rdms - and as demonstrated by json/jsonb in postgres - simple document data can be rather nicely shoe-horned into heterogeneous relational systems. But proper graph DBs... Not so much? Nice to see more projects in this space.
>Something weird happened in California, where 20% of their tests were coming back positive, then all the sudden 04/04/2020 they started seeing <10% positive tests:

This is not surprising. When tests were scarce, tests would be rationed to those most suspected of infection.
Alternatives to Amazon Associates
Boring. Adam Neumann had charisma.
Ah, so Clojure and Lush didn't stand the test of time. Good to know.
The fun part about this virus is that it works on a 10 day delay, so you can either prevent infections long before it has a chance to start killing people, or you can start dealing with the epidemic once it's too late to stop it.

Also, California ICUs are at 80% capacity, so there isn't that much room left to relax unless you want them to get verwhelmed and start sending people back home to die.
You can cut 90% of programmers that would not pass an interview for whatever reason and there are still easily 10 times more people that qualify than work for Amazon. More so if you consider whatever fraction they need to onboard each year. Absolutely worst case is just slightly increase pay or open a few more offices across the US.
That's awesome, I feel like many companies increase prices over time trying to squeeze more revenue, but that usually requires monopoly power.

I remember from economics that in an idealized, efficient, large market, the price of a product should tend towards the marginal cost of production. In the case of SaaS, that's almost $0 (server costs being fairly low), so SaaS products ideally should all get cheaper over time. Good to see theory matching real-world here.
Earlier you wrote 'For example, his "emulation cones" are a new name for a very old and extremely well-studied idea. The term "rulial space", similarly, is a new name for an idea that's well-developed in programming language theory.'

I don't understand how things could be extremely well studied and developed, but also not exist in some fashion where you could just name and link to it in a matter of minutes rather than hours. Example "emulation cones are called X here".

I've listened to Wolfram and skimmed one of his books before deciding he's beyond my ability to evaluate as genius or crackpot. I'd love to be able to nail down a specific thing where I could read about some existing topic and then read about Wolfram claiming to reinvent it or something, because that could help me learn towards one conclusion over the other in the genius versus crackpot consideration.

One frustrating thing that I often find is that much of Wolfram criticism is non-specific and as it's impossible for me to bucket Wolfram I can't bucket his critics either because they tend not to provide enough detail or clarity.
I wonder if AMD came up with the Epyc name just to troll Intel.
+1 for Keycloak. It's stable and it works.

I wrote a decent Go client library here: https://github.com/airmap/go-keycloak
The government has the power to check temperatures, force people to use a contact tracing app, require masks etc.
Ok, fair. But for almost all practical purposes, std::array is an appropriate array replacement.
> When we program we categorize the world in English (or Spanish, or any other natural language), and then we encode that into a program.

Speaking solely for myself, I don't find this to be true. Yes, it does seem to be the case that you have to represent the program in your mind before you can accurately convey it to the computer. But no, I don't find myself using words to represent that. Maybe I use English to talk myself through the concepts, but I would not conflate the mental model with the words I use to describe that model.

My mental model feels a lot more like data structures -- abstract relationships between parts of the program, degrees of closeness, and senses of information flow. I can't represent the brainfeel of that in words without losing too much of it. And very often, yes, the semantic world in which I know this program will be embedded -- by way of a programming language that exposes that semantics -- does influence how I think about the program.

> If we think of programming languages as tools, then it becomes evident how some programming languages lend themselves naturally to problems that in other languages might be — while not impossible — hard to solve. See for example Erlang, a language that’s tailored for Concurrency Oriented and Message Passing programming, or Racket itself, a language tailored for LOP.

I don't understand the proposed distinction. If we can agree that the "tool" affects how you think about a program built using that tool, aren't we ultimately just quibbling over what the word "language" means? I feel like that's missing the point of the assertion that programming languages are languages -- you still end up with some form of Sapir-Whorf.

The idea of a "programming language paradigm" better captures the essential semantic distinctions between languages, but even these can be too coarse-grained. I'm more interested in adjectives like "single-ownership", "message-passing", "immutable", "backtracking", and so on. Words that describe the semantic world that the PL purports to be an interface to. Maybe that's what the word "tool" is supposed to convey, here, but then I don't think PL researchers really disagree.
Most commenters' opinions are based on deformations of what WHO really said. US media seem to negatively interpret the indeciseness of WHO, even if all individual countries' health organizations hardly knew better: at the beginning, very few was known about the virus (partly because China did not share everything they new on it, but that was still not revealed).

An example, WHO really said:

"Preliminary investigations conducted by the Chinese authorities have found no clear evidence of human-to-human transmission"

which is realistic and prudent. But in this thread an in every other place on internet, it is interpreted by US people as:

"there is no human-to-human transmission"

which is downright crazy.

Also, I see a lot of mixing with Taiwan issues, even though the particular data about the pandemics in this country (and yes I am in favor of Taiwan independence, but that does not matter, and that's my point) did not change at all the scientific and public health conclusions and advises to be taken. In other words, to do their public health job, the WHO had absolutely no need to quote Taiwan in particular. Of course they also considered not angering China and so refrained to speak of Taiwan because of that too, but it would be the same for any of the UNO Security Council countries' delicate issues, including US.

If WHO was to be rebuilt upon better bases, everybody would benefit from it. But cutting its funds?? It's stupid.

PS: another point, UNO scientific organs really are just the sum of their individual countries' parts. It should not, it should be larger and better than its parts, but that's just not the case. Their is no "WHO laboratory" etc, there are just specialists from participating countries that share their own labs data (or not). To change that, it would need more funding (not less!) to own its own labs, facilities, research programs, etc.
Ask for a refund of all the charges, people don't realize that a lot of companies do that these days. You should be upset if they refuse (assuming you genuinely weren't using their premium features).
Why don't they run non-covid content.. The amount they milk it is nauseating.
Hospitals around me are at half capacity. San Mateo is at 56% capacity in ICU beds.[1]

Covid cases were doubling every 3 days (up to 5).

Would it be correct to say that had we waited another week, hospitals would have been overrun?

If that's the case then I understand why health authorities are cautious.

[1] https://www.smchealth.org/post/san-mateo-county-covid-19-dat...
Would be keen to discuss/trial as well.
How does SoftBank not go out of business?
Well for example there's lots of non-essential business that can operate while enforcing social distancing. Closing bars and restaurants makes sense. But closing stores were you walk in and walk out does not make sense. Banning fishing doesn't make sense. Very broad strokes have been used to lock stuff down.
There's going to be a lot of homeless people as soon as the various state's eviction bans are lifted.
All the places Microsoft has shipped awesome products and won the market didn't have as strong monopoly (or duopoly) effects as in the mobile space. I don't think we'll see a MS phone any time soon unfortunately.
> regardless of the pricing

If Intel sells $5 CPUs, will you change your mind? I don't understand the obsessive praise of AMD. Keep in mind that Jim Keller, an Intel ex-chip architect lead the AMD Zen platform when he was hired in 2013 (after working at Apple on the A4/A5 SOCs). It is the same dude competing against himself. Btw, he is back at Intel since 2018 to help Intel out.
I doubt politicians are the ones putting together these slides.

But yeah, the slide thing is kind of silly. Looks like they did most of the work with a 4:3 template, then realized halfway that it would be shown on a widescreen projector/TV.
Those charts look very different from the Worldometer data, which shows the April 4th high water mark in new cases still holding 10 days later.

Their graph is linear growth in new cases per day until 4/4, followed by a gradual but spiky decline, even as tests/day keep increasing.
Many companies will go out of business permanently. Even deep payroll cuts will not be enough to keep them solvent.
Imagine the very near future when AMD starts using TSCM's 5nm process, which has approximately double the transistor density of the current 7nm process used for the EPYC 7002 series.

They could go to DDR5, PCIe 5, AVX 512, and still have a transistor budget left over for whatever they like.

The 'whatever' is the interesting part. What exactly does a GPU do that a CPU doesn't?

Typical GPUs have crazy high memory bandwidths and good latency hiding by using many (thousands) of threads.

So if AMD does something like increase the number of memory channels and implement 4-way SMT, they're poised to upset NVIDIA in the HPC space in a big way.

Many people would much rather program for a general-purpose processor than the CUDA platform with all of its quirks and limitations...
Point of clarification: Are you saying that there's no way to disprove your claim of being a savior? Or no way to disprove the reaction was disproportionate.?
We are confident the other way has more problems and more outright destruction because the other way blows up our hospitals and everyday life becomes nonfunctional anyway.

This is my last message in this subthread because your misreading of my post to put on a hairshirt has convinced me that you are not here to discuss the topic in good faith. HAND.
> It absolutely depresses me to think of how many hundreds of millions of mailboxes are filled on a daily basis with unneeded paper mailings.

This is a direct function of the completely misguided (IMHO) idea that government services need to be sustainable only on usage fees. That's a failure of understanding what government is for and effectively a regressive tax. We need another mechanism for keeping the system efficient. Making it market-based isn't the only one.
You’d have to buy your own PS/2 to USB adapter to get it to work. :)
I just read A City is not a Tree, linked somewhere here (http://www.patternlanguage.com/archives/alexander1.htm) and found it quite interesting.
> It was obvious to everyone that WeWork was going to flop

Always easy to say this so confidently in hindsight, but did you or anyone you know become a millionaire shorting WeWork after it went public?

Wag, I get. But I was bullish on the idea of WeWork and the model until the founder's corruption and mismanagement started getting major attention.
The author wrote a follow-up article as well:
https://thegradient.pub/a-speech-to-text-practitioners-criti...
Ask HN: Shouldn’t Facebook Ad costs decrease these days if its a bid system?
This is really weird, and somewhat clear to me that the word “Bid” in Facebook’s advertising mechanism is not really true.

Report after report I’ve read that companies have decreased their ad spending dramatically. Even on HN’s homepage the LA Times has reported their ad revenue has been eliminated.

So how can it be that our cost of cost per lead on Facebook increased? We have an Ad Set targeting any American between ages 25 and 55. That is it. You would expect that the cost per lead for that group would decrease IF 60% OF ADVERTISING BUDGETS have frozen. Our cost per lead increased late March until now.

Before it used to be around $2, now it is around $4. I am beginning to realize that the word “Bid” is incorrectly used and believe there is some underlying mechanism in which we are not simply bidding against other advertising platform participants. Has anyone else experienced this? Does this also happen on Google Words?
How does this compare to Hydra?
That's true, but turning on hardware encoding didn't make a big difference in encoding times for me. I'm planning on upgrading to a Ryzen 9 3900X to make everything else smoother
I see that as a feature. Templates should not do much logic, so it's a good idea that the templating language is simple.

But you can always switch it for Jinja2, just a line in the settings file.
20m out of work is awful and can be dealt with without causing a public health crisis. Keynes won; we understand how to deal with this.

Food shortages don't appear to be realistic and hinge on assumptions that don't seem to hold water.
> Worth than that, part of the population is getting obsessed about rule-breakers, as if lone cyclists suddenly became a danger for the nation. The police is flooded with calls of people denouncing cyclists, hikers, or joggers...

I've definitely noticed on Facebook, since the beginning of this, there's a lot of shaming of people doing X, virtue signalling, I'm doing this right, how about you? etc. There's a huge political correctness and peer pressure angle to the social distancing policies.

Most people seem onboard with this so far, but I think at some point, the tide will shift. There will be growing social unrest. We're a social species, we're not meant to live in isolation indefinitely.
Spy on your partner’s WhatsApp activity
Show HN: Amazon Whole Foods Delivery Slots Finder Chrome Extension
Sweden has one of the highest deaths/million.
Havw you ever had a scope or scan/x-ray at the time of the attack? If it's that serious then it sounds like you may have a very significant hernia at those times.

There are surgeries that can help with hernias (which can come and go like that).

Another thing, have you tried Nexium? For me that has been really useful to reduce symptoms (although I do still have some serious symptoms).
But it sounds like you have a more significant hernia.
Maybe i'm misunderstanding but the entire point of whats outlined is to be prepared for the next wave. Sure we're flattening the curve, and we'll eventually have to relax the stay at home mandate, but its very possible that it will just get out of control again. Until the govt feels they can handle the next wave properly they don't want to take the chance.
You mean like how torpedoes actually detonate when they hit a target in a movie ? ;-)

https://en.wikipedia.org/wiki/Mark_14_torpedo

Or how in the movies they don't run in circles and sink the submarine that launched them ?

https://en.wikipedia.org/wiki/Mark_18_torpedo
https://en.wikipedia.org/wiki/USS_Tang_(SS-306)
Yes, I'm pretty happy with the new pricing but my employer will probably have to go with the Enterprise plan to get access to the "Audit Log" and HIPAA compliance. :frown:
You're making an interesting argument, but one that was rendered obsolete a long time ago.

We've used beyond line of sight weapon systems on massive scale for at least 40 years, and weapons like the Tomahawk and JSOW have taken things completely out of the realm where such an argument can be taken seriously.

The decisions you talk about are probably valid doing close air support in something like a helicopter where the aircraft actually operates at an altitude where the pilot can actually distinguish targets on the ground.

There's a whole vast world of aviation delivered ordnance that has nothing to do with that world.
Repeal the PAEA, pass a postal banking act, and fund the USPS with taxpayer dollars as is allowed by the Constitution. Seems like a no-brainer to me.
I looked at this question using the UK critical care data in a blog post at https://radfordneal.wordpress.com/2020/04/06/body-mass-and-r...

From that data, it does indeed seem that having BMI>40 is a large risk factor for COVID-19 being serious. BMI between 30 and 40 is also a risk factor, but much less than for BMI>40.

In drawing these conclusions, I was assuming that being put in critical care was a good proxy for serious disease, but it's obviously not perfect - those who die quickly before reaching critical care obviously aren't counted, for instance. I think this is probably not a big issue for the UK, but reports are that quite substantial numbers of people in New York City died of COVID-19 without this being recognized by the health care system. Since we don't know (from this study) what the BMI was for these people it's hard to draw justified conclusions.

It's frustrating that they don't break down the BMI<30 category further, since there's also reason to believe that low BMI could be a risk factor.
Highly recommend folks who are into aircraft warfare pick up a book about how the AIM-9 Sidewinder was developed as a side project at China Lake by the Navy that had to be done under the radar due to politics. It's a great story about engineers driven by a real customer need fought bureaucracy, politics and some interesting technical challenges to build a missile and get it in the hands of pilots. They were up against a military contractor (Hughes) pushing the AIM-4 Falcon which had horrible numbers in the field. The Falcon required like 3 people and 4 racks worth of equipment to troubleshoot it while the Sidewinder required a screwdriver and a voltmeter.

The Sparrow had its own challenges from what I've read. Specifically issues with the acquisition radar being able to track a fast moving target and the missiles ability to receive the reflected signal and apply the right amount of correction. Got to remember that the time when these missiles were being developed it was to target slow moving bombers - not tight turning bandits.