skysight-inc/HackerNews huggingface dataset:
The SLS was pretty much designed by Congress. Design choices were made primarily to keep jobs in plants which were previously used for Space Shuttle parts.

With its impending first launch, a lot of discussion is popping up again about it arguably being way too slow to develop, overly expensive, and not fit for the intended mission profile.
The minimum enhancement I want for SQL is a version where no literal values are allowed in queries, as this would completely preclude SQL injection :)

To make that more tolerable for query planning purposes, there would have to be two types of query parameters: compile-time and run-time.

Next up: why not allow query clauses to come in any order? `SELECT .. FROM .. WHERE ..;` or `FROM .. SELECT .. WHERE;` and so on.

Since the query parser/planner has to see the whole thing anyways. The parser/planner can't begin coding at `SELECT`, or at `WHERE`, since there might be a `GROUP BY`, or an `ORDER BY` that affect the whole query plan, so all these clauses might as well come in any order. Wanna put `HAVING` first? Sure, why not. It's probably best to insist that table sources all come together rather than be all over, but I think even that doesn't have to be so.

Also, I'd like an out-of-band mechanism for expressing query planner hints. This would be a separate string or object passed along with the query, and which does things like: identify a table source to use as the outer-most table for the query plan, for each of some or all table sources identify an index to use or temp index to create, for each of some or all joins pick a join strategy, etc. Table sources would have to be addressed as {<CTE_name>, <table_source_name>}, naturally. Such a thing should also allow one to specify indices that should be created on CTEs.
You'd think that, but historically this has only encouraged niche businesses to crop up catering to that crowd. Look at Epik (or Vultr) for example, businesses that exist solely to counter this kind of threat. Yes, they still reserve the right to remove abusive users, but that's defined by legal statutes and technical limitations rather than 'icky feelings'. Both services have a surprisingly solid track-record servicing the roughest of customers.

Failing all that, KiwiFarms doesn't need a business to stay afloat. The endgame for all of these so-called 'abusive platforms' is retreating to I2P/Tor, or another internet-adjacent network. To stop KiwiFarms from existing, you need to literally silence the people using it, not just shut down their clearnet website. Websites don't harass people, people do.
This is your reminder that the FSF unionized to provide protection for the FSF against his history of workplace harassment and more. Most of the FSF staff aren't comfortable being alone in the building with him.

As someone who is on the same boat: he's been asked to, and offered help with getting, counseling and behavioral therapy to help him see how he can improve his social skills. There's being an awkward socialite and then there's actively not working towards success.
The kdbx format used by KeePass is an open standard, and can be used by a variety of password management applications. Perhaps another app using that format might be a better fit for you and your organisation?
Which threat do you have in mind in particular?
What about just keeping existing flags in Chrome [0] which used to be there? Is it too much to ask? I don't want to use Google search + Chrome so I can get scrolled into middle of a page without any context with random highlighted text, because Google search believes this is what I want to see.

Thankfully switching to Brave solved my issue and this stupid feature is disabled.

[0] https://perishablepress.com/disable-chrome-scrolltotextfragm...
Yea, the story is still interesting, how they chose that path. Highly recommend watching the link i provided.
Nobody's going to accept $500k to sell a house after thinking it was worth $750k, though, especially:

1. After 9% inflation

2. With a <3% mortgage rate

3. If it would mean realizing a loss

4. When they can rent it for more than their PITI

Prices do not have to go anywhere.
Why Bloomberg Lives on and on and on and on and on and On
My company also pushes Keepass. The main reason is that it's free and there's no server to run. Getting a budget for something in a large company is a pretty large barrier.
Especially when you look at the majority of startups getting funded or posting in "Who's Hiring" and the descriptions of what they do boils down to.. trying to solve some trivial problem.
>a 20% reversion sends most people who bought recently underwater.

Does this matter as long as the owners can pay the mortgage?
Someone just created that!

https://excelformulabot.com/

Apparently Microsoft is creating a plugin.

(Not affiliated)
Loads of Natural Gas
RIP – Peter Eckersley – Who Made the Internet a Safer Place for Everyone
You mentioned AB tests — how do you see FlyCode allowing the product team to run AB tests without developers specifically adding AB test support?

I wouldn't mind if devs only needed to make a one-time change and then product could run AB tests on any page they wish.
The functionality I want is a count-by-format function. I had to write my own in VBA and of course that means every time I open that sheet I have to approve its use of macros (and it also doesn’t always catch format changes that impact the calculation)
Zip | Hybrid (2 days in office) | San Francisco, CA | Software Engineer

B2B spend has completely transformed in the past 10 years. In the past, companies hired people to ensure they grew and scaled, but in today's world, most tech companies rely on external software and services for their scale. Zip is building the end to end product to manage this spend for companies. Our mission is to increase the pace of innovation for every business in the world by simplifying this complex process for business modern day. We have both an incredible team and incredible growth numbers. Check us out: https://ziphq.com/careers
kf was the most accessible and moderated forum for gossip of internet personalities (mostly negative in the same way traditional gossip magazines are typically negative)

this recent action seems to be related to their long-running beef with a particularly well-connected transgender, over being the primary location for documentation on questionable activities like shipping hormone replacement drugs to minors
> By lot of admin you mean that it's not automated? That's sad indeed.

How would I automate "[someone with an account] just entered abc-xyz@domain into a web form to subscribe to something, add that to the valid alias file"?
Are you sure? My impression from e.g. https://stackoverflow.com/questions/13210239/can-a-c-compile... is that it’s alright to cast between a pointer to a struct and a pointer to its first member.
On articles like that one, the Talk page is a far more realistic view of the subject than the actual page.
Nonsense; I printed out a copy of the AGC instruction set reference, stuffed it in one of my model rockets, and it turned into a Saturn V mid-flight.
They're binary prefixes[0]. If we go by the traditional meaning of the SI prefixes, "M" means "10^6", so 1MB is 1,000,000 bytes. 1MiB, by contrast, is 1,048,576 bytes (1024*1024, or 2^20), which would be more correct for something like RAM.

Yes, in the past the SI prefixes were "abused" for power-of-two quantities, but nowadays it's best to be more precise, as many computer-related things actually do come in power-of-ten quantities, not just power-of-two quantities. For example, my NVMe drive's capacity is actually 2TB, not 2TiB[1].

[0] https://en.wikipedia.org/wiki/Binary_prefix

[1] Ok, ok, it's actually showing up in `parted` as 2,000,398,934,016 bytes, which is a little bit more (~380MiB) than 2TB, but considerably less (~185GiB) than 2TiB.
Battery life. Many of us using memory are using it on portable devices. And even if we're using servers, the power consumed there matters too.

Refreshing that RAM costs power and more RAM means more energy -- even if the memory is unused.
I understand that we disagree, but Eric Evans also talks about how implementation is an inescapable part of design, as does Jack Reeves. So it follows, for me at least, that estimates can never be accurate.

Recently posted on HN was a link to a post at Lunar Logic where estimation is basically broken into 3 categories: “NFC” (no clue), “TFB” (too big) or “1”. They explain why here [1].

This has been my experience over more than 30 years of building products. The duration of any given feature/story is effectively unknowable, but we can make a decent guess as to it’s achievability, we can get a decent idea of the rate at which stories are completed.

The main problem I have with more detailed estimation is that the estimation process itself consumes significant engineering resources which IMO should be assigned to actual engineering.

To your specific points:

> "100% uptime is rarely achieved, which means it's unnecessary and unimportant".

This is specious. As an industry our estimates tend to be wildly wrong, and despite decades of dealing with “the software crisis” they are not improving. My position is that this means that we’re spending a lot of time estimating and then more time dealing with them being wrong. It’s just a waste.

> Regardless it's useful to be able to answer the "how long" question at least a coarse level to see if it's worth doing something.

This seems to be the wrong way to do it. Surely the approach should be to ask what value this “something” has to the business, and then determine if it’s technically feasible within that value.

But that would mean more work for the executives, and quite frankly this, in my direct experience, is not the kind of responsibility they like to take on.

[1] https://blog.lunarlogic.io/2016/how-we-estimate-at-lunar-log...
Bing does not force me to scroll on text. DuckDuckGo does not force me to scroll on text. Yandex does not force me to scroll on text....

Only Google Search does that. What a knee jerk response...
This has nothing to do with raw execution time.
Hacker News or Satire?
Not really. It's a clear demonstration that archives do not retain everything always. Whatever you read into it beyond that is on you.
Not true.

Lab leak hypothesis came up early from NIH's own people. We have the emails. Government officials had these emails before "We the people" did so would have been first to sound the alarm publicly.

https://nypost.com/2022/01/24/emails-reveal-suspected-covid-...

https://www.congress.gov/117/meeting/house/114270/documents/...
The Dawn of the Stupid Network (1998)
Denormalized numbers is one reason why you really want to think carefully if you try to optimize code by rewriting expressions involving multiplication and division.

For example, if you got "x = (a / b) * (c / d)" one might think that rewriting it as "x = (a * c) / (b * d)" will save you a division and gain you speed. It will and it might, respectively.

However it will also potentially break an otherwise safe operation. If the numbers are very small, but still normal, then the product (b * d) might result in a denormalized number, and dividing by it will result in +/- infinity.

However, the code might guarantee that the ratios (a / b) and (c / d) are not too small or too large, so that multiplying them is guaranteed to lead to a useful result.
> The security risk is that advanced functionality is available to all websites. Even if the browser itself is actually a perfect sandbox (and I don't think that's a claim anyone would make), it's still a security problem because a lot of mischief can be done within those parameters, such as tracking, fingerprinting, and other forms of spying.

No, it can't. It's an HTML attribute which enables some mobile browser UI around the standard <input type=file> behaviour. The only thing it allows for tracking is whether your browser supports that attribute, which narrows it down to about 60% of the browsers in the world:

https://caniuse.com/html-media-capture

The only way you're breaking that is if you have the kind of exploit which could break just about anything and in that case the argument would be more along the lines of “we should remove JavaScript entirely” since that's been a source of orders of magnitude more security problems.

> In the "bad old days", you could decide not to install plugins, choose which ones to install, etc. You could customize the attack surface you're willing to present. That ability is seriously constrained now.

Your choice was to enable a massive operating system-scale level of functionality in Flash/Silverlight or not be able to use many popular sites. Since those plugins were managed separately from the browser they did not follow the same secure development practices or sandboxing which the browsers were using, and many users either did not update them or did so on a schedule far slower than the update schedule Chrome or Firefox kept.

> In effect, it's allowing any random website to have the power of a natively installed application.

… with complete user control. That's exactly what you say you want in the next sentence and it's far better from a security perspective because trusting a browser's sandbox is a lot easier to evaluate than having to individually review every native application you install. Installing native applications should be seen as a relatively rare activity because they expose you to more risk and are harder to evaluate.
Depends. Denormalized means the database contains redundant data. If a query have to scan 10x or 100x as many rows due to redundant data, it is obviously going to be slower. But it is hard to say anything general since denormalization will make some queries faster and other queries slower.
This why they no longer send purchase order details in the confirmation emails, they don’t want the competition to get ahold of all the precious data.

They would just make it impossible for the extension to do its job and laugh all the way to the bank.
Maybe he can't connect his phone to the same network the local server is on? Maybe he wants to share the URL to people not on the same network?
I use it on my phone and tablet. It works very well, I have no real complaints.
Neat! Sounds reasonable
Ok, this article makes me enraged.

Ten percent of women have endometriosis. That's 15 million people in the US. The typical wait time to diagnosis? DECADES.

Most of the folks I know with Ehlers-Danlos didn't get diagnosed till their 30s or later.

A company just came out with a working blood test for Long Covid....but right now, today, there are a bunch of doctors telling sufferers that "they seem depressed."

The HUGE problem in America is that women's diseases are underdiagnosed, underfunded, and psychologized. The number of people I know who were told they were depressed before they were diagnosed with serious diseases is legion.

A much MUCH MUCH smaller problem is that perhaps some people develop mental health issues around sickness identity.

Do those patients need to be treated? Absolutely. Is writing This Particular Article Right Now, while up to 4 million people are newly-disabled with Long Covid and struggling to get doctors to take them seriously, Maybe Not The Best Timing? Maybe Incredibly Irresponsible, Given What's Going On?

Read the room.
A distributed and persistent archive replay system using IPFS
> France and Switzerland both have universal healthcare

You said private healthcare/insurance were to blame. Switzerland has private health insurance.

Universal healthcare is a separate goal post. For what it’s worth, I’m unclear its comprehensive iteration is compatible with America’s immigration model. (It absolutely is for life-saving measures.)
This is the real solution to healthcare costs and quality. Instead of the government handing hospitals a blank check for low quality services in a single payer scenario, we allow price transparency, competition and the free market to drive down costs and increase quality. Hate him if you want, but this was a huge accomplishment by Trump that has just started to take effect.

If you think the government can bring down the cost of anything please see education and NASA for great examples.
Good advice tho…goats keep eating when they’re done with the lawn.
AWS Event Ruler
>They're mistaken or deluded.

Nowhere did I say "lying".
In 1995, I remember buying a Pentium PC with 32 megs of RAM. Gigabytes of RAM wasn't common until the early 2000's!
That does seem to be the problem
I hereby propose that we rename "unsafe-math" to "ucking-broken-math".
And automation. So long as you confirm that the automation is doing what you think it's doing.

Another comment mentioned an offline backup. And I agree. But it's also easy to go from having a month old offline backup to a year old to...
I'd like to use it for analytics. One issue I hit was when I was testing things out for that use I added a file to several pinning services and the result wasn't available via my node or the ipfs main gateway for hours.
Funny thing is this was the second time Stewart Butterfield tried to build a massively multiplayer game and pivoted the company. The first one was Flickr!

https://en.wikipedia.org/wiki/Stewart_Butterfield
Sorry, but I'm only accepting blame to the degree that I had the power to affect the problem. I'd love to train around the city, but until I'm elected dictator of trains and urban planning, it's not going to happen.
I think it's better if such archived sites are free for all to read, just as the site originally would have been directly on the internet. There's no good reason to hide it.
If only making laws was as simple as adding if statements in computer programs...

In the real world, you have millions of agents try to game every law and bend it into their advantage in some way.
That is not that interesting. It's something everyone realizes when they try make a budgeting app. Plaid decided to break the rules to create a product. They collected end users authentication details and pretended to be them to scrape data from financial institutions.
As with everything it touches, it's the intrinsic failure of capitalism (ofc success for the capitalists / bourgeoisie). It's the amount of capitalism that defines prices. In every other country the more healthcare is a public matter, the cheaper it is for the people.
> Not to mention chromium is open source. Anyone can fork it, like Brave in FTA.

I don't think you understand what a fork truly means. Blink, the web browser engine used by Chromium is a fork of WebKit. WebKit and Blink are now completely separate browser engines made and maintained by different companies.

Meanwhile, Brave is a skin on top of Chromium. They've patched Chromium to their liking. You can read the first paragraph in the link to confirm this.

People are really underestimating what hard forking a behemoth project like Chromium really means. I don't think anyone besides Microsoft has the capability to do it and they've already given up on that prospect.
It's a bit of a difference, but many of them are which is exacerbating the problems is that everyone who can in some of these places are leaving for other jobs.

But the difference between the EMT scenario is that there is that there is a potential that by getting involved you may not go home to see your family that night. In addition if you get involved and something goes wrong, you're going to be the next police officer on the news for "police brutality" and the rest of your life you'll forever be in fear of your life even if you did everything right. Furthermore the job of the police is not to protect citizens or stop crimes the supreme court has ruled as much, the police are an investigative force.

With the DA angle makes it even worse, because you spend the time and effort to arrest somebody and then they are back on the street a day later, what's the point in the first place. To put it other terms let's imagine for a second every day your boss took all the code you wrote and deleted it all, deleted all the backups and everything else, are you going to continue putting your best effort into coding, are you going to make sure the code compiles and the unit tests past? No you're going to do just enough to not get fired.

We can argue it shouldn't be that way but that is the reality of the situation, it turns out when you demonize a large group of people simply because they do their job, and criticize all of them as inhuman monsters and tell people that every single one of them is a bad person they start to lose some motivation.
https://blog.1password.com/1password-8-the-story-so-far/

Common rust library code with platform specific UI code.

Native UI code for Android, macOS and iOS. The app is Electron based on Windows and Linux for the reasons they give in the article.

Article from a year ago, so maybe outdated.
Even the Intel 4004--widely regarded as the first commercial microprocessor--had a 12-bit address space
Peter Eckersley – Computer Scientist : https://en.m.wikipedia.org/wiki/Peter_Eckersley_(computer_sc...

Peter Eckersley's Homepage : https://pde.is/
For context: "This contract is part of NASA’s High-Performance Space Computing project". I used to work with the HPSC leads and paid attention to it. This is one of many parallel threads for next-gen computing, including snapdragon and others. Yes, it will be rad-hard. That was a program requirement and is mentioned in the press release. As such, it fits a particular mission profile.

There is no existing compulsion for missions to use HPSC. This is a technology development program seeking to meet the requirements of missions. It's great news they converged on an architecture!

As part of their development, HPSC folks will seek mission partners for tech demos. Then, missions will voluntarily (or with some light compulsion) adopt the technology based on the growing heritage and mission need.
dang, you are awesome, and I appreciate your efforts at keeping 4chan and Reddit away...

but IMHO his comment is not really flaming, especially as it wasn't a combative response.

[A quick look at his other comments implies he is not a troll, though a bit pessimistic.]
First off – nobody, not even me, is claiming that San Francisco spends a small amount of money. However you're not comparing like for like here. The San Francisco expenditures are a combination of factors including high cost of living, high level of infrastructure and social services, and state funding. Honolulu is expensive mainly because of the Jones Act, not because they're providing a particularly high level of services. If you check out Ballotpedia you'll see that the states chip in a much smaller portion of the expenditures in San Francisco and New York than they do in the other consolidated cities.

On that list Philly comes close with transit but SF and NY are far, far more comprehensive. Muni's goal is that every SF resident is within a quarter mile of a stop that's served for something like 18 hours a day. Honolulu? lol. Denver has about the same number of library branches as San Francisco and a tenth the number of items in circulation. San Francisco PUC (which oversees water distribution and some power generation/distribution) is part of the city government, Denver Water is not. Two of the most prominent museums in San Francisco are owned by the city and run in a public-private partnership. The San Francisco War Memorial and Performing Arts Center is publicly owned (and one of the largest in the nation). Meanwhile Denver's opera and museums are an entirely private affairs. San Francisco's botanical gardens are owned by the city and county, Denver's are owned and operated by a non-profit.

It costs more to do more, and I'd venture to guess most residents prefer it that way. It's not all hurr durr homeless people taxes poop bad big government scary yahtzee.

https://ballotpedia.org/Analysis_of_spending_in_America%27s_...
Has any individual been arrested for a crime yet?