skysight-inc/HackerNews huggingface dataset:
Excellent question! I'll jump in - I am a part of the DuckDB team though, so if other users have thoughts it would be great to get other perspectives as well.

First things first - we really like quite a lot about the SQLite approach. DuckDB is similarly easy to install and is built without dependencies, just like SQLite. It also runs in the same process as your application just like SQLite does. SQLite is excellent as a transactional database - lots of very specific inserts, updates, and deletes (called OLTP workloads). DuckDB can also read directly out of SQLite files as well, so you can mix and match them! (https://github.com/duckdblabs/sqlitescanner)

DuckDB is much faster than SQLite when doing analytical queries (OLAP) like when calculating summaries or trends over time, or joining large tables together. It can use all of your CPU cores for sometimes ~100x speedup over SQLite.

DuckDB also has some enhancements with respect to data transfer in and out of it. It can natively read Pandas, R, and Julia dataframes, and can read parquet files directly also (meaning without inserting first!).

Does that help? Happy to add more details!
> Is it the casino foult that their customers loose money

Since “customers losing money” is the entire business model and what casinos work to optimize, yes, obviously.
> so arguably they're getting protection they'd otherwise have to pay for for free.

"Pay for..." To whom? Do you think NATO works like the EU, redistributing money from "membership fees" to "subsidy recipients"? All the NATO countries pay for their own militaries out of their own budgets.

> I'm no fan of him nor his regime, but thinking he'll back down if we just escalate the situation a little more is fantasy.

Whoa, resurrection! Hallelujah! But why you, of all people?!? We'd all hoped you'd stay dead, Mr Chamberlain.

> EDIT: sigh, are we really just reddit these days, using downvotes to express disagreement?

No, this is HN. According to a comment I got from dang some time ago -- or was it just a link to the guidelines, so it's there? -- downvotes are a legitimate expression of disagreement.

> I'm not going to change my mind based on downvotes. Comment to tell me how I'm wrong.

Done. Keep whining, and you can have a downvote on top.
"Sales fixes everything" means that when you look at any random problem like "turnout is really big, how we can keep people for longer?"¹, often the fastest solution is to answer "hey, how can we increase sales?".

Answering that later question can lead you into any direction. Maybe you need more sales people, maybe your product sucks, maybe you must spend more on marketing. The point is not on how, the point is that the later one is the one goal you can have more impact on, and it will lead you into solving the former.

1 - On this case, with higher salaries, but there isn't enough money to increase them, thus the actionable question.
Sounds absurd. What country are we talking?
>If you don't put their logo on your products, no caps.

New HEVC-Only Platform License - Royalty Rate Structure for Licensees In-Compliance without Trademark Discount has Caps. And the Standard Structure for HEVC Licensees with no caps are there for specific uses only under trademark dispute.
Maybe the problem is that communities are weak. Imagine saying "We don't need stronger restrictions. I am OK if my kid is kidnapped as a result because the community will be stronger for it overall due to free range kids etc." You really need to care about your community to do that.
This is just a personal viewpoint, but I think the era of "just ship it" will be gone after a decade or so.

* Software "development" skill will become so common and cheap that simple tools won't get any market.

* The market will be dictated by tools instead of code content.

* Language-as-a-service will be a thing, as it allows customers to fill in business requirements AND allows the backing company to perform engineering behind the scene.
You're ignoring that they are worse on every metric but below-freezing charging than lithium batteries:

NiZn: 70 to 85Wh / kg

Lifepo4: > 180

NiZn: 1000 charge-discharge cycles

Lifepo4: 3000 cycles

NiZn: significant self-discharge

Lifepo4: negligible self-discharge

NiZn: nickel is more expensive than all the metals in lifepo4 and more environmentally damaging to extract

There's nothing good about them, even if the dendrite problem was solved (which I doubt).

Lifepo4 can be recycled just fine, provided there's actually enough of them to be recycled, which won't be for a long time since they last so long.
How to Change Your Mind, by Michael Pollan
Tether is an unregulated, uninsured, bank
I've always been annoyed they replaced "Philosopher's Stone" with "Sorcerer's Stone" in the title of the Harry Potter novel, for American consumption. It feels kinda of insulting, frankly.

I recently and randomly picked up a Japanese book, 1Q84. I was enjoying it quite a bit, when I started thinking about the cultural references it contained - it has numerous references to Western classical music and Sean Connery. It worried me that they might have actually replaced Japanese music and actors with western "equivalents". But of course, there has been a great deal of cultural cross pollination, so it is no more unusual for a Japanese person to be aware of Sean Connery or The Brothers Grimm than it is for me. I didn't want to spoil the book by reading reviews before I read the book itself, but I skimmed enough to gather the Sean Connery part, at least, seems to be original source material.

Part of the attraction in reading a book like that is the fact that it is a Japanese book. It feels demeaning to have take that away because they worry the foreigness of it will be disturbing or unwelcomed by American readers.
Astronomers capture first image of Milky Way’s black hole
This relies on the assumption that there are powerful offices that no one wants to have, and that if they aren't filled a lottery would be run and someone picked up randomly from the street to fill those offices.
Yeah, ok, an RFID implant is cool, but it's just something embedded under your skin, so a far cry from a computer interface implanted in your brain...
Compiling C to WebAssembly and Running It – Without Emscripten
Oh yes, I'm sure all these efforts have been entirely with good intentions. Afterall, fundamentally they are 'protecting the children'.

The saying goes though, the road to hell is paved with good intentions.

We proactively need to defund the road to hell.
The "us" in "let us" are humans that are alive 30,000 years after a hypothetical quasar starts at SgrA*. The image would look realtime to us. Just weird relativity things.
Because if they are backed to only say 20% where did the rest of the money go? Did $80B disappear or what? And what are the reason to believe they did other than conspiracy theories? Why would they not just buy $80B worth of bonds to collect free interest on them?
Answered a similar comment by someone else here: https://news.ycombinator.com/item?id=31354470
Crap, the best ones I've read are mostly in Spanish, books by Gabriel Rolón or by Jorge Bucay were really helpful to me to help me reframe my POV of the world.

I tried to find translations for them, but with no luck.
I think the concept here is more "Trojan Horse for implementation of Chinese-style mass surveillance" than "well-intentioned effort aimed at protecting children".

The correct criminal approach for defeating child abuse rings is targeted investigation, not mass surveillance of everyone in the population. This for example involves using undercover police to infiltrate such rings and arrest their members. This is not a novel idea, either.
I like that better than technics. :D
Allow referencing columns defined previously in the same query would make duckdb competitive for data analytics. Without that one has to chain With statements for just the tiniest operations.

select 1 as x, x + 2 as y, y/x as z;
So wait, your point is "Governments are going to spy on you no matter what"... and your plan is to make measures that protect against that such as encryption illegal?
Again, thanks for taking the time to write! It is certainly good advice!

Luckily the situation is in this specific case is that I don't have to worry about it - I'm 100% sure of it. My nightmares come more from the fear that I will finish one day and find out that I took too long and I missed my window of opportunity.
I found that surprising. According to the first Google result[1], it is true that loitering near a school is illegal, BUT loitering doesn't mean just being there. It means being there with an unlawful purpose; they give an example of someone waiting to abduct a child. Watching kids play isn't otherwise a crime, so wouldn't qualify.

I definitely sympathize with the author. As a male, I would expect an even stronger reaction to hanging around watching kids with no clear intent. As others have pointed out, even if you're not committing a crime you can be in for an unpleasant response. It's sad that there are creeps out there. It's sad that as a result, certain innocent behaviors make others nervous (rationally or irrationally). It also gives me a small taste of what it's like to be judged by my category/appearance.

[1]https://www.losangelescriminallawyer.pro/california-penal-co...
The EU law in the works doesn't only cover images.
Not to pick a point, but that's true of all legislation.

Making something illegal is much easier than making something that was previously illegal: legal.

That's just how legislation works in all systems. One need only look at constitutions.

"undemocratic" is a stretch, people are still voting for representatives, representatives of the people are still voting. Nobody is deciding something by themselves. Unless we've changed what democracy means.
It would probably take months to implement SSO with all of the flexibility and ease of use they offer, mainly just because of the built-in integrations with so many providers. The price is pretty steep though, so this would really only be used by the big bucks Enterprise Software™ guys.
I only stopped checking the websites of a couple YouTube channels I follow, because they stopped updating them reliably. I preferred that to checking on YouTube, because sometimes it takes me a bit to find a simple chronological list of videos from a channel, while the sites were just that, right on the front page.
> Get ready for TikTok to become the new Wikipedia within a decade.

I've also learned a lot from TikTok, where short form content has led to 30 second tutorials that leave 30 minute YouTube equivalents in their dust. My learning topics include smartphone photography, wood working, and knots. I was also surprised at how informative it can be.

It'll be interesting to see how TikTok's content moderation compares against Wikipedia. We won't have notability wars, but there is massive scope for disinformation and banal wrongness.
Kim's a dude. Not a big deal. Just thought you'd like to know.

I didn't like the detective-ish novel set in NYC after the climate change crisis but if I'd lived an appreciable time there I might have.
Personally im glad how much attention its drawn to zero knowledge proofs. its a fascinating area, and before bitcoin it was a somewhat obscure corner of cryptography.
Right, because every case like that is going to be written about in an article that gets shared a ton because it is so shocking, and then covered on the news, and discussed on forums, and turned into a TV movie.

The story is crazy and scary and disturbed, so of COURSE it is going to be shared and people are going to remember it. The details get seared into your memory. It is a nightmare scenario.

The same day that happened, in the US ~90 people were killed in car accidents and ~550 kids were kidnapped by a family member. Those events won't be seared in our mind, though.
Tether is unaudited. USDC has at least been audited by a global tier-1 accounting firm. That’s a huge difference.
This has always been there and now I'm taking note of everyone replying thanking him for this change.
The super hearts, coins, and stars were part of Periscope
North Carolina, USA. I've heard some similar stories from friends back in Michigan as well, though not quite as severe.

Re 'candy shop' - it was about 400 feet from the restaurant.
As a parent in the US, here is how it feels. If I let my young kids roam and something happens to them, there is a high likelihood that some goody-goody-holier-than-thou prosecutor will decide to make an example out of my "neglect".
Persistent indexes are being actively worked on! Stay tuned. As for the crashes - DuckDB is very well tested and used in production in many places. The core functionality is very mature!
Let us know if you test it out! Happy to help if I can.

(disclaimer - on the DuckDB team)
As a laboratory-scale experimentalist, I heartily agree, but must also point out the existence of compelling precision equivalence principle tests.

While we can only measure G to ~10 ppm, the equivalence principle has been tested at the 10^{-14} level (and ~10^{-9} at meter-scales). The EP is the property that makes gravity really special and simultaneously the thing that makes gravity hard to test.

The core assertion that all things fall the same way is axiomatic to GR and has been very well tested. We have everything left to learn about gravity, but at the same time, GR has held up far better than it "should" have against a battery of really great experiments.
So that people could not bypass DRM (Digital Rights Management, not Direct Rendering Manager). And signing the firmware would not help because with source code it is easier to find vulnerabilities in signature verification code. Though they still could publish the firmware partially.
Sorry, the view is more that traditional civil liberties reinforces white supremacist power structures (I think the ACLU actually has a page on this?). So that those in the ACLU perusing what were some of those "traditional" civil liberties things (free speech etc) were supporting white supremacy. The ACLU has moved away from that towards some of the speech = violence approach which then basically allows a violent response.
Just to cause trouble, since we're straying far far from today's presentations (except arguably UCL's Z. Younsi in the ongoing ESO Q&A panel). :-) Can we write down the uncertainty principle in covariant form? Maybe! There is active theoretical work ongoing (e.g.) <https://arxiv.org/abs/2110.15951v2> ("... a geometric formalism for the generalised uncertainty principle which is covariant and connects features of the underlying geometry with the deformation of canonical commutator relations ... [and] an elegant interpretation for the standard dispersion relation p^2=−m^2: it describes flat spacetime in the Milne coordinates, with rest mass m giving the measure of geodesic length from origin").
No paywall: https://archive.ph/ouyTy

I used https://archive.is to find it.
The dynamic version: https://archive.is/https://www.nytimes.com/2022/05/10/busine...
Yes. In many municipalities loitering is illegal - and has been for several decades. You don't have to go home, but you can't stay here. Too be honest I'm not sure why you find that so surprising seeing as how it wasn't all that long ago your skin color affected what parts of town you could be present in (to some extent this still persists, but you're not likely to be jailed for it - unless the police engagement invokes a negative reaction on your part.)
“they created this and/or are the main drivers”

The media has an incentive to produce emotion inducing content and politician will naturally leverage those emotions because American politics are pure pathos.

If you cannot see how that leads to gloom and doom oriented media and politicians that lean on eschatological themes, you aren’t woke.
Show HN: Display daily records and normal temperatures from across the US
Very minimally, sure. You also save a whole pile of money.
Is it not possible that it would be preferable to both sides, even in a hot NATO-Russian war to stick with conventional weapons?

Russia just wants Lebensraum, which would be ruined by nukes, and NATO would probably not want to seem excessively cruel to Russian civilians when their purpose is supposed to be entirely defensive.
Yes, good thought! That is listed at the bottom of the article as something we are looking at for the future.
And what kind of neighborhood is this?

I take it's not a "daycare is a cash only business and cops know what real crime looks like" type place.
MicroStrategy's Bitcoin bet turns negative
When was banking over the internet particularly insecure?
Being arrested and dragged into court to defend yourself will seriously negatively impact your life all on its own.
It is not valid criticism if you are only critical of an person because you are on the other team.
macOS: How to Disable Homebrew Analytics
1Q84's author, Haruki Murakami, is a notable fan of both jazz and (Western) classical music. And Connery is well known in Japan, at least partly because his Bond classic You Only Live Twice was set there.
I didn't check the name of the author before reading and was surprised when I realized she was a woman and had to deal with that. Had she been a man, I can assume the police would have been called without first approaching her.
That wasn't his point at all. Instead of badly paraphrasing why don't you reply to what he actually wrote. He was clarifying the situation unlike everyone else talking in hyperboles. I'm not for this specific suggestion but Ashton and his foundation are truly trying to help fight child trafficking. Let's talk through a solution instead of ignoring it or slandering those trying to do something.
> we also need to have the balls to say "this long term non-specific harm of the surveillance state is worse than a few kids getting abused".

There is a false assumption here that such a surveillance program would even be effective and not just a stepping stone to arguing for more invasive measures when it doesn't fix anything.

The better argument is "this long term non-specific harm of government surveillance is worse than the harm it would successfully prevent to children." And then you can go on to describe the specific harms that state surveillance and overreach has brought about or enabled...
It surprised me that it was a woman. Usually people are more lenient to them than man.

I was discussing that, some time ago, with a female friend (I am a male) who also loves doing street photography. We talked about how difficult it is for a man to do street photography, specially around places with a lot of kids, as you will always receive strange looks or even threats. If you're a woman taking photos? Probably a mother or mother-to-be, if you're a man? Pedophile.

I wonder if there are that many people exposing themselves to kids as the security lady said in the article. Seems like an excuse to justify the action, or something that happened once and they are overreacting to it...
“Je n’ai fait celle-ci plus longue que parce que je n’ai pas eu le loisir de la faire plus courte.” -Blaise Pascal

Complexity is not planned, it is created though expediency. Devs use that database because they’ve done it before, they know how to use it, and they have a bunch of code segments to reuse. It gets them one step closer to solving the problem. An elegant solution, presumably some form of binary serialization, would require a learning how, and maybe rethinking objects to strip out cruft and make serializable state, and then coming up with an efficient access pattern. All these things are nice elegant composable tools available somewhere, but not at the top of mind like MySQL, which you’ve been using since your first programming course.

I’ve been doing a lot of work with C++20 templates recently. The simplicity and reasonability benefits can be enormous, but the time it takes to learn, design, and craft them is completely oblivious to the person reviewing the code, if it ever gets reviewed at all. In a corporate setting, the only thing anybody sees is lines of code. Remote work has strengthened this anti-pattern. Nobody sees the time or diligence with which you craft solutions. Elegance looks like nothing.
I'm kinda more of a 'provide regulations and let the courts settle this out with the shareholders' kinda guy.

Also a true free market allows trading strategies that let you bet against something. Yes, they're abused, but in many cases they provide the best form of market regulation.
These are called London Dispersion forces. You can think of it somewhat like an electrostatic interaction except on a “temporary” basis, like fluctuations in the electron densities around nuclei spontaneously cause weak attraction between these atoms. The weakness of the attraction of these forces is why Ne atoms are so easily broken by thermal forces, ie why Ne is a monoatomic gas.

So yes, there is a binding force, but it is very weak.
they can't, the moment they do, they'll be roasted for doing it.

Really?

https://www.theguardian.com/world/2021/jan/14/dutch-governme...

The Dutch IRS ran a shadow profile system for over ten years, resulting in countless families in financial trouble, numerous divorces, suicides, and kids being removed from their parents and placed in foster care. Compensation/restitution for the affected families is finally coming, but its tragically slow progress is adding insult to injury.

And the government that stepped down over it, is still (again) in power. The very same prime minister that has presided over the country during the entire time this program ran was re-elected after his previous cabinet dissolved.

None of the people working at the IRS have even seen the inside of a courtroom, at least not as defendant. Such a roasting they got.
I am young so take my answer with a grain of salt but a digital watch number is instantly recognizable to me, more so then an analog watch.
> demands of modern shell scripts cannot be met by typical shell philosophy

That. Pipes and unstructured binary data isn't compositional enough, making the divide between the kinds of things you can express in the language you use to write a stage in a pipeline and the kinds of things you can express by building a pipeline too large.
> I get that Ashton is trying to do the right thing here. The problem is the solutions are just so short sighted. I dug through his website and came across a blog post [1] they made blasting Facebook for implementing E2E on Facebook/IG Messenger.

I would argue that he's just trying to make money. Lobbying politicians so that a requirement for a product becomes enshrined in law, while your organization just happens to be providing that product? For a fee, of course. This is just plain old greed in a wrapper of virtue signaling. Yuck.
I am familiar with article you posted and others that, as I mentioned before, argue the F-35 did not have the latest software. Mostly the argument has always been, it does not matter because in modern air combat dogfight don't happen anymore. The fight in Ukraine is showing exactly the opposite.

The article you posted was written as a first person account, by a non military Pilot, ex-FoxNews reporter, ex-CNN reporter, ex-Pentagon procurement expert. I quoted the actual F-35 pilot involved in the dogfight with the F-16.

The overall F-35 program is bigger than the PIB of some countries, so from the beginning when the bad news started to come up, there was a strong incentive to
present the program on a certain way.

"U.S. Air Force instructs airmen on exactly how to praise the F-35":
https://fortune.com/2015/09/25/air-force-f-35/

I think by now the US Air Force already understood the program is a failure.

"The U.S. Air Force Just Admitted The F-35 Stealth Fighter Has Failed":
https://www.forbes.com/sites/davidaxe/2021/02/23/the-us-air-...
I don't think this is true if you are taking the common but technically precise mathematical meanings of 'almost all' and 'the surface'.