skysight-inc/HackerNews huggingface dataset:
There is a reason it was originally called (SEQUEL)

Structured __English__ Query Language

see the original paper at

https://web.archive.org/web/20070926212100/http://www.almaden.ibm.com/cs/people/chamberlin/sequel-1974.pdf
The USA has been the sole military superpower for 30 years now, with more power than the rest of the world combined. If they wanted global dominance, they'd already have it long ago.
On the Shores of Cape Cod, Where the Oyster Is Their World
'The next Hong Kong': Taiwan's foreign minister sounds warning over China
Not for the reason you're implying, actually for the opposite reason. I'm from the days of yore, just before ORMs became popular and it basically replaced a lot of boilerplate code, but it wasn't the SQL that was the bulk of it.

It was mainly to save time in writing code to map columns to object properties really, the sql statements themselves were trivial even if you weren't lazy and just used select *.

Also, here's a now mainly historical pain most devs never encounter any more: Before ORMs and the various migrators, your object properties might not have the same name as your SQL columns. Yes, it was dumb when you did it, yes, it caused loads of bugs, yes, it actually happened quite a lot.
So what if they are "already" labeled as made in China? The article is specifically about removing "Hong Kong" (HK, SAR HK, whatever) from labels of HK-made goods imported to the US.

We'll see how the "PR spin" impacts buyers of products that are never sourced from Russia, China and such countries.
> The Amendments guarantee rights that you already have, countries can't give you rights.

This statement confused me, probably because I'm not from the US and am missing some cultural dogma/context. But the way I think about it, "rights" are not encoded in the laws of physics. They are social constructs. Therefore different societies can come up with a different and even conflicting set of "rights".
ElectroCRUD v2 – 2.7.1 with lot of new features
List of Geometers
Since it's so easy, I think you won't have a problem with any of the questions on this page:
https://www.toptal.com/sql/interview-questions
Rhetoric is empty by definition, its purpose is to persuade.
Also you’re speaking from a global point of view by addressing “the US” and “China” versus “our country” and “their country” so the idea that there exists “values and morals” in that context is also obviously incorrect as each culture has its own set. Even within a given culture there exists different sets. I’d go as far as to say that with the dissolution of Christianity as a cohesive unifying religion within the US values and morality no longer exist as such. Each person’s beliefs change almost daily given how fast information and ideas spread on the internet and social networks. Appeals to morality are essentially dead in my opinion
This is only true if either company ever risk running out of (good) drivers. As I understand it currently there are more workers than jobs, so if a driver decides to cut ties with one of the oligopsies they are unable to get the same amount of work from the competitor.

So: "moving to a competitor definitely applies pressure" -> true; "keep both companies in check" -> false
> Having 2FA backups in the same password manager as your password would be pretty much the same as not having 2FA enabled, so why bother?

Anything but. Leaks through password manager are sure possible, but only a small risk compared to other password failures.

While I don't store 2FA codes in the manager, I'd consider that or even unencrypted files in your home folder an ok compromise between convenience additional security. Not super safe, but still on a wholly different level than no 2FA at all.
Long-lived trees may have found the cellular secret to theoretical immortality
A lot of it is going into prop-ing up corporate debt. I remember that they even bought junk rated bonds.
Emacs is just fetching up to others and reducing demand for manpower with LSP. It is not inovating itself, nor moving toward a better future. The core-architecture remains the same, the old problems remain the same. Manpower is hardly growing and marketshare seems to be stable or even shrinking. Competition on the other side is outpacing Emacs by leaps and bounds.

> The days of IDEs are numbered.

Nope, IDEs will never die, they just change again. Editors are becoming IDEs now, merging both to become more than before.
I assure you, all american entrepreneurs are deeply bothered by this.

Uber lost in China mainly because of this.
Differential Interference Contrast Microscopy [video]
Does anyone else feel like we are all trying to be high growth startups?

I understand that we all want to build products which others use and pay for but why not also be building things for yourself?

Is it really such a bad thing to spend some time over-optimizing pieces of a system for your own pleasure and possibly learning things along the way?
Like entropy, wouldn’t this lead to greater disparity in the short term but uniformness in the long run?
I accidentally built a nudity/porn platform
> With SQL you can enforce it within the datastore. And if some requirement changes, you can instantly enforce it. Eg.: A new foreign key constraint.

Which is to say that you have little control over deployment. Adding a new foreign key constraint might block queries for an indeterminate amount of time while a new index is built, but you have no way to introspect or predict that at the SQL level (if you're lucky there might be a specific way to find out via the internals of your particular datastore implementation). PHP fans used to tout being able to just edit the code on the production server as an advantage, but most of us recognise it as the opposite.

> Also: It is centrally managed, so you don't need to look all over the source code to find the constraints and don't need duplicates either, if you can, for example,change the data at multiple points.

If your data is well architected so that you only have a single representation of each piece of data, sure. Equally if your application is well architected you can have a single API where any given thing happens.
> If we settled for good enough in all cases we wouldn’t have Go or Rust

funnily enough, golang is a regression in practically every front compared to established ecosystems like Java and C#.
Depends who owns the trademarks now. They would be an asset that whoever managed the bankruptcy would be able to sell on. That person may well want to use them to make some money back.
Give Students User Freedom
Third breakthrough demonstrates photosynthetic hacks can boost yield
This would be so interesting if TikTok wins. I want to see Donald go mad. Let's just hope he does press the big red button because of it...
The State of Julia 2020
Is MAD not a thing anymore?
Let's step back for a second: Amazon wants to know what you said to sell you x brand of corn flakes or toothpaste.

What does China want to know from millions of Americans that work in engineering, military, universities, politics? See the difference. Like China cares that its company was fined by FTC for $25 million for not respecting privacy
Compatibility in a Sandboxed World
I was around during the Enschede, Netherlands fireworks factory explosion [0], just outside the radius where all glass shattered. Saw the glass ripple effect along a line of appartment buildings with full-height windows. A really astounding sight I'll never forget. With the amount of curvature caused by the shockwave it seemed these windows must surely break. But they did not.

[0] https://en.wikipedia.org/wiki/Enschede_fireworks_disaster
Why does Slack not detect if the user is away?
Slack does not detect if the user is away of the computer is it intentional?
I normally do this in the lead-up to a new release, but downgrade aftwerwards.

Often, there'll be big changes on the master branch after a release, so it tends to be a little less stable (and I normally just need Emacs to work, so not interested).
"Plans for global dominance" can mean more than just achieving it. One can also plan to maintain it or grow it. Perhaps it's just semantics but an important distinction.

In this particular case China's plan to achieve global dominance is in stark opposition to the US's plan to maintain global dominance.
> It's very difficult to guarantee that a business constraint expressed in your client app is actually enforced - there can be different versions of your app applying the constraint differently, there can be multiple apps accessing the datastore, there could be manual interventions in various ways to the datastore, the app could have code paths that may cause data insertion or alterations without running that verification in certain conditions, etc; so for all intents and purposes you can't really rely on that constraint.

If you have business logic in your datastore then that puts you in much the same position though. If you have a trigger you might have data written before it was introduced, or queries that ran with it disabled. If you're gradually rolling out a new version then you might have some data that follows a constraint and some that doesn't. And so on.
To be perfectly honest, that was my very first reaction when I first watched the video: it looked like the fuming aftermath of Something Really Bad, and then BOOM! Something Really Bad unfolded on-screen. I figured that it must’ve been some kind of aerosol/powder combustion triggered by the fireworks’ conflagration, but then more learned analyses of cloud hue and knowledge of what was actually stored in situ (correctly) overrode my initial reaction and the fertilizer was identified as the main culprit.
Multi sql targets means it’s even more of an advantage to compile
I second this! Sabah, Serawak and just about the entirety of MY is on my travel itinerary post-covid. I did not appreciate the country nearly enough when I lived there a few years ago.
One must always consider opportunity cost. Adding password reset functionality might take time away from building features that solve true end user problems. People will wait for a password reset, they won't wait if you cannot deliver true value to them.
Huh?

GGP: Has anyone published the evidence of Huawei being an "arm of the PRC surveillance state"?

GP: My father used to work for molex, one of his biggest complaints were fixing the molds after they were sent to Chinese factories. They would try to deconstruct them and couldn’t put them back together

Taking apart competitors' products is standard & ethically accepted practice virtually everywhere, there are lots of published anecdotes. Eg the one in Soul of a New Machine, where the team at Data General analyze a VAX. And there's no relevance to the surveillance state.
Optimal for space usage without considering hardware details, like most CS algo analysis?
Well shit. It was a fun few weeks in freedom. Let's see if we do better than the Aussies.
Show HN: New Website Builder for Free
Olitt is a website builder helping you create free websites in under 10 minutes. You do not need any coding knowledge to build pages, thanks to drag-and-drop feature coupled with hundreds of free website templates.
I think there is a 4th category: This is not an obviously blocking issue right now, but it creates enough mental load that it prevents my work from being rewarding.
Just curious - how do you know it's lifted from Wikipedia vs. the other way around? It's quite hard to trace the sources.

E.g. did a quick search for Jerry Seinfeld, CNW is a lot more robust than Wikipedia (or the inc. magazine article it cites)
> The Mongoles have not redrawn borders along a line on a map the way British and French have, creating the mess we now have in the Middle East.

Back then there was not really the same concept of boarders. But you can be 100% sure that the Mongols picked sides in many local conflicts and simply layed down the law on things like grazing rights and many others things.

> I can't make a complete list of criteria that defines colonialism, but to claim that it was no different than other conquests is to betray complete historical illiteracy.

It really isn't. Sure colonialism from 1800 is not the same as 1200 century mongol conquest. But to draw a line between colonialism and all other types of conquest in human history is actually historically questionable.

Comparing colonialism to other conquests at the same time is very apt. Empires impose institutions and take sides in local conflicts, enforcing new laws making deals with neighbours not to the advantage of locals and so on.

Unless you can lay out a set of clear differences between colonialism and all other froms of one society taking over another, I see no reason to treat collonialism as seperate.

> The entire country India was ruled by a private company

And in other cases, for exmaple the mongol one specific branch of the family was put in command of a region and those families often engadged in trade of the resources from their part of the empire. There are lots and lots of ways empires manage their 'colonies', a quasi private 'company' is certaintly not typical but its also not ahistorical as far as I can see.
You needed to upgrade a bunch of variables to account for the absurd amount of json LSP modes spit out, and use the C-based json parser that's available in 27 (I've been running from the source branch for a few months now) and I personally find lsp-mode super, super good.

It's like 100x better than TAGS files (because I don't have to generate them) and has made my navigation of a new codebase much, much more smooth and effective.
Parent is talking about using "emacsclient". Basically you start Emacs in daemon mode (e.g. add "(server-start)" at end of config), and you never kill it. You just pay slow startup cost once, any subsequent client invocation after that is instantaneous.
> Let's just hope he does press the big red button because of it...

I hope you forgot a "not" somewhere in this sentence...?
CA is wrong to outlaw voluntary working relationships between two parties.

Indentured Servitude is a voluntary working relationship between two parties. Is it wrong that it's illegal in CA?
Another good way to extend the life of weights that are too light: Increase Reps, Increase Sets, Decrease Rest, focus on pace while lifting (4 seconds down, 2 seconds up), and unilateral exercises (1-leg-squats). Not a substitute for everything, but hopefully can help bridge the gap for a little longer.
For triggers, you can run a procedure that executes it for all past data. Or write a procedure that updates the data to a valid state.

When gradually rolling out, you can have adjusted stored procedures that deal with the different versions, and turn off the old one when it is no longer in use.

So, I fail to see the problems you mentioned.
Amnesty international has a troubled history.
https://www.mintpressnews.com/amnesty-international-troublin...

Luis Kutner was a co-founder of Amnesty international, and Kutner would go on to form the “Friends of the FBI” group, an organization “formed to combat criticism of the Federal Bureau of Investigations,” according to the New York Times, after its covert campaign to disrupt leftists movements — COINTELPRO — was revealed. He also went on to operate in a number of theaters that saw heavy involvement from the CIA — including work Kutner did to undermine Congolese Prime Minister and staunch anti-imperialist Patrice Lumumba — and represented the Dalai Lama, who was provided $1.7 million a year by the CIA in the 1960s.

If you want more recent events:
https://en.wikipedia.org/wiki/Nayirah_testimony

They were the ones that "corroborated" her testimony.

If it weren't so tragic, it would almost be comical, its like they have manufactured consent before, and know what they are doing...
HN's comment monster ate your asterisks. :-(

It should be:

char **env
Russia clears virus vaccine despite scientific skepticism
Jeez. I just write JavaScript all day, I dunno how you guys do this stuff. It sounds very complicated.
I'm a hobbyist compiler developer who does dev on Atom, debug in repl.it and prototype in Coffescript to generate LLVM IR. The world is big!
Science can inform policy, but it never mandates policy decisions
I don´t know how is it in all of the world, but in many countries/cities, the problem with Taxi drivers is that there is no control, they treat you like shit, there is no one else to complain, they take you to the longest route, many have their "clocks" (that is what we call the machine they use to charge you the fare) fixed so that they charge more, and there are illegal taxis that steal from you (as in real robbery). Uber is good because you can complain to Uber, you get refunds, if drivers get bad ratings they are no longer part of Uber, and in general, it is safer than taxis. I was some days ago in another country. I didn't know any Taxi phone number, but I had my uber app, so I just requested an uberx, and it came. Problem solved.
To stay in the metaphor, what if a group of people discovered how to create negative pressure? This means they know how to suck money out of a community, probably to enrich themselves.
No, he didn't. That is entirely and absolutely FALSE, and you are feeding this false narrative by parroting this nonsense.

He offered to go back to Sweden to face the charges on the proviso that he would not be expedited from Sweden to the USA. This was not guaranteed.

Julian Assange is a political prisoner. All of the bogus sex crime charges against him have been dropped, and were never intended to be anything but a lever to get him to go back to Sweden so he could be extrajudicially rendered back to the USA - since Sweden and the USA have a track record of such criminal behaviour, Julian rightfully required a guarantee that the Swedish government could not provide.

And as a result Julian Assange is currently being psychologically tortured in Belmarsh - and has yet to face any of the charges against him. Nobody should think that Assanges' case upholds the highest values of Western legal justice, because it does not.

What is being done to Julian is tantamount to the same sort of treatment one would expect to happen to dissidents in dictatorships. Stop spreading the nonsense, and learn the facts about his case - it is chilling to the core.
Amen. Thanks for writing this. Looks like a clean interface, will try it out.

Was thinking about the unnecessary RecylerView boilerplate code a few days ago when writing a couple of them.
The assumption is that the US Marshal Services is reasonably trustworthy with the items they sell.
Russia has registered the world’s first coronavirus vaccine
And with good practices (mainly a decent type system that lets you distinguish between checked and unchecked values) you'll have no problems with constraints in the application layer either.
Modern diesel injectors:

30,000 to 40,000 PSI

https://www.buyautoparts.com/blog/4-common-diesel-fuel-injec...
If you're a transplant working in tech in SF you're pretty close to elite. The background growing up might not fit, but the lifestyle in SF does.
I'm not doing C every day but i have rarely any issues with it.

Do we really need to do better than C? I don't think so and i also don't think that the chosen new syntax is better.

At the end of the day, most critical is not the language but understanding how it works to optimize assembly etc. If you are only able to write simple C because you are not good in C/algorithms, you will not optimize your algorithms independently from the language.

If you are good in C/algorithms, you (or at least i) do not care about syntax details; You just look it up, and get acquainted to your specific underlying microarchitecture.
Emacs was never intended as "just a text editor" and it shouldn't strive to be one. It was the first IDE and it is infinitely better than almost any other IDE in terms of customizability. It's main drawback was a lack of very good support for non-LISP languages - TAGS are incredibly simplistic and only let you do basic code navigation. LSP solves that by leveraging the huge amounts of development effort put into VSCode's language support. This makes Emacs, which has a superior editing mode (with evil-mode), and superior customization options, one of the best IDEs available. The only other IDE I use now is Jetbrains for JVM support (because there is no good language server, unfortunately), but I don't enjoy it - you can barely customize it and the text editor sucks compared to what I can do in Emacs.
With the experience of the Euro and the vastly different countries under different legislation, I think this is far too naive.

The common currency was a bad decision in my opinion. Sure, now legislation is getting "normalized" (I love the jargon), so that nobody is happy with it anymore. I don't think I would want that for anybody. It is like a marriage that doesn't really work.

Complete detachment of capital that was created in one place is not a great idea. That doesn't mean other places cannot grow and it doesn't mean there is no exchange.
Compared to the actual problem, public health and the economy, this request looks extremely childish
That only worked when China was a small country economically. Once China passes the U.S. and becomes the #1 economic superpower, none of this matters. These small fish "allies" are not really important.

> I'm amazed at the short-term thinking behind these moves - and the fact that HN, of all places, is cheering it

Everything you said here we already know. What you don't realize is the world is going through an invisible war right now at a scale of world war 3. These first world country people have never lived a difficult life so they just think everything will be all right just because it's been all right through their entire life. When China gains its dominance by bullying the rest of the world and the rest of the world just trying to "take the high road", they will realize there's no longer anything they can do about the situation because the Chinese economy has become too strong. This is why countries like India are taking the same route already (They were the ones who banned TikTok first).

There is no permanent "ally" in the world politics. If you naively think "taking the high road" will win you allies even if it means losing your power, you should study history and learn to see long term.
Anki Vector Robot with GPT-3
There's not a lot of margin selling a consumer product with its support issues for a couple of dollars a month so I don't expect a pretty web site. I've been using and happy with VoIP.ms for the last decade.
More modern doesn't necessarily mean better. That's a fallacy.

For instance, it's possible that a currency based on long chains of debt is prone to massive blow-ups. That's modern day fiat currency. In contrast, cryptocurrencies like Bitcoin are not based on debt.

> Come up with a currency anyone can create and there you have a real disruption.

If I've understood you correctly, something like that does exist. See Ethereum and its ERC-20 tokens.