skysight-inc/HackerNews huggingface dataset:
I'm not talking about plain SQL, I'm talking about the included procedural language that often ships with it[1] as an extension and which is much more DBMS specific.

So, the question is, does your team know SQL/PSM, or PL/SQL, or PL/pgSQL, or some other variant, and how well.

1: https://en.wikipedia.org/wiki/SQL#Procedural_extensions
For sure you can offer a good approximation through SQL but I'm unlucky enough that I've needed to support dynamic sorting and query builders against tables at least 4 times for different datasets in the past years.

I'm particularly proud of the last one I built that still absolutely flies despite doing wildcard querying on text fields (no full text index) with multiple combined queries and a dynamically computed status from aggregate child properties in MySQL 5 with its lack of window functions. The solution was basically dynamically construct an efficient as possible inner query before applying the joins.

To clarify I believe in doing as much as possible in raw SQL and have a fondness for the stored procedure driven system I worked with but this problem remains unsolvable in SQL alone and I just keep encountering it.
That's insulting.

Please read more:
https://journals.sagepub.com/doi/abs/10.1177/001100001663350...
It's so hard to find anymore. Digital board games are one exception, there are a lot of really excellent ones with great replay value for a fixed price. Scythe, Root, Spirit Island, Railroad Ink, Wingspan, Through the Ages, Galaxy Trucker...
Without flogging corporations, the public won't be able to act on their bad behaviors.

Imagine if there were no articles written about Amazon, or Airbnb, and instead there were only article written about exploitation of workers or skirting the hotel laws as bad things that are happening (either in theory or out there in the wild). In that case, the public won't actualize it or internalize it enough to take action with who they vote for, and in turn elected officials won't bother taking action because their constituents don't know/don't care and so it's not important for them either.
It went sideways when the CCP/PRC realized that they could just sell off their citizens to U.S. corporations as cheap slave labor. My speculation is that they also figured out an effective system for blackmailing the executives of those companies and U.S. politicians into doing whatever they want (e.g. Christine Fang).

The subsequent ideological compromise of the West is the result of the CCP getting its tendrils into Western leadership (https://nypost.com/2020/12/13/us-companies-riddled-with-memb...) and culture. This video of John Cena apologizing for recogizing Taiwan as a country in Mandrin should have been a deeply frightening wake up call: https://www.youtube.com/watch?v=zre2p7mg64g&ab_channel=China....
If only we had redistributed Bezos’ wealth when he reached billionairehood. Amazon would still be just an online bookstore.
Dataset ethics review is becoming nore common. I'll be surprised if this "use corporate data without irb input" model survives the decade.

Corps can put whatever they want in tos, and researchers are free to use data from those corps. But federal agencies should refuse to fund those pis and their institutions.
At work we use Puppet and I have to say that although the DSL is much more expressive and nicer to use than YAML, Puppet's tooling sucks in comparison. There isn't really any way to test your Puppet code that I know of, you just have to apply it and check if it all looks good. Puppet doesn't have a set of good practices established either. Different companies use completely different repository structures, compiler settings, linter settings. Modules for managing common software like Docker are low quality and riddled with issues.

Ansible and Puppet claim to be declarative but it's a lie. Configuration management really needs a rethink. I know Nix exists but that has a huge barrier to entry and companies don't want to use something that isn't battle tested. In my view, the ideal config management tool would be fast, testable, and provably idempotent. It would also be as far away as possible from the Python/Ruby swamp that Ansible and Puppet are stuck in.
They are also selecting for 90% drops in equity (why 90%? what were the results when different numbers were selected?).

In these cases, someone has lost most of their net worth and so they may find the rest of their assets are being liquidated, and they need to empty their account to discharge other liabilities. The reason why market downturns are correlated with panic selling is because market downturns are correlated with other things. The reason market cycles happen is largely because of the changing value that people place on cash...in 2008, lots of people needed cash.

And 90% is a very large number, the max drawdown on the S&P in crashes is usually less than half this number...so I am not quite sure why they are looking at this number when it doesn't really reflect a realistic scenario for most people. Losing 90% is inherently extreme, I worked in finance, I am relatively good at investing...if I lost 90% of my money, I would time myself out. I know of no investment business in the world that would keep someone on after a 90% loss...zero. Some multi-strategy firms will fire you if you lose 5%.

Additionally, as you say, people who have money tend to protect their downside. If you have $1m, and you lose 90%...you still have $100k. This tends to be particularly misleading when you look at a sample in which the market has always gone up and recovered...because it always looks like there was an opportunity cost from exiting (and if there wasn't, these papers don't get written). The paper is inferring reason to a decision that they don't really know the reason of. I 100% agree that "freaking out" can be (and often is) a rational choice.

Ask someone who "freaked out" in 1991 when Japan tanked. I actually know a firm that didn't "freak out", they were strong investors...firm nearly died, they lost pretty much all their client's money, and the Japan business effectively folded...but yes, those idiots who "freaked out"...rakakakaka.
The West and Americans (in my experience) take for granted that civil rights, free speech, democracy, and other values automatically create better outcomes than authoritarianism. This is how it was taught to me, and it seems baked into the culture.

Unfortunately, the reality is that while (in my opinion) liberal values create better outcomes, it takes care and concerted effort to get the benefits. A democracy isn't automatically better than an authoritarian regime; that assumes that the democracy is effective and that the authoritarians are not.

The CCP is clearly effective. They are able to nail jello to the wall and have it stick. The US Congress is clearly not effective. Chinese people got to go to movie theaters and eat at restaurants and dance at raves for most of 2020 and 2021; I, as an American, could not. The CCP delivered for their people in a way that the US did not.

The United States is not particularly effective at national security (2021-01-06), foreign engagements (Afghanistan and Iraq, last 20 years), or social mobility (https://en.wikipedia.org/wiki/Socioeconomic_mobility_in_the_...). The media ecosystem is a mess (due to purposeful de-regulation), voting rates are abysmal, education is poor by rich world standards. Democracy doesn't work well when the populace is not sufficiently educated, accurately informed, and empowered by a political system (see the Senate's strong R electoral advantage). We keep choosing leadership who lose at the polls because we haven't invested in modernizing our democracy.

The US and other Western states need to step up and put in the work to prove that their values can deliver for their people better than the authoritarians can.
Somehow I fail to see a line from the civil rights movement to smash-and-grab late capitalism. Diversity happened a long time ago, treating minorities ever-so-slightly more like human beings fails the smell check for the cause of a crumbling distribution of rewards for hard work and innovation.

If I had to point to a single set of policies that I’d call an “own goal” it’s making it difficult for brilliant people to live and work in the West generally and the US in particular. Yeah, get your world-class technical education here and then get the fuck out of my country and into the H1-B maze.

Apparently we’ve got top people on that one.
What do you call the parts of a story? Or: why can’t journalists spell “lead”?
Most of the activity happens in the (public) Elm Slack community, so it's not indexed in search engines and hard to find in StackOverflow, but it's a really effective place to get advice and help with a problem in a more personal way
Yes

> After you authenticate your transaction, the Secure Element provides your Device Account Number and a transaction-specific dynamic security code to the store’s point of sale terminal along with additional information needed to complete the transaction. Again, neither Apple nor your device sends your actual payment card number. Before they approve the payment, your bank, card issuer, or payment network can verify your payment information by checking the dynamic security code to make sure that it’s unique and tied to your device.

> Like with in-store payments, Apple sends your Device Account Number to the app or website along with the transaction-specific dynamic security code. Neither Apple nor your device sends your actual payment card number to the app.

Note that this can be prefaced by 'usually' - some banks, instead of generating a new unique ID for Apple Pay, will use the CC number itself, or will at least augment the device ID with the payment card (I noticed this as receipts showed the last 4 of the card, despite using Apple Pay).

https://support.apple.com/en-us/HT203027
It was a legit question. Not sure why I'm being downvoted.
Disney's "Shang-Chi and the Legend of the Ten Rings" would like to have a word with you. Think they made a Chinese lore film for Americans?
Wonder if SF Bay Area homes might actually meet that target.
Naive question here: why China is able to close its market to foreign companies? Same thing for trade sanctions on Iran which impacted European companies but not China (if I'm not wrong). Seems they don't play by the same rules as anybody else.
It will. Yet, any country has the right to discriminate in any way against someone wishing to enter the country. It's once those people are let in, and given citizenship or PR that they enjoy protections against discrimination.

This would have to be a "moving forward policy". Anyone in the US already enjoys protection against discrimination based on place of their birth or race.

In the future, it could be a condition of entry that people acknowledge they are not allowed to work in certain industries, for the government, or universities etc.
As dylan522p is saying, it depends very heavily on the actual agreement. Which unfortunately isn't public and has historically been very different in each case so we can't even look at similar agreements for guidance.

That being said, it wouldn't be totally out there for a clause in the agreement that doesn't allow export of chips with this IP, and that would probably be enforced as ITO judgements allowing seizing chips and end devices at ingress points. The ITO would essentially treat them as counterfeit if all of those assumptions hold true, similar to how how remanufactured and ghost shift iPhone replacement parts famously get labeled as counterfeit legally.
You are quoting a paper described by the author as "twisted" to make the case against diversity while trying to argue against diversity.

> Putnam denied allegations he was arguing against diversity in society and contended that his paper had been "twisted" to make a case against race-based admissions to universities. He asserted that his "extensive research and experience confirm the substantial benefits of diversity, including racial and ethnic diversity, to our society." [1]

[1] wikipedia
I wonder how many of the people who will be coming to flag you also blame Middle East strife on drawing lines without regard to ethnic territories?
Maybe the most common saying that you'll hear WRT to the markets is buy when there's blood in the streets.

Then why do so few do it? It's because when there's blood in the streets and real fear it's for completely legitimate reasons.

What about sell when others are greedy?

This too is sage advice, except for one problem- when people are greedy nobody wants to sell, because the market is moving to ever higher prices for completely legitimate reasons.

The thing about trying to be contrarian is that true contrarianism isn't just fading what seems like a popular take. Rather, it's fading your own instincts when they reach extremes and telling you to make impulsive decisions, which is one of the most difficult hurdles for humans to overcome. We are incredibly influenced by our environments with major recency bias.

The truth about panics is that it isn't a real panic until everyone is panicking, bulls and bears because the reasons for the panic are completely real. Whether they prove to later be buying opportunities is totally irrelevant. The best traders who can actually not get caught up in the hoopla of a boom or bust are one in a million and still get it wrong more than half the time.
The point is that they will support user wellbeing if it makes them more money. If half of society is saying "don't use Facebook, it's bad for you" that's not ideal from a business perspective. It's why McDonald's offers salad.
What keeps you from giving now? Isn't the poor person there? Aren't your own
warehouses full? Isn't the reward promised? The command is clear: the hungry
person is dying now, the naked person is freezing now, the person in debt is
beaten now-and you want to wait until tomorrow? "I'm not doing any harm," you
say. "I just want to keep what I own, that's all." You own! You are like someone
who sits down in a theater and keeps everyone else away, saying that what is
there for everyone's use is your own...If everyone took only what they
needed and gave the rest to those in need, there would be no such thing as rich
and poor. After all, didn't you come into life naked, and won't you return naked
to the earth?

The bread in your cupboard belongs to the hungry person; the coat hanging unused in
your closet belongs to the person who needs it; the shoes rotting in your closet
belong to the person with no shoes; the money which you put in the bank belongs to
the poor. You do wrong to everyone you could help, but fail to help.

-- Basil, 4th Century

The large rooms of which you are so proud are in fact your shame. They are big
enough to hold crowds--and also big enough to shut out the voices of the
poor...There is your sister or brother, naked, crying! And you stand confused over
the choice of an attractive floor covering.

-- Ambrose, 4th Century
I'd love to request an area (USVI, St. John specifically).

These look great. I love the insights on the tuning process and it's nice to know it isn't just a lazy cropping.
Also, KeePassXC[0] (a password manager) has integrated TOTP, which is very handy.

[0] https://keepassxc.org/
Yeah because the redistribution is not just from the rich downwards. It's from the middle class to the rich. Communism is a trojan horse for the rich to get richer. If it weren't, then the rich people who promote communism, would be the first to donate their wealth, and we wouldn't even need a discussion.
There is still a little bit of a point, as it guarantees the password came out of 1Password and wasn't from somewhere else. If someone screencapped your password out of 1Password, it wouldn't of use unless they could get into your vault somehow.
They could try that, sure, but the "real" Arm would likely sue to stop imports at as many destinations as possible. And they'd probably win those court cases.
Three years ago this happened to us at midnight before the check-in day for an AirBnB in Bucharest. I had to spend a couple of hours in the middle of the night with AirBnB support messaging back and forth. But AirBnB handled it near perfectly for us, with an decent accepted place after a couple of hours, full refund, etc. Otherwise it would have really sucked to be on a bus the next day, out of both cell and wifi range.

The fact that they f'd this up in the US is... not good.

Well everything rots in the end. Thank you google for that pixel that I paid for on a CC that went 1:1 to AirBnB credit, we had a lot of fun burning through that.

Other than that we've had exactly one bummer AirBnB, in Queretaro MX. Our place on the penultimate floor of a very US looking apartment complex apparently was located under some sort of factory on the top floor, and produced vibrations all night long that I kid you not caused eg various phones to walk along whatever surface they were placed on.
It's Chinese, though, not Japanese, and the Japanese meanings borrowed in the Tang dynasty are no longer modern Chinese. (Common words like "to eat" is 食 in Japanese, but in Chinese now that means "foodstuff" and is a noun, not a verb. The common Chinese word for to eat is 吃. There are a lot of these.)

谋 appears to mean more like "plan" as a neutral word. Obviously you could have hidden plans and devious plans as well as ambitious plans, public plans, wise plans, and helpful plans. I don't think anyone would name their company "Cheatful Scheme", even if that was actually their intention. And 谋 is modified by 安 (peace, safety, good health). So it'd be more like "Wholesome-safe plan".
Young single childfree women are freaking out less because they have more lucrative choices than advertised?

Someone should study that!
One of the problems with this is that there will always be trade offs. It’s hard to imagine a database understanding the appropriate compromise between read and write speeds for your specific application, for example.
Is this the largest bug bounty in history? (Not counting black hat / gray area "bounties")
It’s a workstation after all. You run workstationish stuff.
I agree with what you're saying (except I have heard of university data breaches because I follow that sort of thing), but also the information in this study is extremely personal and sensitive.

While I'm sure there was a lot of attention on data security behind the scenes it is a little unnerving to hear someone say, when you aren't expecting it, "we looked at everyone's brokerage history and here's when they felt fear that they were about to lose everything."

I do wish there was a way to at least reduce the surprise factor. Perhaps put a note about the data collection protocol in the abstract on the article page.
Discourse Announces $20m Series A Investment
Yeah but Harvey was mostly rain. If we had a category 5 go up the ship channel the entire US would be impacted. So much oil, fuel, etc goes through here.
It’s a almost as bad as it could be. The only thing that could make this worse is of the hurricane slowed down over the gulf and stayed there for a couple days.
Have you looked at the https://www.sqlite.org/pragma.html#pragma_cache_size

I think per default it's only 2MiB, increasing it might help.
Probably won't beat the other contenders but sqlite has defaults for being a good citizen.
What timing? There are plenty of market timing strategies that will beat holding (the market is more volatile than underlying values so this is a natural certainty)...but it depends what you mean by timing.

Most of the conventional things that people understand about holding are wrong though...unsurprisingly, given that most of these conventions are produced by people trying to sell you something (I know this, because I worked in financial services, and used some of these conventions to sell things...it makes sense because individuals are stupid enough to do themselves real harm by trying to be clever...but this does not mean that being clever doesn't work, it just means you are stupid).
> simulating SQL via your languages nestable data structures

I've gone down this rabbit hole... you've described the in-house query engine I work with.

Instead of sql, queries are nested json representing a dumbest-possible sql parse tree. It's only a subset of sql features, but it provides, as you point out, composability. By having the query as a data struct, all sorts of manipulations become possible... toggle fields for access control; recovery from dropped or renamed columns (schema has a changelog); auto-join related tables as required; etc.

It's magic when it works but it suffers from the drawbacks noted elsewhere in the thread about traditional ORMS... onboarding new devs, debugging when something goes wrong.

Adding new features to the dsl is a pain because the surface area is not just _the query_ but _all the queries it might form_ when composed with other queries in the system O_o
Even so, I think Britain refusing to aid a Commonwealth member under credible foreign military threat would be pretty surprising. More so with Australia and New Zealand especially, since they share a head of state. Besides, ANZUS and Five Power exist to pull the US and Britain, respectively, into a conflict that threatens those states.
Wisconsin Card Sorting Test
> why China is able to close its market to foreign companies?

Because we assumed that prosperity would lead to liberal democracy. That underwrote complacency while profit motivations took root.
Not sure I buy that. The articles could be framed as "We need to pass legislation to prevent behavior like X, which for example Amazon participates in"

But that just doesn't generate the clicks like "Amazon is evil" does.
Download and Install Qmobile USB Driver
Absolutely there are places where it's possible. Just pick a small town in literally any state.
Our local 405 FWY section was expanded by one lane thanks to the governmental stimulus spending after 2008. It took years and in some sections it ruined the view since they had to chop thru a few hillsides to expand the freeway. It took years and we had to deal with the constant closures and extra traffic. It seemed like a great project and we were hoping the extra lane would reduce traffic.
Now, many years later after they finished, to me it's still the same constant congestion. We still need to go thru heavy traffic on the way to work and back. I suspect that if you make a detailed study you would find a difference but as a practical matter, traffic did not change. The billions of dollars the construction cost would have been better used to expand the public transportation system.I think this article has a going point.
I think the parent was referring to making investments into Chinese businesses, not just manufacturing their products or selling there.
A Python Implementation of the Apollo Entry Guidance Algorithm
> I don't want to be lied to in any form by my government.

Completely understandable, and, I agree.

> I believe they can always govern by telling the truth, and if they did so they would find themselves commanding more respect from the people.

Regarding "can always govern by telling the truth," that's demonstrably untrue. For instance, there is such a thing as classified information for a reason (that reason ostensibly being national security). Yes, this does get abused at times, but that's not an argument that the government should not classify any information. Given your reference to Kant, I don't necessarily expect you to find this persuasive, but, I wager many reasonable people would.

> ...Kant's categorical imperative....

I am actually familiar, but I reject the logic of it. It's... well... too categorical. I can't accept a principle that forbids me to take an action that may save a life. For example, I would be prohibited from hiding someone in my home who's being pursued by people who want to kill them, if the pursuers asked me directly where that person was.

> If we stop treating each other as humans with rights, needs and desires, we will find ourselves in a very bad place - history has shown us that.

I agree with this, but I reject the idea that not following the categorical imperative at all times necessarily deprives anyone of any right.