skysight-inc/HackerNews huggingface dataset:
We’ve been using data loader a lot and it’s working ok. We were very careful to dump all sql queries our app was making per request to ensure we were not making more queries than necessary.

One thing I will say as we do make a lot of “IN” queries as a result. You fetch a bunch of rows with a data loader and then you want to fetch a bunch of rows from some other table based on those first results so you end up with an IN query where you might have had crafted a JOIN if you were writing it by hand.
Shouldn’t the charts be keyboard accessible?
For context, this is roughy 25 percent of the US working age population (~157 million people [1]). BLS participation rate date can be found here [2], but will have some lag to it.

[1] https://www.pewresearch.org/fact-tank/2019/08/29/facts-about...

[2] https://data.bls.gov/timeseries/LNS11300000
You make it sound like TI has disappeared and now is worthless. But it’s trading at a price higher than the 2000~ bubble. So maybe they are not taking over the world but they are doing quite well and still generating revenue.
We think about this at Hasura deeply!

I know it's counter intuitive, but we think of this as an opportunity to solve those problems at the Hasura layer. Sharding and caching are hard but also not impossible to make declarative if you know enough about how the data is modelled, how data ownership works (authorization) and how the cache is managed (caching hot queries, caching complex queries but infrequent, invalidated on time or data).

I'm not trying to say the problem isn't hard, I'm trying to ask what it would take to solve the problem. :) We're also actively working on solving them. Imagine if those challenges got solved for a sufficient number of use cases!

Incidentally, databases are getting better at preventing users outgrowing them too while preserving the SQL API as much as possible, or providing a transform. Citus / YugaByte / Planetscale / Cockroach / Spanner to name a few.
Why not just http://bluebirdjs.com/docs/api/promise.all.html ?
> Trained on 50,000 episodes of the game

Meanwhile an actual human will probably need only about 5 games to fully understand how the game works and reacts.
Looks like China's hand is a bit forced here from the last protest. They got scared from the last 2 major protests. Is just a chess move on their part and they always have more pieces.
> You'd earn less on paper but you'd have a better life

Exactly. "pay" is just a way to afford things that you value. If I can get those things, I'm happy; if not, I'm sad. "pay" is irrelevant unless compared to cost.
> I assume the trade is that fewer chips are produced from a wafer

Not really true once you scale down to a minimum viable size for your application, since you'll need plenty of area regardless for bonding pads, vias, interconnects etc. Nowadays the partial failure of Dennard scaling means that smaller chips may also be a lot harder to cool; it may be more advantageous to try and spread out logic in a way that might be a bit "wasteful" of area, if this makes the thermals more manageable. The real tradeoff wrt. very coarse nodes is performance.
I once saw this happening. Lots of bumblebees on tree leaves and flying around certain trees. I thought that they were eating something from the leaves. It seemed weird but I assumed it was a known behavior.
I'd say home storage is about $750 a kWh in the UK. Plus installation. What do you think, is the future a domestic 50kwh battery in every house or will they be fewer giant ones owned and run by the power company out of sight?
The average FB employee stays 2.6 years, so.. maybe? If all they are doing is training an AI on some cartoon avatars, they'll be fine. I imagine it would hurt their VR attempts at VR and games, where AAA projects generally last more than 3 years.
Furthermore, most companies still exercise some control over remote work whether formally or otherwise. That someone can work remotely mostly from a fixed address in the same country, doesn't mean they automatically have the right to work from a beach in Thailand or as a digital nomad.
All of these replies are for Mongo's product 5+ years ago. MongoDB has changed A LOT since then. Has anyone used MongoDB IN THE PAST 2 YEARS?
cram is a very good tool for testing in this manner: a test file is basically a copy/paste of a terminal window, deviations from expected behavior are represented using diffs, and `cram -i` will prompt you to update the test file with actual output. and it supports globbing and regular expressions for fuzzy matching.

i've been using cram for everything i write for what feels like a decade (it'll be 10 years old in september), and though it has it's limits, i bitch and moan about it very little given how much i rely on it. if you'd know me you'd recognize that this is a huge endorsement, i'm quite vocal about my disdain for most software in existence. :)

edit: s/i'll/it'll/ rofl

edit: url: https://bitheap.org/cram/
Herd-Like Movement of Fuzzy Green 'Glacier Mice' Baffles Scientists
How does that work? If you pay them in cash, then there is an incentive to juice the cash flow in the short term at the expense of long term. Stock that vests at various periods over future decades would be more long term oriented.
Ray Dalio – The Big Cycles over the Last 500 Years
Last night I asked Amazon Alexa to clap for NHS, darn thing started singing a song about science - well embarrassing when was expecting a loud clap to join in the chorus of neibours as done my wrist in and yet no, it started singing some song about science loudly and yeah, don't even want to think what my neibours thought if they heard that. Still could of been worse.
Not necessarily on topic but my biggest gripe with voice assistants is that they work like a web search. You can ask what the state of the world is NOW but you can get them to let you know when things happen. I want "Alexa, let me know when XXX is having a concert nearby" or "Alexa, tell me when XX is on sale". That's what I really want.
Invalid comparison for two reasons. Hong Kong as per release in the 90s was to be given autonomy over it's own territory. Secondly, while the US certainly has it's share of skeletons they do not compare to modern day China. As I recall, the last time the US hired organized crime to beat protestors in the streets was in the early 20th century.
"State security" in this regard means political policing and the arrest of dissidents. Up til now, HK policing has been under local control. This makes it abundantly clear that HK is going to be absorbed and lose its political freedoms.
Yes.

If we were going to start from scratch today, we'd probably use Postgres. But, realistically, the primary motivation behind that decision would be because Postgres is available on AWS, and that would centralize more of our operations. (DocumentDB is, of course available. Its not Mongo. I'd be curious to hear from people who actually had Mongo deployments and were able to move to DocumentDB; its missing so many of MongoDB's APIs that we physically can't, our applications would not run).

Mongo isn't that bad. It has limitations. You work within the limitations... or you don't. But I really don't think a valid option is "mongodb fuckin sucks m8, shit tier db". We're not going to be migrating terabytes of data and tens of thousands of lines of code when the benefit is tenuous for our business domain.

Should you use MongoDB today? I'll say No, but not for the reasons anyone else is giving. MongoDB's Cloud Provider agreement has decimated the cloud marketplace for the database. Essentially, if you want to run a version released in the past few years (4.2+), you need to be on their first-party Atlas product. Many other parties, especially the big clouds, are on 3.6 (or have compatibility products like DocumentDB/CosmosDB which target 3.6). Atlas is great. Its fairly priced and has a great UX and operations experience. But, I don't feel comfortable about there being political reasons why I couldn't change providers if that changes. If you have business requirements which demand, say, data in a specific region, or government-class infra, or specific compliance frameworks, Atlas may not be able to meet them.
This is an incarnation of the https://en.wikipedia.org/wiki/Functor_represented_by_a_schem... perspective on https://en.wikipedia.org/wiki/Scheme_(mathematics), the fundamental object of study in modern algebraic geometry.

This perspective could be interpreted as treating equations as recipes and number systems, (fields/rings) as ingredients. It turns out to be extremely fruitful to study the "R-points" of an equation for all sorts of rings R, even more exotic ones like p-adic numbers or finite fields.

Algebraic geometry and the study of schemes is a truly beautiful field of mathematics, linking number theory to theoretical physics, and much more.
The context in Hong Kong is completely different. Hong Kong is only part of China because the CCP agreed to the terms of the Sino-British Joint Declaration (https://en.wikipedia.org/wiki/Sino-British_Joint_Declaration), which specified that its existing laws and institutions would be preserved as they were under British rule until the year 2047.
3 aborted landings is a lot.

Isn’t it considered good policy to redirect after a few aborted landings?

(Not a Pilot).
Can't read the whole article but I wonder what he thinks of new, fintech-y banks like:

https://www.bunq.com/

https://n26.com

https://www.revolut.com

Edit: I see he did look at Revolut, would be nice to be able to read the whole thing haha.
Can you provide more context? Why would this help?
I am not the person you're replying to, but in my experience / opinion if you want to do distributed high-performance numerical computing, executing on heterogeneous hardware, C++ is really far and away the best language to get this done. If you're CPU-only, maybe Fortran is a better option but when GPUs enter the mix I don't see how you're going to have an easier time getting the requisite performance with anything else.

I mean, like, you can interface with TensorFlow via Python but the big-kid parts of the implementation are in C++ / CUDA.
IBM still make the Z line of mainframes most major insurance credit card etc companies still rely on them.
Good Bad Books at Project Gutenberg Australia:

http://gutenberg.net.au/ebooks03/0300011h.html#part27
Mongo is the PHP of databases. Just because it did change doesn't mean people want to use it.
Fundamentally, this is because we have already been trained on years of living in and reacting to the real world, which, to some abstract degree, the game mimicks. The Nvidia model starts with nothing.
Lighthouse Audit of Airbnb.com
I wouldn't say "fully" https://www.gamasutra.com/view/feature/3938/the_pacman_dossi...

& also that humans come with a huge amount of training beforehand. We've experienced eating & ghost stories & moving around in 3d spatial dimensions before playing pacman usually
Why would you? The philosphy is the same even if you have better locking. It hasn't changed substantially. The only time you get schemas even are when you use it with like BI connectors. And that's just an accomodation.
Thanks for the feedback! Improving the documentation is definitely one of my priorities, but I hadn't thought of documenting the overall structure. Do you have any suggestions for how best to do that?
The simple guide to Cypress.io test automation
The gist:

IP law lets software have the best-of-both-worlds. Source code is patentable & protected by copyright, but is also a trade-secret (because it's not publicly disclosed).

This is problematic when these black-box algorithms are used to assist in the processing of legal cases.

-----

My 2 cents:

- The overall concern that our lives are being governed by the invisible hand of black-box abstractions really resonates with me. Richard Stallman has been warning us about this for a while [0], and I've personally started considering my role in this as a software engineer [1], although I don't have any actionable advice yet.

- I don't feel as strongly that all of this code should be open-source. I think it might be sufficient to just strictly define a series of tests -- measure the inputs & outputs, describe the requirements... that kind of thing.

It's inherently difficult whenever there's a constantly-evolving ML model behind the curtain. It reminds me of the issues with using AI in the aviation industry, for instance [2]. As I recall from my undergraduate classes, aviation control systems have been unable to use "fuzzy" logic to pilot planes due to strict deterministic testing requirements.

[0] https://www.gnu.org/philosophy/free-software-even-more-impor...

[1] https://gazzini.com/essays/posts/tools/

[2] https://www.nlr.org/areas-of-change/introduction-non-determi...
Hey, "he" is me. So I can answer:

I've never used Bunq or N26. But I did include Revolut!

Cheers
A few inspiring podcasts featuring Naval Ravikant
There are companies that specialize in FPGA to ASIC conversion, and I think it works by sharing masks with other custom ASIC orders. So I think it’s feasible at thousands of units. It’s something like 50% lower power and cost per unit than FPGA and a little higher speed as well. Not super dramatic, but is a pretty easy path. I think $10,000 to $35,000 non-recurring costs plus the cost of the chips themselves. Potentially in the Kickstarter range.

Full custom ASICs get much higher performance, lower power, lower per unit cost but have like a minimum of $500,000 NRE costs.
According to chapter 1 article 5 of Hong Kong basic law, yes:

"The socialist system and policies shall not be practiced in the Hong Kong Special Administrative Region, and the previous capitalist system and way of life shall remain unchanged for 50 years."

(50 years from 1997)
But does the query plan perform a join? The text of your query matters less than the plan it generates.
> The same WHO that mislead the global community about COVID-19 for months and is in the pocket of China?

What misleading are you referring to? WHO declared it an International Health Emergency on Jan 30th. We knew this was a huge global risk and unfortunately were still under-prepared for the full wave a month later. There were certainly some missteps made along the way
I wonder if this will eventually affect cryptocurrency exchanges in Hong Kong. For example, as far as allowing US citizens.
Thanks thats helpful.
Facebook to let people work from home forever
Why is this on hacker news ?
Iconsizer – Save hours of your time by getting icon resolutions for all devices
It's verging into the same old "this is not censorship it's a private company" argument.

What right has any human against a private company? Why even comment in this thread?

Sarcasm btw.
The mention of Pakistan's "chequered aviation safety record" got me wondering how it compares to other airlines.

I came across this site [0], and found the data to be really interesting. Pakistan International Airlines ranks decently well, while Southwest Airlines ranks among the worst.

[0] https://www.airlineratings.com/safety-rating-tool/
This research reminds me of one of their April Fool’s videos [1] with a gaming USB stick that you plug into your computer to offer various gaming enhancements. One of which is a “Ghostplay” feature where an AI program can mimic you after training on your gameplay.

I remember that video because it always struck me as not being far off from reality. It’ll make the current set of online game cheats/hacks seem like child’s play if it can be done effectively (read: human-like and undetectable). Maybe then a server-running AI will be needed to detect AI-like gameplay mimicry.

[1] https://youtu.be/smM-Wdk2RLQ
Save it?
Apple gets more profitable each day. last year it has 1-year returns of 70%
What do you mean by that? (I would expect that question for focusable elements, but the charts don't appear to have any focus-elements?)
The blog post went out back when COVID-19 wasn't a thing.
okay, so, yes. under his supervision, microsoft did do a lot of damage to the world of open source software. they set an example that fundamentally changed the relationship between users and software, and that example continues to stand in the way of software freedom today.

but his (and his wife's) post-microsoft health research philanthropy has literally prevented the early death of hundreds of millions of people by funding vaccines, developing sustainable agriculture, etc.

ftr, i agree that the idolatry is harmful.
It's just an oped
Quick plug: we've made good progress on solving this very problem for the SQLAlchemy ORM in Python. Our approach is a bit like Join-Monster but more flexible because:

- we introspect your SQLAlchemy models and generate Dataloader-based resolvers that emit small independent SQL queries. This way this optimization composes naturally with other GraphQL types in your schema.
- we are thin wrapper on top of Graphene, the main GraphQL Python library. It makes it very easy to extend your type if needed. We also added ways to rename and modify the type of a column / field.
- for the SQL query generation we currently lean on SQLAlchemy to do the heavy lifting. It can emit efficient in IN() JOIN queries for us.

So far, it's been working quite nicely for us. We were able to generate decently performant schemas with very boilerplate on top of our existing SQLAlchemy models. And each time we've run into a case that the library did not optimize well for us, we were able to easily override its behavior by writing our SQLAlchemy queries.

There is still room for performance improvements but I'm confident we'll get there eventually (though I expect the optimizations to only work for DBs that support LATERAL JOINs). My main focus at the moment is to come up with an API that it possible to create performant types that aggregate multiple tables.

Links
- https://github.com/graphql-python/graphene-sqlalchemy
- https://github.com/graphql-python/graphene-sqlalchemy/pull/2...

EDIT: formatting
What's whiteout for if not edit as you go? I used so much of it back in the day.
An important distinction.
I don't think there where three aborted landings. My understanding is there was only one go around. This is backed up by flightradar24's altitude graph: https://twitter.com/flightradar24/status/1263800350060003328...

Generally there are alternate airports chosen for if a plane can't land at its desired destination + fuel for multiple aborted landings
You’re saying it wrong: How to say oft-mispronounced tech terms
It's using a 2017 core because it's an early-2018 chip. They've got a more modern chip in development (the Altra) with the Neoverse-N1 core, the same core used in Graviton2.
And working population of Nigeria is 111 milion.

> The attackers have used detailed information about U.S. citizens, such as social security numbers that may have been obtained from cyber hacks of years past, to file claims on behalf of people who have not been laid off, officials said. The attack has exploited state unemployment systems at a time when they are straining to process a crush of claims from an employment crisis unmatched since the Great Depression.

https://www.nytimes.com/2020/05/16/us/coronavirus-unemployme...
When Air India gets privatized for good ;)

Jokes aside, airlines around the world are pretty much nationalized one way or the other -- and we have to re-evaluate things on the other side of pandemic 2 years from now.
Just dived in[1], but apparently this isn't so much a plan as a plan to have a plan. In particular it mentions a EU Forest Strategy to be proposed in 2021. You know, it sounds "nice", but here's the pet peeve I have whenever I hear about reforestation efforts nowadays: there's no talk about making sure the trees in the forest are themselves, y'know, biodiverse. It's easy to plant a lot of trees if they're all the same species, clones, etc. but the problem is you end up with a forest that isn't so resilient to either natural disaster nor disease. Entire crops of trees have been wiped out before because the, to put it mildly, economical approach to getting things done quickly meant just planting a lot of the same species of tree.

Well, I guess we'll see next year what their EU Forest Strategy is, I hope they take biodiversity in the flora as seriously as biodiversity in the fauna.

[1] https://ec.europa.eu/info/sites/info/files/communication-ann...
Considering the folks IBM needs most of the time, it will never be hard to hire more.
Where have you ever seen a 50% discount for an industrial commodity?
Great video. How do you increase your negotiation odds using body language when the other person is wearing a mask?
I'm curious as well, since my company is moving from Postgres to DynamoDB.
I've worked extensively with mechanical engineers on large scale projects. This level of creativity is very much alive today. We just don't get exposed to it as much here on HN.
Not to dismiss the gravity of the situation, but engineering and process failures are interesting to this audience. This is one example, likely of the latter.
But the post points out that Siri from other Apple devices gets it right. Apple’s “generic knowledge system” can answer this. It’s only Apple Watch which has trouble.

That’s kind of weird. It’s not that Siri is especially bad. It’s that “Siri” is something different depending on how you query it. Other online search systems aren’t like that, and integration and consistency are typically Apple’s forte.
I think a few more.

Early games will establish things like "can ghosts go through each other", "if I hit the wall do I die" (like in Snake; though on Acorn Electron you could eat the wall sometimes!), "can ghosts go through the shortcut", "how long do pills last", do all pills last the same amount of time".

Then later efforts would be needed to know things like "what algorithm do the ghosts follow", "does the same colour ghost always follow the same algo", "do ghost algos change when you eat a fruit", "what order do the fruit go in" ...

Of course you could guess a lot of these, but that's not what "fully understand how the game works" means.
The craziest and most confusing behavior of Siri for me is:

Sometimes you can ask a question and watch it be perfectly transcribed in real time, but then receive a nonsensical answer from it. Ask the exact same question immediately after on the same device, transcribed exactly the same way, and get the correct answer.

Where does such unpredictability come from? How can Siri transcribe the words correctly but fail to deliver the right answer?
True. So substitute "living" with "currently located in". Makes the problem of correctly considering the context of that question just even more complicated ;-)
"Off-Topic: [..] If they'd cover it on TV news, it's probably off-topic." (and it appears previous submissions of this indeed did get flagged. Wheareas an after-the-fact analysis of the causes IMHO would be on-topic)

(But also: "Please don't complain that a submission is inappropriate. If a story is spam or off-topic, flag it.")
Eleventy: Customizing File Structure, URLs and Browsersync Like a Pro
I'm fairly sure they could still control and monetize such a product. Kind of like Android.

Maybe there's already something like that in the works, with all the talk and investment in AI, we should be seeing some real world results...
As somebody who has been stuck using IBM Clearcase or DOORS the end of IBM can't come soon enough.
How big are the chances that the most prominent passenger is the sole survivor of a plane crash (yet, but I don't expect many more)? The Bank of Panjab president, whow! Lucky guy.
This incident occurred in my neighborhood. The plane crashed in a residential area and the overall death toll is still unknown. There are a few confirmed survivors so far:
President of Bank of Punjab and a 3-year-old kid.