skysight-inc/HackerNews huggingface dataset:
Your example is a fun one and not too hard to do.

Thinking about the intersection of sets is important for grokking what you're trying to do in that example (and with SQL in general). For me, at least, SQL suddenly made a lot of sense when the idea that I was working with intersections and subsets of sets.

In your example you have (1) a set of all dates in a range, and (2) a set of sales totals for days that had sales. Set 1 could be a "numbers table" or generated with something like "generate_series()" in PostgreSQL. Set 2 is made by summarizing the data in a sales table by date using "GROUP BY" and "SUM".

Then you're just looking at JOIN'ing those sets and COAELSCE'ing the NULL returned from days when there are no sales into 0.
"Can I use RClone or rsync or an SSH / SFTP connection?"

I think there's a cloud storage provider that lets you use any tool you want over SSH ... including rclone and borg ...

It's not coming to me ... on the tip of my tongue ...
It's ridiculous to claim as fact something as subjective as "[whether COVID-19 is serious] is heavily disputed" (emphasis on the highly subjective words). It's also disingenuous to imply that the only thing a statement communicates is the factual part of the words. And, even disregarding all of that, you're ignoring this statement:

>we are still at the "those people were going to die within a year anyway" phase.
Wrong version, newer versions are still supported.

https://www.ibm.com/support/lifecycle/#/details?q45=U977729P...
Also interesting (from the "See also" section) -- List of oldest known surviving buildings[0].

[0] https://en.wikipedia.org/wiki/List_of_oldest_known_surviving...
Fair enough, and to the extent this article is focused on Chase specifically perhaps my comment is attached to the wrong HN discussion, and should apply more broadly to the general PPP conversation, which has seemed a little confused this week.
Improving Technical Tutorials by Providing Sample Data
Lululemon sacks employee over China T-shirt uproar
As a developer: I do care, but it's hard for me to focus on building software if I also need to think about DBA tasks, DevOps tasks, and so on. These things all take time, patience, and energy. I've just spent most of today running and re-running a CloudFormation template to create a SQL database. Most. Of. A. Day. It's partly because I'm not a DevOps expert and even if I wanted to be one, that would also take time, patience and energy.

There's a reason people have specializations...
Interesting idea! Yes, I could see that working!

What other interesting ideas does the community have?
In some ways, the ISA bootcamps would be in the most demand during a recession. Because you don't pay for tuition outright, you're only paying with your time/opportunity cost. For someone who's laid off, that just became free. And if you don't get hired for a year because the economy is frozen/thawing, then you don't have to pay anything during that period.

If I were looking at bootcamps, I would put ISA-based ones at the top of my list. But I'd expect them to get more selective since they'll need to adjust their payback calculus given the economic uncertainty.
It is rare today that banks hold mortgages and use depositor funds to fund them. Most (government backed, such as FHA, Fannie, and Freddie) mortgages are securitized and sold on the secondary market to bondholders (there are caveats for small banks, credit unions, and non-qm lenders).

A narrow bank does not require lending to service deposit accounts. It doesn't even need to pay interest to account holders. It simply needs to accept, store, and distribute fiat on the behalf of its customers via ACH, debit, and credit processing networks. Think prepaid card with no fees and no overdraft capability.

The Federal Reserve is culpable in that it will not approve banking licenses for narrow banks [1], as it challenges the business model of existing entrenched banking organizations. Can you build a narrow bank without getting the Fed to sign off? That is a conversation I would be interested in having over a cup of coffee.

[1] https://www.spglobal.com/marketintelligence/en/news-insights...
Rome?
I feel there is a mechanism (sleep deprivation?) that causes amnesia of the most difficult months of raising a newborn. By the time the baby is a year old or so, the pain is forgotten, the baby is cuter (and interactive!), and the parents start to think, "Maybe we want to do this again..."

I'm glad I got my vasectomy done when our youngest was still in that first stage.
It is rather amusing how this doesn't work in IE11. I'd almost be inclined to fork and make a version that does, just for the heck of it... for you know, corporate environments that need Win98-styled intranets :)
GitX still had one of the best visualisations. But it bugged so often I had to replace it with Fork https://fork.dev
I personally think Universities and colleges are a scam that was necessary before we had access to the bulk of human knowledge on the tip of our fingers. We should go back to an apprentice system, go through elementary and middle school and then find a profession you would want to learn OTJ, this would shift the responsibility of training to companies but the people coming out of there would be immediately productive.
Why I'm Building a Side Dish (and Maybe You Should Too)
>Currently, worldwide food production exceeds 2,750 kilocalories per person per day [15], which exceeds the amount required to feed the global population. Although these data account for farm-level waste, they do not include the estimated 20% household food waste [44]. Hence, currently available calories are likely to be about 2,200 kilocalories per person per day, which is sufficient for the world’s current population [23].

Sauce: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC6198966/

Right under that they note that our food groups are out of whack, but in terms of calories, we could feed everybody... we just don't. It's not just a problem of profit motives; as GP noted, distribution is a real issue. Many places with famine problems also have issues with government stability, and dropping crates of food from the sky just gives food to the people with guns and vehicles who can secure it. If you think about this problem from the point of view of a legitimately charitable entity with tons of cash, it's still not entirely clear how to end world hunger without either propping up small dictatorships or undermining local sovereignty. The last mile is a hard problem. Edit: and obviously, some people eat too much, and we throw away food because of weird profit motives. I'm not trying to downplay those causes of human misery, just trying to point out that there are other hard decisions to be made on the path to feeding all humans.
Show HN: Nuntium – API to track the media presence of any organization or person
Why do we expect socialist policies to produce impartial results? Imagine instead if we did something like remove minimum wage, society from the lowest rungs would see wealth it hasn't seen in decades. Sure there are negative externalities, but are they worse than current outcomes? I'm not so confident they are.
The Missing Manual for Defending Yourself Against Cancel Culture
I've worked remotely 90% of the time for the last 7 years and this ain't it.

My partner and I are now homeschooling both of our children while attempting to work full time remote. The results are mixed, with the kids mostly getting the short end of the stick so our lively hoods can remain intact.
I agree, I don't mind lists like "Largest countries" as that is fairly definitive but when you get into subjective lists of things that are hard to properly define, measure or record like "costliest hurricane damage"[1], "longest-living organisms"[2] or "deadliest animals"[3] then the articles become a joke.

[1] https://en.wikipedia.org/wiki/List_of_Atlantic_hurricane_rec...

[2] https://en.wikipedia.org/wiki/List_of_longest-living_organis...

[3] https://en.wikipedia.org/wiki/List_of_deadliest_animals_to_h...
https://github.com/astronomer

https://astronomer.io

Open source Airflow platform on Kunernetes with commercial support. Best Airflow product on the market by far.
Since I had to implement something like that in rust for a base32 codec [1] a few years ago I really like the idea. Although my main concern was ensuring that invariants are checked by the type system, which might not be as much a concern in c with its implicit conversions?

[1] https://github.com/rust-bitcoin/rust-bech32/blob/master/src/...
Not only that but if you had an application in progress, they now have this text when you return to try to complete it (they shut it down shortly after sending out the email to complete applications):

Last Updated: April 22, 2020 10:30 a.m. ET

Message from Jennifer Roberts, CEO of Chase Business Banking
It appears Congress will approve additional funding for the Paycheck Protection Program, which is encouraging news for thousands more of our small businesses.

We’ll begin submitting applications as soon as the SBA gives the green light. We never stopped working our large application queue because we know how important this money is for your business.

We’ve decided not to take any new applications now. We’ll keep monitoring the funding availability and may consider taking new applicants in the future.

I wish we could help every business through this program, but funds could run out again quickly and we have preexisting applications in our queue. We will continue to process and submit applications until funds are exhausted.

Sincerely,
Jennifer Roberts
This appears to be IBM's response.

https://www.ibm.com/support/pages/ibm-data-risk-manager-vuln...
We sadly still are in the phase where some people are saying that.
This seems interesting to me... the one question I have (that others here haven't asked, anyway), is whether 'permanent' means 'imutable', or if I can replace files with newer versions? My use-case is a large shared ebook library where I sometimes replace files with improved conversions (updated cover art, smaller files, improved CSS or standards compliance, etc.).
A DBA can't fix a developer's code. A good 3/4 of the list linked in TFA are things a DBA or Architect can't affect.

At some point, a developer needs to be responsible for how they use a tool that's been provided for them. Abstractions break.
>How weird would it be to tell someone...they don't actually like it

where did I say anything about OP liking or not liking thing?
Yeah it was a IIc - I had overlooked the plus because I didn't even know the IIc+ existed.
I quickly loose an appetite to do anything in medical space due to hardcore regulation. I applied couple times at medical equipment manufacturers and I was always told, that I’ll spend at least 2 days every week documenting things for examination later. I don’t think, hackers love documentation.
Rome, Jerusalem, Athens, maybe Istanbul.
I think your analysis is overly critical. The stated purpose of Wikipedia's no-OR policy is not to "reach or imply a conclusion not stated by the sources". The only novel conclusion being drawn here is that one can conceive of a list of the oldest continuously inhabited cities in the world.
Wikipedia policy also notes that "The potential for creating lists is infinite." and prohibits lists that do not comply with Wikipedia's overall content policy as being "trivial, non-encyclopedic, or not related to human knowledge".
https://en.wikipedia.org/wiki/Wikipedia:Stand-alone_lists#Ap...

I personally think that this list is really interesting and does in fact advance the state of human knowledge. The fact that it's currently at the top of HN and has garnered comment interest shows that you're probably in the minority in your disagreement.

If you feel strongly that this list is trivial, poorly organized, or simply "awful" you're absolutely free to join the discussion and contribute edits at Wikipedia.
Polish universities are completely free. And yes, British universities are not free, they have recently gotten pretty expensive(£9000/year), with the exception of Scottish ones which have different rules.
It's possible to delete the Mail app (which I had already done on my phone). I'd hope that would kill related daemons. I'm jailbroken as well so I'll check if the daemon is running later tonight.
So this must mean serious fiber is available in SA... Up to what speed? From where did AWS get its internet connection into this region?
This culture of the top hard sciences students cheating & not caring about the required humanities classes happens in the US too, at least at top universities/colleges that are heavily focused on match/science.

It was definitely a thing where I went to college. The humanities classes were very easy compared to the engineering/science/math classes. The school required them to try and round people out. But the humanities teachers were lazy or unskilled enough that it became exceedingly easy for people to cheat.

The canonical example is the humanities teacher who gives the exact same tests every time he/she teaches the class for 20 years. After a couple years every fraternity & sorority had a file in their study room that had every assignment & test problem that professor ever gave. So you'd have one student from the fraternity/sorority who was low on the totem pole go to class to collect the homework/requirements. Everyone else would just look at the test files to get the answers and then show up for the tests. Generally everyone would get an A, including the students who never went to class except on test days.

This was partly evil, but it was also partly students prioritizing their work hours on the vastly harder courses they were taking in their fields of study, namely the courses that were important to doing well in their field.

I graduated with a 3.7, I didn't really cheat like this, but I did put lower priority on getting top marks in the humanities class. If I got a B in a humanities class in order to allow myself to spend more time on a Computer Science class so that I could get an A in the CS class instead of a B or C that was fine with me.

At the high school level in the US everything is bifurcated into a two tier system.. one tier for the serious students who want to do well and go to college. Another tier that is state sponsored baby sitting for the students who don't want to do well and whose parents don't care.
How does this not break sizeof ?
Most AZs are 1 DC, but some are too large to fit in a single building.

I don't think there is a distance limit between AZs but instead a latency limit. James Hamilton covered it in one of his keynotes a few years ago.

EBS sticking in the same AZ has nothing to do with distance and everything to do with keeping failures within an AZ
Real Sound: Kaze no Regret – A videogame designed for the blind
I'd love to know if there's any use to this beyond FPGAs. This just seems to be another case of porting the complexity of RTL design into C syntax so that they can claim they have an HLS product that compiles C to gates. It's not C to gates if you had to rewrite all your C to manually specific the bit widths of every single signal. I really wonder how far we can keep going before the naming police break into Intel Headquarters and rename all their marketing material with "Low Level Synthesis".
I'm very much in support of this. One thing I like about Zig[1] s that integers are explicitly given sizes. I've been playing recently with it, but I'm waiting for a specific "TODO" in the compiler to be fixed.

[1] https://ziglang.org/
Very true, especially when it comes to scroll bars and similar elements. While I do enjoy some "modern" aesthetics from time to time, the Win98 style UI just feels far more "productive", for lack of a better term.

And as much as I like that Linux in many ways often keeps that type of UI around, I still feel like Win98 did it better (almost can't believe I'm saying that).
Development of a custom ERP system for an automotive business
Well, I do not think we are at the point where AI powered robots can fully replace a human service worker, but, we can definitely have a hybrid solution, where remote workers can control the more difficult parts.

So, jobs for the unemployed, and robots that can’t get sick.
Congress wrote the bill, yes, but in this case did so in very close coordination with the Treasury, specifically the Secretary, who presumably had a lot of input on the specifics. So it’s definitely not just on Congress, here... plenty of blame to go around.
The most charitable interpretation of the comment is that the author's only opinion is that whether the disease is serious is heavily debated, which is still an opinion that can be disagreed with.
For most women abortion has no serious lasting negative psychological consequences.
Fast Fibonacci numbers using Monoids
Do you see yourself phasing out couch base, or do you see a reason to keep both?
I think it’s because many (most?) people would prefer Ruth’s Chris failing over their local mom and pop. I think I’m in that boat and I like Ruth’s Chris, except the one in SF - was not impressed.
Larger companies weren't supposed to be the target of the "small business" loans/grants.

$500 billion was set up for corporate bailouts.

$350 billion for small business.

Large companies took both.

America is mostly small business, money should have gone directly to them via SBA/IRS and then they get to pick the bank to service it like the FAFSA student loan system. There should never have been banks needing to process these, all the information is already known. It was a filter to make sure big business got it.

Many larger companies just wanted the 1% loan that has to be paid back in 2 years. They have access to other funding and have more assets for leverage in those dealings. Small businesses, true small business now, do not have that access to capital.

The PPP for instance 75% needed to go to payroll, so larger companies free up other money, and use the PPP for payroll while continuing to roll. 25% can be used for non payroll but other needed expenses. It was a sham.

The rules also hit small business harder on payback, the amount that turns into a grant is based on retained employees, so with a smaller headcount, less people leaving causes a bigger hit for small business. It should have had a revenue component to that.

Fact: companies on the public markets are not "small business", zero would be classified that way in any other metric.

If you truly think most of the money is going to go to individuals in the end I have a 'bailout' to sell you.
"I would say the companies who are at least honest about exploiting our data such as Google and Facebook are more ethical."

Luckily, those are not your only two choices - there are cloud storage providers that are simultaneously privacy minded[1], technically sophisticated[2], and honest about their business practices[3].

[1] https://www.rsync.net/resources/notices/canary.txt

[2] https://www.rsync.net/resources/howto/remote_commands.html

[3] https://www.rsync.net/resources/regulatory/pci.html
How fast coronavirus is spreading in each state
> How on earth would voting actually solve something like this?

By removing from power the corrupt officials who colluded with JPM and other large corporations to steal stimulus money from small businesses?

JPM benefited from corruption of the political process. Corruption is enabled by minority rule. Minority rule is enabled by citizen apathy, like when people start saying that “voting isn’t acting!”.

By voting en masse, we as citizens get to 1) hold corrupt officials accountable, and 2) strengthen the democratic process by making it more representative, and therefore less vulnerable to corruption in the future.

As a side note: in my experience, people who say things like “voting is not acting, you need to do more!” are not reliable voters, and not reliable activists either. On the other hand, the most proactive voters tend to already know what else they can do. Electoral activism leads to broader activism.

TLDR: start by taking voting seriously.
They're still not the same service. Matchmaking is about grouping people together for the game, presumably dependent on their geographical location (for latency) and their skill-level (to balance the game), etc. Dedicated game servers, on the other hand, host the actual multiplayer session.

It's similar to the distinction Netflix uses between their control plane (hosted on AWS) and their content-delivery (hosted on their 'Open Connect' CDN).
What was wrong with the actual title?

> The New Clang _ExtInt Feature Provides Exact Bitwidth Integer Types
A real world version of Pokémon Go let’s you track orangutans in the jungle
> That's quite a statement you made there, especially in the context of Africa.

As the [dead] sibling states, it is absolutely true, and has been true since the maturing of the Green Revolution in the 70's. Famines since then have all been caused by war and politics, not by weather or crop failures.
That's exactly it. In effect it cost 2% to use the banking system to complete this transaction.

With these kinds of insane numbers ($350B!) even tiny percentages are huge.
We built a couple products using PolyForth in the '90s ... I didn't hate it but I'm not really interested in returning to coding in a Forth dialect (maybe on uP and uC). On the other hand, I learned a lot about programming in general which seems to happen every time I use a language that isn't C-like.
There will be plenty reporting about corruption and nothing will happen. This is just a continuation of 2008. People have accepted this corruption as normal.
This is an American perspective but I think this could be an Anglo phenomenon so let me take a crack at it.

When I was brought up, the image of what a successful student was, was a very well rounded one. The perfect student was a diligent worker in all courses and always an athlete. Athletics was very very tied to the image of being a proper student because basically athletics = team and team = learning to work with others to overcome challenges and work towards a goal + being physically fit.

This is the gist of it, it's a bit hard to explain without living it. Also there is a religious aspect thrown in because America.

This was the image of the perfect young adult given to me by Boy Scouts and the image my private school friends were given by their schools. At my public school though everything was a bit watered down as we got far less development attention than private school kids would get.

For non-Americans reading: private school = good, public school = bad, in terms of education in the US(usually). I know this is flipped in some places.
It’s a shame that finding the corruption in a few years is generally the best case scenario in these type of situations. Long after the public has any real memory or care to actually do anything about it. A handful of scapegoats get prosecuted and the world continues on as normal.
This is dishonest. The author absolutely did not simply say "there are still people thinking it's not a big deal".
> I firmly believe that every developer should spend 2-3 weeks early in their career working with nothing but SQL. It will pay huge dividends for the rest of it.

i did tons of sql couple of years ago on a reporting team. Now I do android dev fulltime and don't remember any SQL beyond basics, highly doubt it will all come back to me if i tried.
Banks make somewhere around 450 billion in revenue each year.
https://www.statista.com/forecasts/409713/banking-revenue-in...

This program made them 1/3 of 1 month's normal revenue
Is that even possible to have a serological test that can't give false positives? Field contamination etc would seem to be something that can't be prevented.
Maybe everyone doesn't have 401k, but pretty much every pension scheme around the world is in some way linked to the performance of the stock and bond markets. Even the ones that aren't rely on people being employed and paying taxes.
You can't after 2 hours.
Apple Mail for iPhone may be vulnerable to malware attacks