skysight-inc/HackerNews huggingface dataset:
In general there is a simple rule: either usability or security.

All general consumer grade tools are fighting with this equation: How can we make an app which will appeal to the broad audience which will be easy to use.

I can't say anything about signal but in general if something is easy to use and you can chat super secure with your grandma then most likely it isn't secure how you might think it is and it's actually an issue because you may want to send data which otherwise you wouldn't if you know you're on compromised channel.

Sharing history between e2e encrypted devices is a tricky thing because you should have forward security with some ratchet keys.
Scaleway, with or without their DBaaS offer if you need more perf
This article cites obesity, diabetes, and other health metrics that do not appear to be adjusted for differences comparing different population's age ranges. The Amish have very large families (6+ children per family) so they have as a percentage fewer old people who have more health issues overall.
This doesn't make sense assuming Apple doesn't have visibility of the app development, especially if OP is developing while not enrolled to the Apple dev program.
You can check the French distribution of smokers by age group here (could only find data from 2010, there has to be an updated dataset somewhere): https://www.statista.com/statistics/785664/consumption-daily...
They are allowed to leave the ship while moored, fyi.
Adding a data bus to all lines would be a much bigger deal than changing sockets for existing lines or running a slightly different voltage (often within tolerance of the power supplies anyway!) over the same wires.

And USB isn't meant to operate over those long distances. So you'd either need some active component in each socket or devise a new standard.
Does that include recognizing Taiwan?
I think Telix was just one popular modem program of many.

Just Google for "BBS" i.e. bulletin board system.

They worked over phone lines. Normally you would know about one BBS from a computer magazine and then that BBS would have a megalist of other ones on it.
This is a great resource for anyone who is interested in an environment based career path
A lot of things that aren't beautiful or meaningful can have intrinsic value.

There are probably a lot of people here who like Recreational Math: stuff like finding pairs of Amicable numbers. This seems to me like it's only beautiful or meaningful in a similar way to contemporary art, but it's still intrinsically valuable, even though I don't understand most of it.

As another example, if you look through the Guinness Book of World Records, you'll find tons of stuff that isn't "good" but still seems valuable. It's not "good" to have five-foot long fingernails, but I'm still glad that the world has someone in it who does, because it makes it a more varied and interesting place to live.
Great Idea.
Bug Report: if I search for "Software" and then go to page two, the url does not include the search-term, which leads to a "ValueError at /search/"

That debug/error page shows a traceback and many server settings, which you might not want to share in a production environment.
The Catalina move already killed off a lot of games where the developers didn't provide an updated (x86_64) binary. A move to ARM would kill more, of course, but it's not like there's not precedent.

I'm half-convinced that Apple killed 32bit support so early precisely to see how developers coped; if it had been really bad they could have re-introduced it in a point release of Catalina. As it was, it wasn't very bad and most developers complied, which is an argument in favour of an ARM transition being feasible.

The only other reason I can think of to so aggressively move to 64bit is security, but most of the apps that were stuck on 32bit were not that big a security concern.
> - When to use JOIN vs a subquery?

Normally, subqueries return a single value whereas joins can result in n rows of output for 1 row being joined on, and you can access all the columns of those n rows. There are ways to make use of more than one value (e.g. (tuple) IN (subquery)) but if you want to SELECT more than one value, you need to join.

Depending on the database, it might be slower to do a correlated subquery than a join though (MySQL especially).

> - When is a subquery actually a correlated subquery? Will this destroy your performance? Or is it a critical feature?

A subquery is a correlated subquery when it references symbols from the outer query. That means it needs to be evaluated once per row, and can't be evaluated once at the start of query execution. It can destroy performance if it needs to be evaluated too often - if it's in your 'where' clause and is evaluated over too many rows, e.g. it's mixed in with a boolean expression that can't be short cut.

> - Should you put constraints in the JOIN or in the WHERE? Will the distinction drastically affect performance?

Conventionally, you should put equi-join constraints (equality expressions with foreign / primary keys in other tables) in the JOIN clause and other constraints in the WHERE clause. For inner joins, it doesn't make a difference where you put the predicate, semantically. There is a semantic difference for outer joins though (left join, right join, full outer join): failure to join results in a tuple worth of null values from one or both sides (left/right vs full), rather than eliminating the row.

Where the semantics aren't different, performance should not be affected. Of course the database engine might be stupid, but a fundamental requirement of a reasonable query planner is in determining (a) join order and (b) which indexes to use for the combination of join predicate and where predicate. No query planner worth its salt won't consider using the where clause along with the ON clause on the JOIN when fetching rows in the joined table.

> - When do you use WHERE vs HAVING?

WHERE is before GROUP BY and filters the rows that enter aggregation (if any), HAVING comes after GROUP BY and filters the aggregated rows. If you use a derived table (a nested query with a table alias), then you can use WHERE instead of HAVING for no semantic difference, but derived tables may execute differently (MySQL will generally materialize them, PostgreSQL will see through them).

> - Is the NULL from the join because no joined row was found, or because the joined row had a NULL value itself?

If the column is nullable, and you used an outer join, you can't tell. Normally you check for the primary key or some other non-nullable column to discover if a join failed (most often used in anti-join, when you want to find all rows that don't have corresponding rows in the join).
.NET Core 3.1 single exe Console App (smaller)
I was kinda making a joke but here is the direct clip from Rocky.

https://youtu.be/WvAeWtyZ-uE?t=31
Does anyone know how this will affect the water issues that Cape Town have been having? As far as I know, Cape Town's 'Zero Day' is still something people are cognizant of.
Minus the buzzwords, here's what this article is saying: when you build an MVP, you should bias towards cutting features rather than cutting polish or introducing bugs. If your MVP is filled with bugs, it isn't actually viable. You should also focus on making an MVP that people actually want. If it isn't solving a real problem ("loveable"), it's not actually a product.

In other words, increase the polish of your initial releases by making them smaller and including fewer features. That's valuable advice.

But if I can rant for just a minute:

Do you need a completely brand new concept or paradigm or acronym to say that? No, you don't. This is mostly just playing semantic games and allowing WP Engine to subtly imply that they're better at building polished products than other companies.

How do you make something simple? You make it do less stuff. That's what "minimal" means. What does "loveable" mean? It means you're solving an actual problem -- you have a real Product. How do you build an SLC? You radically cut down on the number of features you plan to ship in an initial product, to the point where you have time to polish them in your initial release. That sounds a lot like an MVP to me.

If WP Engine just put up an article saying, "our software is always very polished and very usable, even in the first release", nobody would care. The way to make people care is to pretend that you've found a completely new paradigm for building software, when all you really mean is, "we're quite good at building MVPs that people like."

The article isn't talking about new concepts, it's just debating what other people intend when they say individual words, and I couldn't care less. It's like saying, "we don't focus on making our product 'fun', we focus on making it 'delightful'." Okay, but what does that mean beyond the fact that a business manager somewhere thought it tracked better with potential buyers?
Cheap in this case usually means "free with monthly contract" rather than cheap upfront
Undo Git Actions with CMD+Z
This is no different than when it's in the ground naturally.
What is the difference between "viable" and "complete"? Complete, as in "Simple, Lovable, Complete", is about your customer's ability to derive net utility from using your product for their job to be done. Viable, in the MVP context, I interpret as signalling a credible offering in a market. The audience for viable is investors in your business, or customers willing to invest in a relationship with your business, in the expectation that your product will get to a point later of being distinctively useful.

Viable is promising, complete is useful today. The question is which approach will best fund your company to the point of operational self sufficiency. As an engineeer, I would far rather make SLC products. However, if I am racing for mindshare in a market or with investors, I have to think MVP.

SLC is harder to acheive. As Pascal sort of said, "If I had more time, I would have written an SLC".
How many registered accounts does HN have?
There seems to be an expert or at least enthusiast on almost any at CS/STEM subject that reaches the front page of HN. How many active user accounts are there amongst us?
I have to agree with the author. The MVP concept was new to me when I attended Startup School a couple years ago and while I understood what it gets at (not spending too much time or money on a concept that no one may want) it feels too much like selling a "promise" of what something will be, and it assumes that promise can be fulfilled.

To me, an MVP felt like showing someone a battery powered skateboard while telling them what you're really working on is an electric car. You may get investors, and that's great, but you may also spend years finding out you can't scale the tech to build the car.
The 2017 model MacBook Air is still available to education institutional (and probably corporate) purchasers as well.
> However, we try and avoid writing unit tests for behaviors Microsoft's responsible for,...

When you say "unit tests", this makes sense. But wouldn't it be wise to have integration tests in place that would guard against such regressions, either in your code or Microsoft's?
Part of that is due to the writing system - Icelandic has an unusually wide gap between spelling and actual pronunciation (as does English). The spellings often reflect older pronunciations, so it'd be easier for a modern Icelander to read the Eddas than to understand casual speech of their era.

(Again, similar things are true of English to a less extreme degree: The Canterbury Tales are a struggle to understand, but I can plod my way through them with the aid of heavy glossing. But I doubt if I could have a conversation with a time-traveling Geoffrey Chaucer.)
The First International Workshop on Smart Contract Analysis
LLVM Bitcode is still architecture specific. That is, bitcode generated targetting x86 is not compatible with bitcode targetting ARM is not compatible with bitcode targetting aarch. The reason they are distributed as bitcode is to enable additional optimisations based on what exact chip will run the code (i.e. -march=native equivalent)
I never understood how precedent system works, doesn't even have to be about progress of technology. Morality has progress too.

If someone ruled once that Indians aren't people and can be expelled from their property is that still a law? It can't be, right?

Or how about when you legalize something?
... also, this area is not known for large swell storms.
I didn't say that any of the M4A plans would ban private insurance. That doesn't change the fact that Bernie has stated that his M4A plan would, even where the plan he's put forward doesn't show that.

I think it's fair (if a bit naive) to take politicians at their word on occasion. Moreover, I think it's more than a bit disingenuous to assert that plans that are disallowed by law from competing with Medicare services still being allowed to exist for only elective operations as "not banning them." If I disallowed Netflix from streaming any videos longer than a minute in length, I guess technically I have not banned Netflix, but in practice, I have totally banned Netflix, and that's exactly the scale of disallowance we're discussing here.
Show HN: Dark Reader
Should run fine, especially if you use an SSD. You're free to use any of the lightweight desktop environments (lxde, xfce, mate, etc.). The remainder depends on your workload/usecase wrt. to mainly RAM-requirements for tabbed browsing (or electron apps).

The RaspberryPi 4 also only has up to 4GB of RAM and is capable of driving 2 4K screens.
It doesn't seem to work under Linux either. I also tried Alt-W in case my AZERTY keyboard layout would be the problem, but it doesn't do anything either.
Just as an FYI: https://enviro.work/search/?page=2

I clicked on the search with nothing in the search box and then hit the link for page two. You probably want to switch Django debug off and fix the error page.

That said, it looks really cool. It's a great minimalist design that gets right to the point. It loads instantly since you haven't loaded it with crap. It's really a pleasure to click around a site that just loads content without an amount of JS that makes everything slow.
> Its not inconceivable that the market/economy today is .1% of what it will be in 30 years.

I kind of followed the argument until this part. You seem to be saying that a 1000x increase in market/economy is possible in 30 years, mostly as a result of the number of people being around and productive. This doesn't hold up, IMHO, unless some other (massively more dominant) multiplier is factored in.
https://twitter.com/valve_software_/status/12529934603547402...
Open VSX: A Free Marketplace for VS Code Extensions
> As a development machine it will be all but useless as you find things that won't compile or work correctly on the new CPU arch.

I mean, I suppose it depends on what sort of development you're doing, but in 2020 most libraries do work on ARM. There'll no doubt be a painful period (as there was with the death of PPC), but it shouldn't be that dramatic.
Please don't post self-advertisements here.
There probably are PPAs that allow you to install 2 if you need it.
Telix[0] was just a terminal emulator, to find dial up systems you generally got information offline, such as via magazines or friends, and then got to know other systems from there, or from lists like the FidoNet node list.

[0] https://en.m.wikipedia.org/wiki/Telix
How to make Highlighting in search results
A Russian Teacher in America, Andrei Toom (1993) [pdf]
>rounded edges that make it even harder to grip one-handed

I don't get this criticism - I owned a 5 series iPhone and the anodized finish was anything but easy to grip. It looked nice but massively reduced the friction between your hand and the surface, making it the easiest phone to drop that I have ever held. Their lightness didn't help either.

Conversely the newer iPhones with glass backs stick to your skin almost like glue in comparison, and if anything I find the rounded corners increase the amount of the phone surface in contact with your skin.
Page one of the article explains how the rig was configured, noting various security things.

https://www.phoronix.com/scan.php?page=article&item=xeonr-ub...

https://openbenchmarking.org/embed.php?i=2003242-NI-XEONCASC...
Flutter Rating Widget for your application
While it’s a good idea, what determines if a job “benefits the environment”?

A lot of jobs in the list - particularly any startup jobs - are at best unproven in their effect on anything and at worst are a drain on funding resources and have worse negative externalities to the world than being productive in a job that’s not nominally “about” the environment, as well as the risk you’ll invest years of labor under the assumption the company has a mission to improve the environment only to see it pivot when the business realities crash the party.
AWS Brings Chatbot Integration to Slack Channel to Make Monitoring Easier
as someone that knows vanishingly little about PHP, is there anything in PHP I can't do in say, TypeScript (or at least not as expressively?)
Three Hours Longer, the Pandemic Workday Has Obliterated Work-Life Balance
I agree with the second part of your comment, but the opt in for adult websites was dropped over fears it wouldn't be effective. [1]

[1] https://www.bbc.co.uk/news/technology-50073102
My early 2011 15" Macbook Pro barely lasted 4 years before being bricked by a design flaw. These particular MBPs have ended up dying post-recall as well. Two out of the three that I know of in my social circle that got the recall fix died afterwards.

That 2011 MBP is easily the most short lived computer (and one of the more expensive) I have ever had, and I've had >2X more Windows computers than I have had Macs.

Having said that, I would still say that the 2012 15" MBPs were the pinnacle of MBPs -- for me --. I know that a lot more people prefer the 2015 MBPs, but thin and light is not tops on my priority list.
I guess my reply should be one level lower, it was an answer to "It looks like deb files only can be installed via the terminal."
Free resources for researchers during the pandemic
Facebook has almost certainly the world's largest codebase in any PHP-family language (Hack, which is essentially PHP + gradual typing + a better standard library, but still very much PHP-flavored). The code is fine.

Part of the reason is the improvements of Hack over PHP, part of the reason is very aggressive linting (to, e.g., enforce the use of types), and part of it is probably that Facebook doesn't hire for "PHP positions", but for generalist software engineers.
Can't go to next page and the search function doesn't work. Great mission!
I find this amazing. I am still finding animals which look like somebody made them up, here is the bat-griffon: https://www.nationalgeographic.org/projects/photo-ark/animal...

And the name (midas) is brilliant as well.
So far more iPad with a mouse ... some might say sadly
Lots of professions can kill people of they screw up. LOTS. Our society has various ways to deal with this.
I recall us doing this a couple of times when I was at Etsy (2012-2015). I think we did it with Github as well.

The thing to keep in mind is that accepting non team members and getting them meaningful work to do was already part of Etsy's culture. New engineers would bootcamp with a team for a couple of weeks when they joined. So the culture was already set up for this - managers and team members knew what to expect from a teammate who may not be a domain expert.

I think the way to start a program like this is to start with an internal bootcamping type program and learn and make mistakes through that.
There is definitely some impact. Our IT team has been working hard to automate some manual processes that never got focus before because the labor was cheap enough.

Once those systems are developed they won't go away after the pandemic is over and those roles will likely be allowed atrophy by attrition.
If you ended up getting lots of people using it then all of sudden people would change posting to when it is hot to post, so you would have to have some sort of queuing. It sounds like it would be most useful to marketers, which would I suppose help out something we don't want on HN, but if you did it you would probably end up being asked to provide "hot" time monitoring for a few other platforms, and then you could be on the way to monetizing it.

but then you're doing real work.
Or run virtual machines like Android users do.
If you want to pick a usecase for any new idea the best usecase you can think of is pornography.
I'd expect that realistically it will largely be about cost. Intel OEM prices for their higher end chips (and anything in any Mac is towards the high end these days; even the cheapest chips used in Macs are over $200 on a thousand order basis to OEMs) are very high.
Review and meta-analysis of unemployment and all-cause mortality (2011)
Michigan Company Invents Faster, More Reliable Covid-19 Antibody Test
> Part of me wishes it is for battery life, yet sadly in many area's like this when we gain battery life we find that offset with a smaller battery and the marketing of how it is now lighter prevails.

While Apple did definitely go down that road in 2016, since then MBP batteries have grown year on year back to the maximum (any bigger and they wouldn't be allowed on planes).
Cancer services may be rationed –limited cancer patient care “unlikely scenario”
Looks cool!

One very minor suggestion: Make it much easier to filter / search by location.
> Wouldn't that essentially be the death of accessibility on the web, though?

It does. And would condemn us to live again usability nightmare of the flash epoch.

People are confusing two things here: There is no need of replacing the DOM. There is a need to replace (modernize) the API controling the DOM.
How is it decided how many regulations are "enough" for a given field? It seems they are on an ever-increasing ratchet mechanism, often driven by mass hysteria.
The windows ARM has intel simulation. In fact Apple has done simulation/emulation/recompilation/FAT-obj for the last few transition. It would be the same. The problem is even if it stay the same many do not change (like Adobe etc.) which drag it. Hence, might as well move on.
Not every country has so small population and access to hydropower. Sure some small counties can go 100% renewables but it doesn’t scale.
> What is the difference between "viable" and "complete"?

That’s where a lot of people get tripped up: development may have one idea about what is viable whereas the business team has a completely different idea.
"Mrs Wojcicki added YouTube had seen a 75% increase in demand for news from "authoritative" sources."

Who ??? who in its right mind is watching youtube for an "authoritative" source ??
We have an infra rotation program, where application and service programmers can spend a quarter or two working under product infrastructure on whatever their infra passion is. It’s great to see somebody’s passion for a big change boil for a year or two, and then they rotate in and are given the authority to make that change.

That being said, I’d love to see people rotate between application and service teams. Some applications and services are years ahead of others in terms of their maturity and scaling problems/solutions, so there’s a lot of tacit knowledge to be spread. We have a monorepo so self-starters can read code and commit messages, but a formal program would really help accelerate and democratize the knowledge spreading.