skysight-inc/HackerNews huggingface dataset:
Looks interesting. Alas, no support for VPNing into DB.

Like what mode.com is doing with its "bridge": https://mode.com/help/articles/how-mode-connects/#bridge
Thanks! I don't have much experience with notebooks, but I will gladly merge in any pull requests for good ideas like that. I'll also add a GPL license so interested parties can use this as a skeleton for their own ideas.

Also: tickgit is awesome. I favorited it for use in other projects.
no offense, but really, get a life!
I have some data in BigQuery (for some personal project) for which I'd love to use Chartio and the visual SQL builder. The sign up page just shows company login - is the product not intended for standalone consumers?
Is that a thing in other countries? Sounds like an excellent idea for a bill here.
And 89% of Italy's fatal cases are people >70yrs old.
I dislike Vue and similar templates because the result is not used as HTML, it's used as JS to generate HTML, but tries to imitate HTML. I feel the same way about JSX.

IMO a just a simple function/array based templates work better like this that I have used recently:

div({class: 'test'}, b({}, 'Hello world!'))

Or for the array syntax:

['div', {class: 'test'}, ['b', {}, 'Hello world!']]
Or even just a simple GIF that demonstrates putting together a simple query. Something that shows how to use the product in under five seconds.
Congrats on the launch! Love that you're tackling an underserved industry
IMHO what is essential as a language feature for writing interpreters/compilers is algebraic data types and pattern matching on them, because they make things much easier when manipulating ASTs, which is a frequent task in implementing these programs.

Unfortunately besides functional programming languages (Haskell, OCaml, etc) or modern languages (such as Rust), there are few having these features, and JavaScript is no exception. Of course you can use a poor man's substitute such as the Visitor pattern, but it's quite a hassle without a direct language support.
Location: UK (Bristol)

Remote: No

Willing to relocate: Would like to move back up to the North of England

Technologies: IoT, Connectivity, Linux, Docker, MQTT, Alexa/Google Assistant Smart Home Skills, NodeJS, Java, Crank Storyboard

Résumé/CV: https://www.hardill.me.uk/wordpress/about/curriculum-vitae/

Email: hardillb@gmail.com

Looking for Lead Dev/Architect for IoT/Connectivity project.
We can have co-ed teams, but if everyone is given the same skill test and it makes women virtually non-existent on the team, there shouldn't be any special rules in place to fix the inequality.
The topic under question is the respiratory hygiene of dormitories as compared to living in a house or other living condition. The N that is under consideration is the number of dorms, and the people who live in those dorms.

There are pros to having the study done on a single university if there is a large enough sample of students and dorms. Since they all were in the same university, it makes it easy to isolate for the dorm variables in a way that wouldn't be as easily accomplished with multiple universities.

[Same university, different dorms] isolates for dorms, keeping the university constant.

[different universities, different dorms] does not inherently isolate for just dorms, since there may be compounding factors present due to known or unknown variables present in different magnitudes in different universities.

Some universities have many dormitories. My alma mater had 18 different dorms and an 30,000-40,000 undergraduate student enrollment. It was like a mini city, complete with its own area code, police department, and post office. If you lived in a dorm, you could go a whole semester without stepping foot off campus if you wanted to. The vast majority of undergraduates lived in dorms during their underclassman years. You can get good data from 18 different dorms and tens of thousands of students. And arguably you can get good data with an even smaller number of dorms and students.
> FWIW, as a JS/Python programmer I didn't run into borrow checker issues on my most recent Rust foray -- I think it's gotten easier over time with stuff like non-lexical lifetimes?

It also varies hugely according to what kind of program you're writing. Some programs naturally have borrowcheck-friendly structures, others don't.

For example, i wrote a program which processes network packets. There is a main loop which reads packets, then passes them down a pipeline of filtering, extraction, and other processing, eventually sending out more network packets. From the compiler's point of view, the pipeline is just a series of nested function calls. Each call can safely borrow from any of the enclosing scopes. Some of the stages are stateful, but they manage their own state, copying data to and from the packets. There's nowhere in a program like this that you run into a problem with borrowing, it all just flows naturally.
The US, judging from Italy, is about 4 weeks away from a complete collapse of its healthcare system due to corona virus.

With no serious attempts at mitigation or contact tracing or testing, that thing is going to spread like wildfire.
I'm also just aware of a few anecdotal cases, but I guess this is very hard to scientifically confirm by its nature. There have been several cases in the US where it could not be traced back where they could have been infected (which could or could not be asymptomatic, or just incomplete knowledge of contacts). The first case in Germany was also asymptomatic spread[1]. Even if this just happens in few cases it would still be devastating, especially if it also happens with those that go completely asymptomatic for the entirety of their infection, which is currently said to be about 10 to 20% of all infections.

I check out John Campbell on YouTube every couple days. He has this unique style of presenting current developments and research papers in a no-bs manner and commenting on them, currently urging for more proactive measures mostly.

[1] https://www.nejm.org/doi/full/10.1056/NEJMc2001468?url_ver=Z...
I think of use cases when I see this product other than what you mentioned. I don’t see this as an end user product for analysis. IMO a product like this can be used for iterating over backend design with other developers when discussing a new feature or model change. Imagine walking through a complex data model when discussing a new feature and needing to quickly visualize stuff. Now I write SQL by hand pretty quickly but I would love to use a product like this in a team design discussion where we want to visualize what we would be pulling from the DB and instead of having to hand write all the joins and filters as you walk 5-6 tables you can quickly and easily see what data is going to be provided to your DAO layer. You can spend way more time focusing on the discussion and less time waiting around for data access changes to be visualized. Then in the end the developer can take the auto generated SQL and use it as a base to start writing code for the DAO layer. Then the developer can do the optimizations and cleanup to the query you mentioned in your post.
Is the security story why you prevent signups from gmail.com also?
Oh awesome! I haven't heard of SQL bucket but I'll check that out as I love anything that encourages SQL based modeling. I was writing my own and then DBT came out and we push people there primarily. Send me a note - dave-at-chartio and I'd love to chat sometime.
Also theme song is on point
Masayuki Uemura, NES/FamiCom creator, discusses the history of the console
Hi guys, kudos on the launch!

I help run a distribution company and I'm not clear who this is for? Is it for my own trucks i.e. scheduling trucks between our locations and/or customers? Is it for when we use a 3rd party logistics company i.e. scheduling time with them to come pick up and deliver our goods? Or is the product FOR the 3rd party logistics company that is handling our goods?

Is this usable without two (or more) of the parties using this software?

Would love to hear more. There are many issues in this space and love the fact newer startups are getting into it.
This type of pedantry is 100% on-brand for techies. I just hope it doesn't end up getting people seriously hurt.
Accurate or not clinician time is typically billed separately, as are drugs, individual procedures, equipment, etc. Some stuff is rolled up but not that much; hospital accounting systems are quite comprehensive and structured in such a way to help them argue with insurance companies.

So the argument that the crutch is expensive because an MD handed it to you probably doesn't hold, the clinician files something, probably under a CPT code, and you were billed for that separately.

This depends on the service of course, you may see say a CT scan where the room time & tech etc. are rolled into one item, but the radiologist review is separate. So it isn't just people vs. equipment, etc.
I literally knew you must’ve been part of the industry. You might want to think your word ‘unavoidable’. It caused me so much rage I literally couldn’t make it through the rest of your post until after I made mine.

I completely inteperet your post as an excuse - the word unavoidable alone gives that away.

Canada’s system isn’t perfect - but it also isn’t literally raping the lower class on purpose.

Just look up Martin Shkreli if you need to be educated. I have nothing but passionate hatred for the way the US enslaves it’s lower class through this. It’s utterly, incomprehensibly pathetic and lower than human.
> I’ve seen $50 being charged for a pill of Advil - first hand

A paper plant was having a problem with their mill. They brought in a consulting engineer to help them with the problem. He took a look at the machine and after a few minutes, drew an X on it in chalk. "Hit it there with a hammer". It worked!

"How much do we owe you?"

"$10,000"

"That's absurd! I can't pay you that for literally 2 minutes of your time! I need a detailed invoice."

The engineer wrote up an invoice:

chalk mark $5
knowing where to put it $9995

=========

The patient in your example did not pay $50 for an Advil.

There is a lot wrong with US healthcare, but this isn't it. It's about misaligned incentives.
sorry but 3 months ago WHO was complaining that China is taking too strong measures that are hurting the local population and are not proven to work. WHO never recommended shutting down cities or regions, which as we can see is the only thing that works.

> He urged the public to remain calm, saying WHO wasn’t recommending “measures that unnecessarily interfere with international trade or travel. (https://www.cnbc.com/2020/01/30/who-declares-china-coronavir...)

WHO fucked up big time IMO. thousands of employees there, most probably appointed politically by country of origin and who have nothing to do with science.
Headline kind of buries the lede a bit: clinics had patient samples and tools to test those samples because Seattle was doing an unrelated flu study, but because the samples had only been collected for flu tracking purposes, medical privacy laws forbade testing the kits for the COVID-19 that would also have been present in the samples.

Samples were discovered to be COVID-19 positive only because some doctors in the study chose to break protocol and run the test, and when the CDC caught wind of what they'd done they told the researchers in no uncertain terms to stop doing that test.

The story is a bit of a litmus test for the tradeoff between personal medical privacy and collective medical necessity.
You say, '"Classy" in this case doesn't mean "class." Some people are turned off by vulgar language.' Your two statements seem to contradict each other; the first one is incorrect, and the second one is correct. Perhaps you do not know what the word "vulgar" means; it means "of the common people", that is to say, the lower class.
Washington: https://news.ycombinator.com/item?id=22548190
I think this is a typical example of populist mumbo-jumbo. How can you call an expert someone who can’t consciously decide their own confidence intervals?

However it’s so much easier to then for a non-expert to say that their half-baked solution worked due to the survivorship bias.

This point is incredibly popular because non-experts have less to loose by making dumb choices in the first place and there are way more non-experts, thus the whole set of non-experts can afford to be the fireflies in any industry.
I, too, went to AlAnon meetings when I was a teen. I honestly don't think I would be where I'm at today without going when I was younger.
Look up Martin Shkreli. You are patently wrong.
The Chinese government arrested doctors that tried to spread the word about the disease, and forced them to publicly retract their statements.

On what planet is the US government as bad as the Chinese government?
At a minimum, people are joking about it and at least one actual politician joined in: https://kdvr.com/news/local/if-i-do-get-coronavirus-im-atten...
Well, they said that they would continue, but that they don't expect to be able to track everything.

In fact from what I understand that have been able to track most cases.

Honestly, I'm guessing this is the case because they tracked the cases from original sources and then kept following them.

Being good at tracing could also explain why the number jumped so much. Tripling in 3 days, maybe it's easy to find cases if you trace contact :D
Also large swaths of the elderly dying is unlikely to have much of an effect on strengthening our gene pool, no?
I mean, sure, if your problem is such that a strategy like that works for you, I'm not going to tell you otherwise. You can log incoming messages and dump data out to files easily with Python too. I wouldn't want to call that a ‘database’, though, since it's no more than a daily archive.
EasyPost (YC S13) is hiring – Build APIs for millions of packages
Many people here are conflating "stop" with "make it non-exponential". "Stop" just ain't going to happen, and hasn't happened anywhere (Vietnam reports they have, but come on). China reports bending the curve away from exponential. That is the goal. It is a very important one.
5. Will invest in counterbioterrorism defense
> "...deploy the military...save a huge number of lives..."

really, that's the best solution to saving lives?

if you were really worried about preventable deaths, why don't you direct your fear-mongering and authoritarianism toward eradicating distracted driving, since car accidents kill a million people a year?

otherwise, wash your hands and keep a little distance from coughers/sneezers. if you get sick with (1) a high fever and (2) a dry cough, don't go out for 14 days after you feel better, unless you're so sick you need to go see a doctor.

that's it. stop with the hysteria.
Another my mechanics fan ;) Was literally just watching his latest video. Happy not to use WD40 if that's his advice.

I know oiling bearings which have grease in them is a no-no for just the reason you describe - will loosen the grease and so ultimately damage the bearing.
Random Numbers: Not so random
I mean we can do 2 things at once. Its like when there is a mass shooting and when someone suggests gun control as a solution the other side yells that people just died and their families are grieving and this is no time to be discussing taking guns away.

Then it happens again...
Let me tell you how the grocery stores in Italy are operating (I have relatives there):

First of all, you have to schedule a specific time slot to go shopping, to ensure that the store never gets too crowded. Secondly, you aren't allowed within two meters of anyone at any point. All of the store employees are wearing protective gear (gloves, masks, etc.). When you checkout, you push your cart up to them, they ring everything up, set it back down, and then you pack your bags yourself while they go away (to maintain a distance of two meters). They might be changing gloves with every checkout, too.

I have less knowledge of China, but I think it's similar. I saw a video of a ranged thermometer being used on every person before being allowed inside. Maybe Italy is doing similar. If and only if you have a fever or a confirmed infection then are you not allowed to leave your dwelling at all (unless it's to go to a hospital); that's when you get your food delivered.

With containment measures this drastic, you can definitely keep the infection rate below 1, which is all you need to stop an infection. And it's exactly these kinds of measures that need to be taken, because food is essential. You cannot have people starving to death en masse. Grocery stores are essential, and it's possible to allow grocery shipping while largely mitigating the spread of disease. Needless to say, all gatherings are banned, most stores are shut, and restaurants are to-go/delivery only (if they're even still open).

And I'm not drastically over-simplifying things, unless you somehow think that "shut down almost everything except for grocery stores and healthcare" is "over-simplified". This is working in China. They are stopping the spread of the disease while simultaneously maintaining access to food and healthcare.
Yes, I agree, the topic is becoming pretty hot these days, and this reflects the era of transpilers, WebAssembly, coming into play with its nested bytecode format, and other related topics. More people are getting interested in how things work under the hood, instead of just "using" a language.
Ever wondered how the dogfights worked?
Fully agree except that Italy’s CFR is most likely caused by its large proportion of elderly people. Compare to South Korea where the majority of infected are young and thus CFR is sub 1%.
Ah, okay. So Congress lacks that power because Congress decided it lacks that power.
I'm guessing a binary format is nice when interacting with a device..

Anybody know if (and why) U2F uses CBOR?
It’s an easy reference for a lot of people to understand what spirituality means.

Remember, many people who come to meetings can lack any formal education, be homeless, completely cut off from the internet/society etc etc etc.

If I were to start talking about chakras, spiritual energy or Soto zen, they’d think I was fucking mental!
1. Under a single payor system (as I outlined in reasons above) Trump would not have a monopolist style of control over healthcare - systems like that become resistant to the impulses of specific administration through their popularity.

2. Oh, the whitehouse is running around like a bunch of chickens with their heads cut off - state and local officials are doing pretty well and I am pretty convinced the CDC is doing a lot of work to make sure we accelerate the vaccine development.

I really really dislike the Trump administration, but it hasn't caused my to lose faith in the idea of governance. Also, to clarify, I'm not suggesting that I'd love to see Trump establish a single payor system - I assume such a system would be immeasurably damaged by intent and exist solely to damage the concept of single payor healthcare.
Discussed in 2015: https://news.ycombinator.com/item?id=9040841
https://www.repubblica.it/politica/2020/03/11/news/coronavir...
We can embrace what China has done, or what S. Korea has done, or what Singapore has done, or what Italy has finally started doing. Any of those would have a dramatically positive effect. Right now, we (U.S.) haven't done any of that. That is the problem.
That argument goes both ways, so. Totally agree on the general point.
The number of "detected" cases is influenced by the testing capability of those performing the tests. In a few days the real average "growth" rate will be clearer, but until the effects of some strong enough measures start to affect the numbers nobody can expect anything much better than what we see in Italy -- the curves across the Europe have "similar" growth:

https://twitter.com/MarkJHandley/status/1237781162153717760

or

https://twitter.com/illandancient/status/1237857213621907456
> Between hardware flaws like rowhammer, meltdown, spectre, etc. it's not possible to say that a piece of code isn't going to trigger something intentionally or not.

I guess I was thinking software vulnerabilities specifically (although in the context of this article I should have thought about the hardware side more). Or to be even more specific, flaws that are from that program in particular.
After Containment Fails, Italy’s Neighbors Shift to Epidemic Management
Not getting treated because there are no resources available is a completely separate problem from not getting treated because you don't have insurance. At that point you're down to solutions like converting the nearest hotel into a temporary hospital.
Because setting up websites is hard and they got frustrated.
Polar ice caps melting six times faster than in 1990s
They did a horrible job in the beginning and a good job in the end. They wasted december and january (both for themselves and the world) but the february response was quite effective. https://medium.com/@tomaspueyo/coronavirus-act-today-or-peop... is an informative illustration.

Right now, the USA response is somewhere between those two China approaches but it seems that it has been closer to the "early China" response than to the "late China" response.
Trans-oceanic air travel bans work very very well because there are few alternate routes to "illicit" travel.

The WHO made an idiotic generalization based on theoretical assumptions that didn't even apply.
Damn, that's some dark thinking. Really stretching the definition of "bright side"..
> Perhaps covid-19 was making the rounds in the US even before we officially declared it was here.

Yes, highly possible, one reearcher believes it was circulating in Washington state since at least middle of January. The term of art is "cryptic transmission".

https://www.washingtonpost.com/health/coronavirus-may-have-s...

Part of the problem is that the CDC's definitions were so strict at the time that you could not be tested unless you had personally traveled to China, so all cases of domestic transmission were being discounted at that time.
Wow - this reminds me of a sketch:

https://www.youtube.com/watch?v=owI7DOeO_yg

"I’m not saying do it, I’m just saying run it through the computer and see if it would work."
Yes, good point on pattern matching and algebraic data types (initially I was actually considering Rust for implementation, but not OCaml). The visitor pattern is a classic though, and is transferable knowledge further, to process different kinds of graphs, trees, etc. BTW, JavaScript will likely be getting pattern matching soon as well.
if they had flu-like symptoms, it's unlikely covid-19, because you typically have a lot of mucus in your cough, and covid-19's symptoms are principally (1) high fever and (2) dry cough.
Maybe, but our idiot president is currently trying to use the virus as an excuse to fund the wall along the Mexican border.

https://www.politico.com/news/2020/03/10/cdc-director-border...
So I got sober in AA just as pagers were becoming a thing. I was lucky and found a young people’s group in Pasadena.

If you have problems with Meetings, that’s cool. Find another one. Nothing is going to be handed to u cause you want to get sober. It took a little while before I found the right meetings. Or you can find a sponsor, no where in the big book does it say that u have to go to meetings.

But if anybody is telling what you can and can’t do then, start talking to Someone else... that’s just nonsense.

I’m always suspect of people with a grudge against AA. I’m here to help and if it’s not for you that’s cool to. I’m not Christian but if works for some and doesn’t hurt other then who am I to judge.
I dunno, the details of Christian theology and doctrine and systemd doctrinal differences seem equally silly to me.