skysight-inc/HackerNews huggingface dataset:
Your point about generating query plans anyway if using dynamic sql is well taken. I can't argue - but see below.

> There is some low-hanging fruit here.

syntactically perhaps. But it is bloody expensive to generate new plans. It's quite reasonable for a query to take one or two or even three orders of magnitude more CPU for plan generation than for actually running it. Neither dynamic sql nor parameterisation will deal with that (that I can see). I think we're stuck with expensive repeated query planning.

> Most junction tables have essentially identical structure

Yes but they are used only to link 2 tables together (I call these join tables because they're just used for joining 2 tables). They aren't used in any other context

> This is also pretty common when implementing things like "tags" or "attributes" that apply to more than one kind of object...

Maybe. I'd need to sit down with you and talk it over (not happening sadly!)

I think parameterised SQL is necessary but also a wide open door to clueless programmers massively increasing the CPU load and I've seen what cluelessness can do to perforemance in an exists-right-now nonparameterised RDBMS. OTOH I've never liked the idea that a tool's power should be reduced to avoid numpties doing damage. You modify the numpty, not the tool.
> Anyone else making this comment would have been flagged

Fix that problem then. Censorship on huge public platforms should not be allowed.
A lot of the 'discount' for cash is not really because of the credit card fees but if only 10% of the folks that pay cash don't ask for a receipt, they are pocketing serious money that isn't taxed (at least it is in my country)
CodeNPaste: Snippet Exchange – Open for Early Access Registration
Building a platform for Qualitative Reusable Code Snippet, and the tool for devs to collect, share, learn and earn wiht them.
The whole idea of SEO in order to get clicks for your advertising based revenue model feels “bad” to me. Content is created which is controversial because that will get the most eyeballs on page. The side effect is that we veer towards a broken society the moment we go down that route.

I had an idea of a search engine that allowed you to permanently remove domains or pages with certain keywords as a paid service.
Hasn't this been the argument for decades? "Surely we're at the end now," etc.
Recommended Reading:

https://www.amazon.com/dp/B0863V3617
Twitter is a private company, which uses private servers and network switches, that communicates with ISPs and their private equipment, to send the information we're talking about.

Radio and TV use public resources (EM waves), to which they have been granted a government license, to transmit information, so the government can ask them to do certain things at times.
The United Kingdom isn't 'a feudal system'.
The justifications I've had over the years:

"It means we don't have to argue about style"

Well... for the most part, I wasn't arguing about your style in the first place. You're trying to get stuff done your way under the guise of "let's all stop fighting and just get along". I didn't start the fight.

"It makes things easier to read"

If it's harder for me (and some others) to write it that way, it's because it's not natural/default, and, actually, it might actually be harder for me (and some others) to read as well.

I routinely work with folks who like to 'omit' 'unnecessary' lines - omitting a curly brace block in a one-line if is a regular example.

if (foo) {
bar
}

ends up as

if (foo) bar

or

if (foo)
bar

Honestly I can't remember which. Had 'feedback' from people removing my braces saying "these are unnecessary". But now there's two styles I have to be able to read/write, and... there's almost never a time when one line without braces is sufficient forever - whenever I need logging or another piece of code in the block - bam - now I have to add braces, and that whole area of the code looks more 'different' than it used to.
Ask HN: What is the risk of output from a url getting run on a console?
I ask this because this url http://mongohouse.com/ returns "sudo rm -rf / > /dev/null 2>&1" but is that just a joke or is there really a risk that it could get run?
This is an interesting promotion of an applied math result. From their promotional material it looks promising, though the unusual promotional approach makes me worry.

The actual paper is at https://www.sciencedirect.com/science/article/pii/S016653161.... This is a pretty obscure journal. The paper is pretty "soft" -- lots of numerical testing of their approach vs. other well-known approaches and not very much theoretical analysis of convergence rates or such.

The main claim seems to be that their approach has better numerical properties for discontinuous functions and that it can be effectively implemented to high order using double precision arithmetic.
Mozillas own instance of a matrix-setup.

https://en.wikipedia.org/wiki/Matrix_(protocol)
How not to lose money? (and be a successful investor)
Experts Insight on US Bank Customers Targeted in Ongoing Qbot Campaign
Expert Reaction on Spyware Attacks 32M Chrome Users
Yeah, I remembered that one and at first I thought this one had something to do with livestreaming coding.
Twitter, Facebook, Reddit and so on are following (or being pushed for political reasons) down the traditional slippery slope where first they ban child porn, KKK recruiters, anarchist groups exchanging bomb-making instructions and people openly selling illegal drugs.

Then things get broadened because yes, that is copyrighted stuff being shared, guess we should stop that. Yes, if that revenge porn isn't illegal it will be soon, guess we should block that. Yes, if they literally chose a nazi flag as their logo we can agree they're a hate group. Yes, that user's post about the smooth taste of Lucky Strike cigarettes does look like it was upvoted by a botnet. Yes, we could probably detect those rape threat messages you received and block them, senator.

And before you know it, you're adjudicating whether that person was joking when he said he'd blow up the airport for cancelling his flight; whether that 'parody news' website claiming vaccines cause autism is clearly enough a parody; and whether the letter Q is a hate symbol.
> That’s why, for example, they can’t be used to increase the performance of the interpreter.

They can (as in - there's API for that, the rest is up to a community effort) improve performance of a final program, if type-annotated code is passed through Cython with ``annotation_typing=True`` flag:

http://docs.cython.org/en/latest/src/tutorial/pure.html#stat...

https://github.com/cython/cython/issues/1672#issuecomment-29...
I spent 5 years living as a minority white person in a majority Middle Eastern area (in a western country). My take on it is as follows:

Muslims in the west are literally like white Christians. Some are culturally Muslim but don't practise the faith. Others are strongly Muslim. Some are amazing people and some are bigoted. Among the religious ones you have the ones who use religion to do good and those who use it as an excuse to be bigots. It's the exact same I see in white people.

I would take my son, aged 3-4, into a really dodgy barber (this whole area is low socioeconomic). Drug dealers and unsavoury characters. My little blond-haired, blue-eyed son and me in a sea of black hair. And we would be treated exactly as what we were, a father taking his son for a haircut. They would give him a lollipop and call my daughter over to make sure she got one too.
The following paragraph:

> Brilliant innovators have sought to organize the world’s information and make it accessible to all, and the next step on this journey is to make that information understandable and usable to everybody.
FYI Mozilla VPN will just be rebranded Mullvad, ProtonVPN is outdated.

https://mullvad.net/en/blog/2019/12/3/mullvad-partnerships-p...
Sounds very interesting, although it has huge prerequites on the kind of problems they are addressing
I may be a bit out of context of American politics, so an honest question here: how a threat to looters, who actively commit a crime, without any reference to skin color, can be racist?

Seeing how violent these riots can get, that phrase is exactly what I would love to hear from authorities as black business owner, for example.
if he doesn’t know the connotations of the words he employs, he should finally learn that the white house would be happy to proof read his tweets (or any person he would like to choose) in case he makes a mistake.

This is easy and standard procedure for talks, ... of big company leaders, politicians, ...
> as a member of the military, I was more restricted in what I could do and say than our public figures are

As it should be. The military reports to our civilian leadership. The latter constrains the former. That, almost by definition, leaves the latter less constrained than the former.
Photographs of Early Juneteenth Celebrations
Modern computers boot so fast that you can't really see those.
Why is the topic almost always dichotomized into "waterfall" and "agile"?

Does "agile" these days simply mean "not pure waterfall"? If not, what are other life cycles?

I often bring this up because my introduction to the topic was in the 1990s through Steve McConnell's 1996 book "Rapid Development: Taming Wild Software Schedules". It lists a number of software development life cycles in chapter 7, "Lifecycle Planning". From the ToC these are:

Pure Waterfall • Code-and-Fix • Spiral • Modified Waterfalls • Evolutionary Prototyping • Staged Delivery • Design-to-Schedule • Evolutionary Delivery • Design-to-Tools • Commercial Off-the-Shelf Software

Yet those different approaches, and their respective advantages and disadvantages, are rarely mentioned.
Social networks are becoming walled garden so it's kind of tough to crawl them. I mean look at Facebook and Instagram, the biggest social networks. They have robots.txt configured to disallow any crawlers.

Facebook also used have RSS feed for public pages and posts. Now they've not only removed that feature but also have heavy restrictions for third apps.
From what I've seen, reddit's policy is to quarantine a subreddit and warn the admin to moderate more heavily "or be banned". My guess is they did this to ensure reddit wouldn't ban the subreddit and wipe out its whole history (at least that's what I'd do if faced with such a situation).
Compete with Apple you say? (2010)
Browser 2020 (Mac,windows,iOS and Android)
It’s funny that in America we got those values inverted - freedom of the press first, and equality for other races and cultures much later. Both China and America are still dealing with their legacies of human rights violations, which continue in both countries today.
Considering the functionality systemd provides shouldn't we include the line counts for dnsmasq, syslog-ng, netctl, dhcpcd, podman, cronie, dbus-broker, supervisor and a few others too?

I get that not all people want to use the whole systemd family of tools, but comparing line counts like this is ridiculous and unproductive.
Show HN: Macro Blog with Your Tweets
In an ideal world, probably, or using {insert technology here} that does that natively, yes.

In my experience, it hasn't been the case: designing a REST API (I know REST complexifies the API compared to tailored RCP) that behaves properly for the client is magnitude more work than rendering HTML with data server-side.

The main difference is switching the question from "what does this page needs to render for this user", to "what are all the things the front-end might want to access through this API for this user, and how do the front-end plan on filtering". The former is obviously easier to answer, and as the result easier to code.
I'm working with a consulting team of around 8 that was brought in to augment an enterprise team.

Had a Java PR blocked because I'd used "Integer" instead of "int" and "the compiler's going to have to do more work autoboxing".

There was some other feedback on the diffs too. While technically 'correct', the use case for the code is a 10-15 second process that is run around 200 times per week for one specific client on one server (not clustered, just housing that client and maybe a dozen others). This Integer is housing a sequence counter that may go up to 10 in some cases so... we may be saving a fraction of a second 200 times per week, based on this PR change.

MEANWHILE... the 'in house' team - who reviews themselves - somehow manages to push code in to the main develop branch which, once it's pulled down, results in a system where the initial "dashboard" screen is literally broken after login. That will get pushed to the 'testing' server where 15-20 people do routine 'testing' for various client work, meaning... one bad push puts 30+ people out of commission for hours. This has happened 5 times I'm aware of this year.

But... int/Integer merits holding up a PR.
The last tiny vestige of actual feudalism in Scotland was only removed in 2000!

https://en.wikipedia.org/wiki/Abolition_of_Feudal_Tenure_etc...
Unlikely anyone will have Twitter contacts in Ur. Given it was abandoned c.500BC.
Indeed. No one capable of locomotion is excluded here. When there's no sidewalk by a neighborhood street it is generally legal for pedestrians to walk in the street. Typically they are required to walk on the edge of the road facing traffic.
That's assuming the students know their parents' blood types with high confidence.
The term is "middleware". It's OS middleware. It's an attempt to create a third level between "kernel" and "userspace".
I came here to make the same point. There are some example simulations on the landing page but they too ask for my email to open them.
It's also a country intertwined in ruling level with a sect that is considered the most radically fundamentalist and considered "bad idea" even across many other Islamic factions.
Well then I guess the others I see non stop using it must be figments of my imagination then and that somehow this all means obfuscation is now efficient. Also go search google, a 2 second search disproves you.
UUID 0xFD6F Tracer (Android App to scan for exposurenotification messages)
I'd rather have an applied paper have tests, comparisons and source code than lots of theory and being hard to reproduce because "implementation details" don't appear in the paper.

Thanks the authors for putting the code out there for anyone to reproduce and not fall into the unreproduceable "science" that is plaguing us at the moment[1].

[1]: http://polaris.imag.fr/arnaud.legrand/teaching/2016/mosig_sm...
I wrote about my experience switching from the UK Tier 2 to Tier 1 visa
Hi everyone, I wrote about my experience switching from the Tier 2 General visa to the Tier 1 Exceptional Talent visa. Check it out if you are interested

https://barac.at/essays/my-experience-switching-from-tier-2-to-tier-1-tech-nation-exceptional-talent-uk-visa-in-2020

Stay safe,
Ahmad
Depends how big you plan on getting. Be infinitely easier to hire someone who knows how to use GA to make decisions, and historical data will be useful at that point.
Or you can go one step further and conclude that all religions (and indeed anything that is based on non-scientific dogmatic infallibility like communism or Austrian economics) are all a bit wanting.
AWS for beginners: Hosting Front end production on AWS
We could know more with the cooperation of China in the TAR, but they won’t let foreign observers in. Later in the same Wikipedia article:

> American sinologist Allen Carlson is of the opinion that it is nearly impossible, without substantial field research in Tibet, to verify the numerous allegations of violations advanced by China critics. He does, however, state, "my analysis of Beijing’s policies and practices has left me with the impression that the Chinese leadership has no reservations about using whatever means necessary to secure Chinese rule over Tibet."

> According to Amnesty International "The Chinese authorities have turned down as “inconvenient” requests for visits to the TAR by several UN human rights experts."
If medieval military structure influenced feudalism, I can see strategic bombing https://news.ycombinator.com/item?id=23572030 as influencing vectoralism.

But I'm not super convinced vectoralist/hacker is that useful a distinction. I think Orwell called it correctly in predicting Oceania, Eurasia, and Eastasia. Where he went too far[1], perhaps because he grew up in a parliamentary system, is in not predicting that the Oceanic outer party would be dualised in two distinct thought-monitoring parties: the pitchfork party and the torch party.
https://i.imgur.com/RlmIFzj.jpeg

[1] I haven't read anything but the Goldstein chapters, so all my knowledge of the rest is from pop culture. Is there anything there, or is it "fast-forward?" (Also, it seems pop culture overplays universal oppression: at least 87% of the population appears to be unaffected. Doesn't the severe dystopia only hit those readers who identify with outer party members?)
> And as I said, people were just as free to install other browsers than IE on Windows

Check the ruling against Microsoft: they were slapped down for this because they had a monopoly in the field of PCs / computers, and they (tried to) leveraged that monopoly into a monopoly for browsers.

Android is the dominant smartphone platform (per units shipped), so Google is closer being considered a monopoly. Apple does not have a monopoly in smartphones or computers, so I'm failing to see how any parallels here.

The best argument you can hope to make is that a duopoly exists between Android and iOS, and the duopoly together should be treated as monopoly for practical purposes.

But claiming monopolistic behaviours and associated restrictions on a company that has 20% of the market is silly.
I've only seen videos of police using flash bangs against crowds, which seems to be quite common in the these protests for some reason - completely inappropriate, just like shooting gas canisters or less lethal rounds at heads, not at ground level as they are designed to be used.

Haven't seen or heard of any fireworks, which you can be sure the police would not tone down in reports (probably describing them as explosive projectiles).

It certainly isn't easy to keep your cool if things are been thrown at you, but that's the job. It's not an excuse to violently attack protesters who are not throwing things or use inappropriate methods.
> How will you typehint that?

For that specific contrived scenario (mongoengine, which I've never used, apparently uses .aggregate for the latter rather than overriding .get) with two stub @overloads of [...].get for typehinting, one covering what it takes and gives in the aggregate case of interest and one for what it takes and gives in the simple case.
Why do you say they are not associated? They seem part of a research group of the Technical University of Budapest, looking at the papers affiliations.

As a researcher I really appreciate the promotion effort, some years ago I came across a similar "landing page" for a numerical technique that helped me a lot: http://people.ece.umn.edu/users/mihailo/software/dmdsp/,

Trying to put together how a new numerical method works scouring for papers with different nomenclatures, different sets of authors, different implementations etc. is often a huge pain. I wish these "landing pages" became a standard, or that a standard repository for them became available. Something like, this is our technique, these are the relevant papers, and here is some demo code.
Android phones sold in China don't have access to the Google Play Store so every phone manufacturer has their own store. Some apps (like Feiliao, ByteDance alternative to wechat) are distributed as .apk directly from the app website.
I have and I found C# to be somewhat painful compared to JS in some respects, but good in other ways.

There are a lot of little conveniences that are missing. There is no destructuring, no first-class functions (i.e. can’t declare functions outside of a class), no easy way to loop over properties of a class and access their values, no spread/rest operators and other things like that.

I think the C# 9 might address some of these shortcomings.

Some things that I liked about my .Net core project: I didn’t have to write swagger documents at all. They just got auto generated from my API classes. Dapper is better than any micro-ORM that we have in JS. I didn’t have to write a bunch of tests to make sure I was using correct types. It works great on Linux!

Everything’s got its trade-offs. I started my career with Microsoft Access, VB 4/5/6 and complained about moving to .Net. Then I did like 12 years of C# and couldn’t imagine loving JS until I started doing that full-time, since like 2013 or so.... I was glad to polish off my C# skills and to learn .Net core though, just in case I want to switch back some day.
Tools of the national security™ apparatus and its profiteers repurposed for domestic use[0]:

2014 CFR discussion[1]: "… What about Twitter? I have no idea what Twitter is good for. But if it flips out every tyrant in the Middle East, I'm interested." - Michael Rogers, Founder, Practical Futurist; Futurist-in-Residence, New York Times Company

[0][1]: https://news.ycombinator.com/item?id=15623278
Societies organize and stabilize given their own environment, history and ethnic composition. I disagree with judging how people on the other side of the globe manage their lives and their beliefs, as long as they can do it on their own.

If a traditional Tibetan saw American society, he could tell that they "live in a slave state, having to bear the burden of debt and interest for the most part of their lives" - because it may be unnatural for them. They would be quite astonished to see the amount of atheists.

Promotion of humanism everywhere in the world is another piece of the occidental imperialism.

It's useless to claim you are against racism and else if you do not understand that people from around the globe are perfectly right not sharing your set of values.
Chromium contains a really solid implementation of OS process sandboxing, which is rather secondary to the bits of building a web browser that we need competition on. It could very reasonably be spun out into its own project, but that takes time and effort so it stays part of Chromium.
U know what is cool, human eye's sclera is white making it easier to know where a person is looking and to trust them. As opposed to gorillas you never know if they eying u to maul ur head.
The major advantage of u2f is phishing resistance.

If you always use u2f for auth, you can be sure that you are not fooled by fake login pages. It ain't just matter whether secondary otp is available. (it's just a backup for when you lost a hardware token!)
Unfortunately the search is broken for pubmed.gov, so straight link: https://pubmed.ncbi.nlm.nih.gov/15311477/
People love the language because the language doesn't matter?

I don't think that quite explains it. We loved Python at version 1, before pip and PyPI were around - although the "batteries included" standard library played a similar role to some extent. For me it's mostly the syntax and the simplicity.