skysight-inc/HackerNews huggingface dataset:
DuckDB looks very interesting and I'm quite excited to examine it more closely in the next few days!

I just wanted to add to the discussion that an unchanging file format, or at least a backwards compatible one, is a key feature of sqlite. See for example Richard Hipp's comments here [1] (I think he also mentioned earlier in the talk that the file format has become a limiting factor now in terms of some of the refactoring that they can do). The file format therefore seems likely to be a major factor in the long term success of this project and I am glad to see that you are taking your time before settling on any architecture here.

Given that you are targeting the data science and analytics space, what are your plans for integration with arrow and the feather file format? From a purely user/developer perspective, arrow's aim of shared memory data structures across different analytics tools, seems like a great goal. I know Wes McKinney and Ursa Labs have also spent quite some time at the file storage part of this, see for example the Feather V2 announcement [2].

What are your thoughts on the tradeoffs they considered and how do you see the requirements of DuckDB in relation to theirs?

From the Carnegie Mellon DuckDB talk [3], I saw that you already have a zero-copy reader to the pandas memory data structures, so the vision I have is that DuckDB could be the universal SQL interface to arrow datasets which can then also be shared with more complex ML models. Is that something that we can hope for or are there obstacles to this?

[1] https://youtu.be/Jib2AmRb_rk?t=3150

[2] https://ursalabs.org/blog/2020-feather-v2/

[3] https://www.youtube.com/watch?v=PFUZlNQIndo
We need physical audio kill switches
> wouldn't it be nice if downvotes had a little more friction

Upvotes have much less friction. Downvoted posts are not merely downvoted, they are also not upvoted. Why don't people upvote posts that are unfairly downvoted?
There is nothing that would make the average New Yorker happier than the collapse of real estate prices and the evacuation of big business. Most New Yorkers rent their apartments and fondly remember a time before their corner stores were Starbucks, Duane Reade and Chase. You do the math.

New York City has more millionaires than any other city. But the average New Yorker isn't a millionaire. These changes are bad for millionaires and partially caused by their exodus already. The people who stay will have an easier time affording their homes and starting their small businesses. That doesn't sound like the end to me.
Its nearly tautological that any nation with a "long history" would distrust foreign powers. Foreign powers have a strong tendency to end the history of a nation.
In fairness, a lot of what you described is probably what ambitious and extraverted hopeful executives are doing implicitly and instinctively in their heads. It's just that in the context of you being an engineer and "saying the quiet part out loud" (so to speak), it does come off as a bit overbearing and maybe mad-scientist.

I think it's possible for you to execute it well, but it will require real empathy for the people who are your "targets". It sounds like you are aware of that though, so good luck with the plan!
This is such an ignorant comment that I've seen perpetuated around the internet recently, that I made an account just to respond to this.

HIV positive people on medication, cannot spread HIV. It's factually safer to have sex with an HIV positive person on meds, than a person who doesn't get tested and doesn't know their status.

This law exists so that HIV positive people who cannot spread the virus are not legally obligated to tell others they have the virus.

Please learn more about what it means to be HIV positive, and the discrimination that comes with it before making these horrible disparaging comments.

Undetectable = Uninfectable (u=u) maybe a good thing for you to Google.
The irony is a US Judge rules to Protect an app that does not allow free speech on the basis of free speech.
Nobody in their right mind would choose Java for anything ML-related.
Major Evolutionary Blunders: The 'Poor Design' of Our Recurrent Laryngeal Nerve
"this is a type of economic disaster very different than a hurricane, wildfire, or even the 2008 financial crisis."

This is a point worth noting. It is like a wildfire in the sense that because of the pandemic, fewer salads were made and served. But, there isn't any destruction to physical capital like buildings or whatnot.

This kind of gets to some economic debate questions, moreso from past generations. Economies, at least modern ones, often deal with physical losses better than money/debt problems.
Because the Chinese apps aren't illegal in US law.
No new cases outside quarantine or isolation, as assessed by a competent, evidenced-based governmental authority.

There have been four positive cases of Covid-19 outside of managed isolation or quarantine, Prime Minister Jacinda Ardern says.

After 102 days without community transmission they are the first cases acquired from an unknown source. New Zealand is now activating a resurgence plan.

https://www.rnz.co.nz/news/national/423305/covid-19-new-case...

NZ resumed level 3 on August 12, where level 4 is the most restrictive:

people are to work from home unless they are essential workers, and stay in their bubbles. Bars and restaurants will have to close, and restrictions come in place for funerals and weddings.

Conditions are regularly monitored, assessed, and adjusted. From September 4:

Cabinet has decided to keep the current alert levels and will review them again on Monday, September 14, when they will decide whether to adjust them at 11.59pm on Wednesday, September 16.

It comes as director general of health Ashley Bloomfield reveals five new cases of Covid-19. Three are in the community.

https://www.nzherald.co.nz/nz/news/article.cfm?c_id=1&object...
Start with Jan Gehl or B.V. Doshi.

EDIT: Also check out and explore - https://en.wikipedia.org/wiki/Third_place
I typically only look for upvoted content. Prefix your searches with "site:reddit.com", "site:news.ycombinator.com" or "site:stackoverflow.com" - The social/human filter is quite a good one in my experience and it gets rid of all the Medium-like personal branding fluff.
Autonomous robotic nanofabrication with reinforcement learning
Autonomous robotic nanofabrication with reinforcement learning

https://arxiv.org/pdf/2002.11952.pdf
> "This has been a real problem again in the Windows 10 era. By around 2008, Microsoft seemed to have finally gotten their patch process cleaned up to the point that if you were only taking security patches, they generally installed cleanly and mostly didn't break random things. By about 2016 this has backslid and now Windows 10 seems intent on large scale combined updates and constant servicing stack updates that with undocumented consequences."

Microsoft laid off all their QA staff in 2014, so it's hardly surprising. If anything, it's a wonder that it's not much, much worse than it is now.
They may technically not have a veto within the company, but that’s not really that relevant.

1. The CCP has advanced access to the company’s plans.

2. The representative can always say something like, “this would meet with disapproval by the party”.

It’s not a formal veto, but it is an implied threat.
"The difference between TikTok and WeChat and FB/Google/Twitter is obvious: the former are to some degree controlled by China and the latter are private entities."

I think that difference is not that wide as people believe. Throwing money into advertising on any platform will get you close or beyond ideological subversion or active measures.

All you have to do is look at the radicalization and the polarization of left and right in the US and you will see you don't need a state controlled entity at all.
The ICIJ and ProPublica consistently put out the highest quality investigative journalism, exposing injustices committed by some of the biggest institutions in the world. Blows mainstream media out the water.

I strongly recommend users here to donate to both, and even to cancel subscriptions to major media institutions, who have opted to dropped investigative journalism for sensationalism.

[1] https://checkout.fundjournalism.org/memberform?org_id=icij&i...

[2] https://donate.propublica.org/give/141278/#!/donation/checko...
2

There are too many weird compromises and bugs with it. Better to stick with a tidier abstraction.
FWIW, the quote about money on the ground initially comes from a critique on the efficient market hypothesis, not commentary on the nature of ideas. So it's expected for there to be analogical disconnect here.

For it to work as intended, you'd have to construct (or buy into) some framework for an "efficient marketplace of ideas."
This is one really important counterpoint. The internet made it more economical.

Another is that in days before the internet, the technology for small numbers of people to cause mass violence did not exist.
Can be quite high, in the 100 bar range and above.
Even if you agree that China needs to be checked in its aggressive use of technology for state purposes (which I partly agree with, but not without saying that the US is not innocent of that activity either), at least let's not be naive about it.

Don't think that the banning of apps was a well-reasoned decision with careful justification about the causes, potential, solutions, and impacts on US economics and society. It was a guy asking "what can we do to create some leverage over this adversary I don't like? (and was just told about yesterday)"

Don't deceive yourself that this is some step in a principled fight. If it were that, we'd have slapped tariffs/embargoes and more on Russia a couple of years ago. We'd be implementing measures against Venezuela, Myanmar, North Korea, a whole host of countries doing similar or worse. I haven't heard a peep about those.

It's not good when government operates on a whim. The same hammer may swing against you next time, with equally poor justification, which you created support for.

Don't deceive yourself about what principle (and person) you're getting behind.
Trump actively contradicted scientific guidance and told people not to wear masks, dramatically increasing spread. He refused to use the Defense Production Act to manufacture PPE, leading to shortages for both medical and civilian use for many months, increasing spread. His lack of central leadership and guidance forced states into adhoc responses, with people freely moving between areas with different restrictions and spreading the virus. His administration put states in bidding wars that raised prices and limited the ability of states to buy equipment, and then confiscated the equipment they tried to buy anyway. His administration has contradicted, insulted, and publicly questioned Dr. Fauci, the CDC, the WHO and all experts. Trump has personally down distrust in our most important institutions. The government's attempt to politicize case numbers and CDC guidance has broken decades of trust.

At every stage, Trump has done the worst thing possible. Hundreds of thousands of deaths are DIRECTLY attributed to him.

4 weeks of "everyone wear a mask and stay isolates, we'll pay your salary" would have dramatically dropped case numbers and R0. Instead we're still in our initial outbreak.
My point was regarding WSL2. I will never use macOS again though. That is completely dead for me but that’s a whole another story.
Oh, an actual mouse, not a computer mouse.
"Burning" may not be the right word. Denaturing (i.e., the proteins losing their quaternary structure) may be what increases bio-availability
The difference is that China has been able to redress the power embalance. The decendents of slaves and indigenous Americans have not.
The Libre-SoC Hybrid 3D CPU [pdf]
> It seems strange to buy a house in a country that can kick you out on no notice through no fault of your own.

OK, it's strange to buy a house. What about marrying and having a kid? Many H1B workers here have lived there for decades (with no realistic hope of a green card in sight). Must we stay childless because we can be kicked out on no notice?

I know your statement is well-intentioned but it comes off as one of those things that's easy to say in 'abstract' but it demonstrates a lack of understanding of actual life situations of people.
I think the issue is more one less of Broadcom wanting protection as much as having a chip foundry and selling chips, but not wishing to risk a legion of Non-Practicing Entities combing through their implementations with a fine tooth comb and a portfolio of held semiconductor IP.
> NYC is staggeringly large...

So if anything, I'd expect there to be an economy of scale. High population density means there are less streets to clean and less trees to groom.
As someone who recently did that after ~8 years, I found it useful to skim through Modern Java in Action. It should be pretty easy read if you've been doing more modern languages, but important to learn Java semantics and nuances. Also, I highly recommend Java Concurrency in Practice, but it's a tougher read.

That said, for most orgs, the biggest changes you might see would be in libraries and frameworks used. There will most likely be less XML, better build tools and more modular library usage than 12 years ago.
Wouldn't you say that the next logical step is to go up an abstraction then? Assembly -> C -> OOP/FP -> ??? In that case, wouldn't it make more sense if that abstraction was build on top of something which you can mathematically reason about?
another take:

> Judge Beeler, sitting in San Francisco, noted that "while the general evidence about the threat to national security related to China (regarding technology and mobile technology) is considerable, the specific evidence about WeChat is modest".

A judge, in a city that is the stronghold of the party that is opposing the current administration, admits the national security threat, but thinks the threat is modest.

A judge who is apparently not familiar with Chinese government threatening overseas Uighurs, https://www.theatlantic.com/international/archive/2019/08/ch... and https://thehill.com/opinion/international/501008-beyond-xinj... and overseas Chinese critics https://www.reuters.com/article/us-usa-china-wray/china-coer.... And couldn't bother to notice the recent Chinese government's desire to control private companies https://www.nytimes.com/2020/09/17/business/china-communist-.... A judge who didn't bother to google before ruling on an extremely important National security issue.

A judge that IMO, has overstepped her bound.
It definitely can’t be replaced by a traditional blacker. All the blockers for Safari are one step above worthless, and have been since they changed their plugin architecture.
I haven't seen Formula 1 race in a long time.

Watching the video, I initially was very impressed that the industry came up with some almost-instant refuelling technique.

Less impressed now, after finding out that refuelling has not been a thing for over 10 years...
There’s nothing that makes a programming language good or bad - they all can do the job. It’s a matter of personal preference - Java might be “objectively worse” for you, but it might the best language possible for thousands of other developers.
Huh, I've always thought the banks were afraid of touching money from sanctioned people because of fear of the American freeze-out: if a bank lands in the list, then American institutions (AFAIK) can't do business with them, so no money tansfers from American banks to their clients (indeed from any bank, because that bank would also be breaking the American law), and they wouldn't be able to work with VISA or MasterCard, things any bank would need to do to be successful as a bank.

But I guess nowadays these banks have even less to worry about, because the occupant of the White House is at least a corrupt twit, and at most someone helped by Putin so Putin and his friends could put their money back into the global economy without the involved handlers/recipients fearing US crackdown. ("But every word of the Mueller report was a complete hoaxed fabrication!", will come the unnuanced defense).
> I think legalization is an important step on the path to social acceptance. Examples: Marijuana, abortion, gay marriage

Social acceptance among whom? Half of the country votes for a party that made reversing Obergefell, the Supreme Court case that made gay marriage legal in the US, part of its party platform[1] in 2016 and 2020:

> Defending Marriage Against an Activist Judiciary

> Traditional marriage and family, based on marriage between one man and one woman, is the foundation for a free society and has for millennia been entrusted with rearing children and instilling cultural values. We condemn the Supreme Court’s ruling in United States v. Windsor, which wrongly removed the ability of Congress to define marriage policy in federal law. We also condemn the Supreme Court’s lawless ruling in Obergefell v. Hodges, which in the words of the late Justice Antonin Scalia, was a “judicial Putsch” — full of “silly extravagances” — that reduced “the disciplined legal reasoning of John Marshall and Joseph Storey to the mystical aphorisms of a fortune cookie.” In Obergefell, five unelected lawyers robbed 320 million Americans of their legitimate constitutional authority to define marriage as the union of one man and one woman. The Court twisted the meaning of the Fourteenth Amendment beyond recognition. To echo Scalia, we dissent. We, therefore, support the appointment of justices and judges who respect the constitutional limits on their power and respect the authority of the states to decide such fundamental social questions.

> Our laws and our government’s regulations should recognize marriage as the union of one man and one woman and actively promote married family life as the basis of a stable and prosperous society. For that reason, as explained elsewhere in this platform, we do not accept the Supreme Court’s redefinition of marriage and we urge its reversal, whether through judicial reconsideration or a constitutional amendment returning control over marriage to the states.

[1] https://gop.com/platform/
I'd find that more compelling in the presence of meaningful contact tracing, which in general seems to be lacking in the U.S.

I'm more inclined to trust an epidemiologist who says they'd rather fly in an airplane than eat at a bar, a quote I found today but regret I can't locate at the moment.
How many cases did they trace? Out of a much smaller number of cases in quebec, more than 80 have been traced to bars and restaurants. (The govt hasn’t been forthcoming with data, but in one week they disclosed at least that many from bars)

There is perhaps some factor unique to that town or their contact tracing isn’t extensive?
My guess is that the amounts are large, and there would be less complaints from the participants if the bank holds on to the money longer to maximize their vig. Of course, there could be some off-the-books incentives for deal-makers at the banks.
> are in fact likely against it due to American tech unions hating H1Bs

That’s a new one. What are these American tech unions you are speaking of? Googling only brings up a few obscure organizations that I’m sure don’t have much influence with the Democrats.
What do you mean by 'residue'?
How many of those cases were traced at all? The denominator of this analysis should be the number of positive cases traced, not the whole population.
So exactly like the Tiktok oracle deal? The US is taking the low road while pointing fingers.
Remember BCCI? https://www.newsweek.com/cia-and-bcci-202850
Also it's a great distraction from Russian interference in the election, which the intelligence community is more concerned with than it is Chinese interference, but helps Trump.
> I cannot perceive that today's computer is 100x faster or more than 20-30 years ago

Seems pretty obvious when comparing, say, Duke Nukem 3D with Far Cry 5. Or Wolfenstein 3D with Assassin's Creed Odyssey.
As is smoking, drinking, fast food, sugar, and driving. And yet...
I _think_ if you have applied for Premium Processing and get the receipt, you can start working with the new employer. But please check with your employer's lawyers, as these things can keep changing and the rules are too complex for me to keep track of.
> Also it's worth noting that government edicts likely aren't the primary cause of business closures at this point.

Ok, do you have any evidence for this besides your personal opinion?
The official explanation was something like helping uses by reserving the domain name from anyone else registering it before the user decided to purchase, but of course the obvious motive is as you've said.
All job growth was concentrated in the service sector, and they tended to not be good jobs. The ethical issues with this were apparent well before 2019. There needed to be a change in individual preferences, as well as attention to lack of progress in things like education, daycare, and health care.
Prepare for Hacktoberfest 2020 Now
Not so.
What causes have the other 19,920 COVID cases been traced to? I read the articles you linked and this is the only other data I could find:

“The results showed that more than a thousand COVID-19 cases had been linked to construction and nursing homes - while bars and restaurants had just 22 cases.”

1,000 cases from construction and nursing homes brings the number to 18,920 cases we need data on. This is the problem. There is so little high confidence tracing data that we can’t make strong decisions on what quarantine actions are materially impactful. Whose to say a substantial amount of that remaining number isn’t caused by bars and restaurants? If that data is out there, please share it. If not, please support more rigorous contact tracing.
That's because bars were among the first things to be shut down. The policies work and are the primary reason things aren't even worse currently.

Restaurants and bars are very conducive to spread: https://wwwnc.cdc.gov/eid/article/26/7/20-0764_article
Robert Gore was not the first to discover ePTFE (Gore Tex) material, but the prior inventor kept his invention as a trade secret. Robert Gore has defended his patent against original inventor, won, and then sued anyone who has uses equipment made by the original inventor.
I haven't looked into the individual cases this is about and I'm certain that some crossed a line, but with regards to the following:

> The leaked documents, known as the FinCEN Files, include more than 2,100 suspicious activity reports filed by banks and other financial firms with the U.S. Department of Treasury’s Financial Crimes Enforcement Network.

First, the banks actively filed these reports, so it's not like they were trying to hide these transactions. The ones they really wanted to hide, you won't find in these reports.

Second, the bar for "suspicious activity" is usually set quite low -- it's usually literally just activity that doesn't seem 100% kosher. You don't know of any wrong-doing (because if you did, you'd be an accomplice), but something just does not smell quite right.

Banks report these because they are required to. If they don't and they get caught in an audit, there are hefty fines.

Edit: Note that these reports are filed immediately when the activity occurs and regulators can jump onto the activity straight away. So while one can accuse many banks of committing many sins, a suspicious activity report is not something that I would normally consider sinister.
He got tired of kids complaining of issues without contributing code. Just filter list issues, which are not really his fault but the list maintainers.
So remember when you're feeling very small and insecure
How amazingly unlikely is your birth
And pray that there's intelligent life somewhere up in space
Cause there's bugger-all down here on Earth