skysight-inc/HackerNews huggingface dataset:
Just think of all the interesting data they will aggregate!

(This is a recycled comment from 2017¹.)

1. https://news.ycombinator.com/item?id=15565018
Author probably could have chosen a better example such that it doesn't look like the author chose letters sequently. In this case the letters are meaningful as they are the same as the first of the table name, a common convention, unfortunately that happens to be the first two letters of the alphabet...which yes, would be very annoying.
You keep saying that word. Is there some postpostmodern meaning of "gatekeeping" that I'm not looped in on? We just hurl it around now and hope that bystanders mistake the people we disagree with for oppressors?

(The downvotes indicate the arrow hit the mark. No lie, I sincerely appreciate the confirmation.)
Let me put it this way; I recently wrote a script to parse the output of last and format it.

The Node version was some 90 LoC but if I included the dependencies it came to about 5 MB. Then I rewrote the same script in Python3 and it was 60 LoC and no dependencies that needed to be installed separately.

I will admit that the JS code looked _a lot_ cleaner than the the Python code though.
As a bookmarklet, none :) That's the best you can get.
Products are chosen by a weighted sample of the people, according to how much money somebody has access to. "Vote with your wallet" means that different people have different sized votes. "Vote with your wallet" is an inherently anti-democratic phrase.
What would you say is the superior alternative?
This is a really tortured analogy. Google isn't building a doomsday weapon, it's a mobile app distribution platform for what is almost entirely composed of trivial time-wasters. Believe it or not, some people base their reasoning on principles rather than the topic of discussion's perceived reputation.
Is it though? During the early stages of the pandemic I noticed that many people seem to have a pretty poor idea of what a six foot distance looks like.
Most of your queries shouldn't be so verbose as to confuse which aliases you are talking about, but I agree - here's the best format :) (because why put ON on another line anyway?)

SELECT
bo.title,
au.last_name,
au.first_name
FROM books AS bo
LEFT JOIN authors AS au ON
bo.author_id = au.id
You said it's a contradiction that I say that a) Google exploits developers (in a way) and b) developers [can try to] to exploit Google. I made an over-the-top example to show that these two are not mutually exclusive.
Game devs don't optimize for security, because they're not incentivised to.
you might be attaching too much importance to shipping quickly. being promoted quickly is the metric of importance
No warning just pops up, usually they have to redirect the user to manually open settings, or at least open settings for them. It's not a simple dialog, they have to remember instructions and then apply them within the separate settings application.
And then no auto updates on top of that.
A total guess, but maybe because it renders better on mobile?
> If it's encrypted and only you have the key, then it doesn't matter where it's stored.

Until advances in mathematics or computation obsolete the crypto. We might decide that it doesn't matter within each respective patient's lifetime (a debate) but that is getting longer and longer.
Even before BYOD, I remember hedge funds giving out iPhones for their employees. Was a signaling move since everyone wanted one.
Better alternative pipeline?

I’m doing non destructive editing in Lightroom Classic and moving files over into Photoshop occasionally for finer editing

How do I replace this workflow?
Aside from the privacy concerns, I'm not sure I'd want to put data my life may depend on in a product from a company with a track record of randomly dropping products with little to no lead time.
Hence why I said that the more data an app is trying to get access to, the more random variability should be introduced. Some apps might legitimately need access to some data points with "minimal" random noise. But if they start asking for enough to uniquely identify a user then the OS should just "blur" all the data. Battery level can randomly vary on any app that can't justify knowing the exact value. Imagine the app having a "budget" for getting exact data: it can spend it on 2 precise data points or 10 very blurry ones.

Unless Apple decides to implement some form of VPN to obscure the IP there's not much to do about that, the phone can hide it only from the app, not the server. On a mobile network this seems less of a concern, and even in the home it wouldn't allow unique identification. So assuming the IP was the only thing that leaks and every other data point is "poisoned" by the OS, I'm sure it would make those companies tracking you deeply unhappy and unsatisfied.

Maybe some loopholes can't be closed, others may provide precise data but it's shared with millions of users making it as generic as it gets. Just raising the bar for successfully tracking the user to a very hard to reach level, and lowering the overall accuracy to the point it's no longer a practical concern could be good enough for all intents and purposes.
> NZ has extremely high international air traffic.

Maybe per capita but not per se. The US had 241 million international air passengers in 2019[1]. The UK had >160 million[2]. The US has two land borders with significant traffic and the UK had 21.5 million Chunnel passengers in 2019[3]. The volume of passenger shipping is also vastly higher in both countries. NZ also has almost no illegal border crossings.

NZ has a much smaller risk profile than these and many other countries. And this is born out by events. By the time the world became aware of what was happening the virus had already been spreading in Europe and the US for months. While it had been introduced to NZ it was still in much earlier stages.

[1] https://www.bts.gov/newsroom/final-full-year-2019-traffic-da...

[2] https://www.statista.com/statistics/303654/number-of-arrivin...

[3] https://www.statista.com/statistics/304968/number-of-passeng...
I've taken to using a similar format too, though some seem to dislike it significantly. Other things I like for clarity and editing ease are prefix commas and lining up like parts, using something like your example:

SELECT a.foo
, b.bar
, g.zed
FROM alpha a
JOIN beta b ON a.id = b.alpha_id AND a.another = b.thing
LEFT JOIN gamma g ON b.id = g.beta_id
WHERE a.val > 1
AND b.col < 2
ORDER BY a.foo

or

SELECT a.foo
, b.bar
, g.zed
FROM alpha a
JOIN beta b
ON a.id = b.alpha_id
AND a.another = b.thing
LEFT JOIN gamma g
ON b.id = g.beta_id
WHERE a.val > 1
AND b.col < 2
ORDER BY a.foo

I'm not consistent with the layout of my joining predicates - I go for whatever seems clearer given the current circumstances and that varies due to several factors (number of parts, length of column names and/or functions, ...). How sub-queries and instances of CASE are broken into lines and indented is something I also vary on.
Oops, 1830. Liverpool and Manchester Railway. First railway with all steam locomotives, double track, schedules, tickets, and signals. That was when the Industrial Revolution got out of beta.
Grand Transitions: How the Modern World Was Made
You just have to look at the SAFe diagram to see that it’s complete insanity. Basically the pipe dream of managers who want a fully automated, predictable process.

https://www.scaledagileframework.com/
I think it would be easier to order things in terms of when they are executed. And perhaps it would be easier to teach SQL if the different parts where more obviously separate. As the different parts are actually distinct and don't really cross over. But to a newbie would seem procedural when it's not.
It would be hard to write a browser from scratch now that had the features of a modern browser, but creating a first-class browser is much easier than it has ever been because of Chromium and Firefox.

I agree that mobile is the direction many things are headed, but currently it's very easy to install any number of (sometimes shady) browsers from the Google app store that include ad blocking.
So good luck getting funding for something that you tell the funder could earn millions if it works out. That means less greenfield investment, and ultimately less investment for apps that make less than a million, since only X% will end up doing so, but investment will be impacted for all.
In Defense of Signal
Citus Talk at CMU: Distributed PostgreSQL as an Extension
Gluster is also so much easier to set up IMO; the only reason I wouldn't use it is that it seems to have some consistency issues such that ex. you could run postgres on ceph, but not (safely) on gluster. But I don't understand it well enough to know why.
Incarcerated and Infected: How the Virus Tore Through the U.S. Prison System
One would have hoped that GDPR would have required companies to publish documentation for the file formats they use, so that customers could move their project from one program to another.
Unfortunately GDPR is only about the web (or that's what companies say when you ask for a file format and they refuse).
People make distinctions between "high culture" and "low culture" in cultural analysis now, because it turns out that gatekeeping literature means we only really have an accurate picture of what elite culture in the past was like, not what the lower classes actually lived, perceived, and experienced.

Also, some of our literature started off with not great origins one would really attribute to the "proper" form of literature today.
Protesting what you believe to be a corrupt system isn't overthrowing the government, else BLM are also guilty. Illegally protesting inside the capitol isn't overthrowing the government, else AOC would be in prison for leading protesters into it in 2018.

This protest was far less violent and less destructive than those that Americans have been made to accept as peaceful throughout the preceding year. This wasn't an insurrection, and none of your gaslighting will make it so.
Depends on what you actually want to do, because Photoshop is an all-trick-three-legged-pony, whereas the alternatives are all "we need to do X, and we need to do it well, let's actually make that application instead of something as insane as Photoshop".

Krita, Clip Studio Paint, DxO, aseprite, there are tons of great options if you actually want an application that was written to be "what people who want to do X want in an application", instead of trying to be all things to all users.
> Apple is the only reason this piece of junk is still selling.

Not sure I understand, sorry. What do you mean?
I had the old Fire TV Stick and can confirm the latency was bad.

The 4K one is much faster (irrespective of display resolution) than its predecessors. I really like it.
Another commenter showed how this works:

SELECT a.foo
, b.bar
, g.zed
FROM ...

While the comma placement may seem weird, it makes this exactly identical to the "AND" or "OR" placement in WHERE clauses, and the primary benefit is that it's easy to comment out any column except the first.
That's why efforts should be directed towards improving this aspect of Android, not removing entirely user's capabilities to manage his own device.
I know it's mostly just a meme, but I find the idea that laziness is a virtue unfortunate; IMHO it's one of the worst vices a programmer/team player can have.

Not taking five extra minutes to explain what you did when submitting a Pull Request - that's laziness, and forces your team mates to spend more time and mental effort on understanding what's going on.

Not going back over your diff one last time before submitting it for review - that's laziness, and it puts the onus on discovering things you forgot on your team mates.

Not going through the effort of making individual changes easy to revert - that's laziness, and it forces the future maintainer (possibly yourself) to put in extra work at a time when they're under stress, e.g. when fixing a critical bug.

I could go on.
Qualcomm and Oracle are clearly bad actors. IBM? Probably. But I have no idea honestly.

But Apple? The only patent suit I'm aware of that they initiated was against Samsung and this is a little more complicated.

First, it was primarily a design patent suit. I'm a little more sympathetic to design patents than software patents (which I'm 100% against). And, let's face it, Samsung did pretty much just rip off the iPhone. There were some non-design patents thrown in there too, that's true.

But the commenter I replied to suggested these tech companies were using patents to squash smaller competitors. And for most companies that isn't true. Even if you choose to include Apple in a list of companies that use patents offensively rather than defensively, Samsung isn't really a small competitor, so the point stands.
I used it recently for the first time in 5 years and it has new/improved features - but the rest of your points still stand
"Wrong"? I'm suggesting it's a space you could look at to see how the transition went, in a space where the website owners knew for sure it was required.
I should have thought this through before linking to a self-hosted site [1]

[1] https://b3n.org/about/
I wonder if this might be a play to try and get some money from Amazon to reverse course...?
The usefulness of this advice depends on the schema or design of the database. If the data is normalized, then it's quite reasonable to design for unambiguous field names in the queries after all relevant joins.

Sure it does not help to understand the origins of a given field without aliases, unless someone is very familiar with the schema.
This is an interesting read, but illustrator can also generate vectors from a raster image with a couple of clicks and parameter tuning
I never truly realized that doing things in parallel was WIP itself, even if I have read the Phoenix Project. I mean now it just makes sense and I kinda feel dumb.
Datapoint : one of our cats was born feral and will definitely intercede in any bickering.
TIFF works just as well in photoshop, preserving all layer data, while also being compatible with other viewers
The main reason to drop support for Amazon devices is you want to start using some Google Play Services API's.

They include everything from fitness tracking to push notifications to face/voice recognition.

I wonder which they want to use?
> And at the same time you're saying its value comes from mutability but then saying that it's better to rewrite it?

You do realize that "mutability" means "ability to be changed", correct? It's value comes from being able to be rewritten piecemeal, as opposed to hardware where you'd have to design a new PCB, manufacture it, then snail-mail it to all the places it should be, then install it.

>> so the vast majority of software will break due to changing requirements or dependencies

> This also depends. Exhaustive testing for the sake of testing is not good, but a good test suite that exerts the overall functionality of your software is almost always good and allows for much faster iteration down the line and pays itself in a short amount of time or iteration cycles.

What you said literally had nothing to do with that except you quoted from my comment.
Eliot is overrated in my opinion, although I do still enjoy his writing. Complicated does not always mean good. It’s a little surprising to me that you don’t see Whitman as kitsch, things like this definitely are: https://waltwhitman.com/i-saw-in-louisiana-a-live-oak-growin....
> Apple is the only reason this piece of junk is still selling.

And it's buggy on macOS too. It's the only program on my computer that does some wacky shit with window management, such that sometimes other apps' windows appear on top of it. It very much feels like it tries its best to go against AppKit for no good reason, and then reimplement some of its behavior but shittily. Oh and also, the "new document" dialog takes literally 5 seconds to load.

Edit: I'm using an older version, 2017 I think? Updating it is quite a process as a non-paying user, and none of the new features are worth it for me.
No, the parameters of the discussion was “real actual problem” meaning = “problems that put someone in a position where committing violent crime is preferable to the alternative.” It’s reasonable to assume OP’s intent was not to imply all other problems aren’t real.

And frankly, you don’t have to have experienced anything remotely similar to understand how economic desperation leads to crime, it just requires a capacity for, and willingness to employ empathy.

On the other hand, “Cancer patient goes on crime spree to pay for chemo” sounds like it could be a very funny film, in the hands of the right writer.
This is closer, although it’s possible the cats didn’t pity an owner as readily as a dog, or that the cats perceived the owner was faking the disability to open the box.

Disclosure: I think I have observed the latter behavior on many occasions.
This was a 'freedom of navigation' exercise and the entire point is that you do not ask permission. Ever.

Asking permission presumes that the other party has an opportunity to say 'no', and an FON transit is to show that these international waters are in fact international and not under any particular national jurisdiction. If India wants to complain they can talk to the hand as far as the US is concerned, same answer as would be given to China if these ships were to transit the Taiwan straights, or England and France if they went through the channel.
EEZs do not regulate the transit of ships, and this is very clear in the treaty. India's domestic law has no relevance here. The purpose of the freedom of navigation exercise (and publicizing it, as the former chief of naval staff complained about, is to demonstrate that other countries are free to sail in international waters.
or of their own pack, at least it seems here
Well people can do something about it. They can invent their own app store and operating system and negotiate with hardware vendors to deliver it. Does that seem difficult to do? Yet that's what Google did in the face of iOS. And it's what Apple did in the face of Blackberry/Nokia. It's what Purism is trying to do now.

Google's actual infrastructure costs are not low, they're actually so high that many people don't think it's feasible to do it. It's so high that they're reduced to complaining about how difficult it is to do anything other than use Google's existing infrastructure.

Maybe that still feels unfair. I'm not totally unsympathetic to that perspective. But it's wrong to characterize Google's costs as trivial and claim that there are no options. Both you and the author imply that Google's 70% marketshare platform is a triviality worth far less than they charge, and that doesn't strike me as entirely fair either.
More evidence that Facebook ad targeting illegally discriminates
Just out of curiosity, why would anyone subject themselves to use chrome on iOS? Sync is so important that you deal with the web without content block?
Your Programming language does not matter
Yeah. I don’t understand why people like to jump from one extreme ideology to another extreme. First it was “plan everything ahead in detail” which then got converted to “plan nothing ahead”. Both are insane and don’t work. I always ask where the decision makers see a project in maybe 3-5 years. Having that long term vision gives a lot of insight into possible software architecture decisions. You still can make changes but at least the general direction is right.
Perhaps wrist bands would be more feasible with current battery/sensor tech, but, yeah.
Did anyone ever read the documentation?

Serious question. I've spent a lot of effort writing internal and external documentation for various systems over the years, and I'm not sure anybody ever read any of it.
That's not true, both stores only allow this (the "donation" button) for registered charities and foundations.
One of the things about Perl is that I can't quite believe myself how far it has fallen.

I was never a Perl monk by any means but I knew enough to get by. And why did I not even think about it? I haven't coded Perl in years, but if my memory serves me correctly, bundling extra dependencies in Perl was a heck of a lot less painful than Python too.
I've done the exact same trick in my mind to remember a sequence -- the "linked list" linking A to B, B to C, etc. It just seemed natural to me, I didn't read it anywhere. If you have the "head pointer", you're probably golden.

When I told a colleague about this years ago, he said that my approach seemed so much more complicated and/or difficult than his approach (IIRC it's called the Memory Palace?) of building a castle/cathedral / museum in your mind, and as you walk through it, you see a banana on the left, and then a monkey a little further down the hall, then a trombone on the right, etc. For me, that technique simply doesn't work, as much as I try.
Moderna hits safety problems in bold bid to revolutionize medicine (2017)
I played fetch with my male cat with very few breaks for an entire sunday back in 2005, which i remember because we were watching NFL games for a considerable part of the time.
I think by using an irrelevant example you inadvertently demonstrated the exact opposite - that they are.

If two parties "economically exploit each other equivalently", there is no exploitation.
Came here to post exactly this.

If the tables names are long, by all means abbreviate them a little, but never just use 1 letter aliases.

I wonder if the author has ever worked with a system that has more than a handful of tables.
And I'm saying it was always required, there was no transition.
... because a seller literally has 99% of the market to go after instead because they don't have a policy like that?
Personal habit is to start my WHERE clause with a TRUE or a FALSE so that adding or removing clauses becomes seamless:

SELECT foo
FROM bar
WHERE TRUE
AND baz > boom

For OR conditions it's a bit different:

SELECT foo
FROM bar
WHERE FALSE
OR baz > boom
why use lot word when few word do trick
Very true. The decision makers kick something, fall asleep during the work and then start to panic close to the end. Agile would require constant engagement by the business people which I have seen very rarely.
We’ve got that. We were on 200 and it wouldn’t go above 60. Since they finished the upgrade for docsis 3.1 and we switched to 1gbps it’s been what we wanted 200 to be - reliable and invisible. I hate them with a passion, but hate the UK gov more for its incompetent handling of fibre incentives and coordination nationally.
It's just a casual couch browsing machine. I am not worried about sync but Chrome seems to work better on this older iPad than does Safari.
Ordering a pizza usually isn't that complicated. I don't think my local place even has online ordering. I have a paper menu at home. I decide what I want, call them, and then I pick it up.
> I'm fairly sure both consider their owners to be one of their own species.

At least for dogs, I'll have to disagree here. Dogs have a complex political structure among themselves, and humans never take a part in it. You are not the "alpha" of your dogs pack, you are something completely different.
I think you're right! Thanks for this tip.
“I want to hecking scream,” the italicized emphasis and explanatory interjections seem to indicate otherwise.
Why is a developer deploying to production in the first place? To minimize the work for everyone the code should have gone through QA before it was passed to ops. Ops should be confident that QA did their job sufficiently (“A lazy programmer knows how to delegate”) and shouldn’t be afraid to start the deploy job whenever.
when you president, they see