skysight-inc/HackerNews huggingface dataset:
1 mostly applies to update heavy tables since index only scans use the visibility map, which would be frequently invalidated.

3 is definitely true, especially the larger the table. I've had success splitting frequently updated columns out into their own much smaller table, or any other trick to concentrate updates into a small table. Also MVCC bookkeeping requires updating pages, so an UPDATE that doesn't change any field and SELECT FOR UPDATE will cause the same problem.
> The other didn't, didn't, and doesn't.

That French test was of physical controls, not subtle customs coding like the wine example. It's like the difference between an integration test and beta testing. Of course there will be issues, on both sides.

And on a more theoretical level, if the EEC had continued as-is and hadn't transformed itself into a political union then we probably wouldn't have had Brexit. So who's to blame?
Amiga 1000, 1985. Nothing else like it at the time.
Awesome project thanks!

I did a dual indoor/outdoor homebrew weather/air quality sensor at the beginning of last summer. Very useful during the smoke season. Wayy less polished though!

https://partofthething.com/thoughts/weather-and-air-quality-...
Linux Foundation and Blacks In Technology Foundation open up 200 scholarships
NASA Mathematician Katherine Johnson Dies at 101
My (english speaker) laptop's hostname is "rabotnik" for just this reason.
Totally depends on how you shard. In my case (b2b), i'd be sharding by tenant. Having a single tenant go down would not have the same impact as every single tenant going down.
I think there are enough people who care about the organizational structure of the company to make it profitable. My whole family, for example, refuses to shop at Walmart because of their advertising practices and the way they treat workers[0]. The products are the same as at other stores and usually less expensive, yet they will not shop at Walmart.

For this co-op to be successful, it doesn't matter what most people think, just what enough people think.

[0]: We had a family member who worked at Walmart who told us about this.
Slack calling doesn't work on FF as well. This + Teams + Zoom is a big gap, especially in these COVID times.
I used to work with some guys who were really into kickstarter. It seemed about 50/50 on if the stuff they funded turned out to be complete vaporware. Some of the stuff they got was pretty cool though. I got the impression that some stuff never shipping is part of the deal with those sites.
Java is not a good type system at all - Haskell is.
Are you familiar with Sundance? Every year there are movies there that receive lots of attention and praise only to completely disappear from public consciousness. Being well liked at Sundance is not necessarily a recipe for either financial or broad critical success.

Here is a list from Variety of the the favorites for this year's best documentary feature Oscar[1]. The Dissident comes in at number 22. I can almost guarantee there are documentaries above it you haven't heard of. This documentary wasn't going to be a mainstream hit and it doesn't appear to be a serious contender for awards. There is little incentive for a streaming company to purchase it.

It is also worth noting that the issue with Hasan Minhaj's show was specifically it being viewable in Saudi Arabia. That is a very different issue than purchasing rights to a movie in the US or other global markets.

[1] - https://variety.com/feature/2021-oscars-best-documentary-fea...
Except that valuations alone can be decisive in shaping the fate of companies

// What does this mean for GameStop? Because of traders’ bullish sentiment, a previously failing company is now in the position where it can leverage the overnight increase in value to make real, substantive changes to its business. GameStop can pay off debt through the issuance of new shares or make strategic acquisitions using its newly-valuable shares. [9] A struggling company could become solid simply not because of a change in the underlying business, but because investors decided it should be more valuable. //
You're right, I know at least one pilot that's crashed due to torque steer. Electrics should have less torque steer due to a great deal less rotating mass, so there's that.
I missed out on that deal too. Guess things get hit quickly when put on HN!
What I have learned about data viz over the years is that it is a very powerful solution to problems, just as Nightingale's diagrams demonstrated the effect of hygiene, which changed how societies and governments respond to epidemics. What I have also learned is that a solution obviates a dynamic someone thinks it is their job to manage, and a visualization that solves a problem is its own problem.

The "best," diagrams show change over time, and provide the presenter with a way to demonstrate how they are the important pivot point that optimizes and drives that change. The "worst," diagrams are the ones that illuminate the problem in such a way that it is no longer difficult, which humiliates the people it was presented to and designed to help.

I recommend using data viz privately, to reason through and solve problems quickly, and then use the time you save for self investment. The real value I think is to use data viz not as a product for productivity, but as an arbitrage tool for leverage.
Doesn't DV360 default to using IDs or cookies etc for targeting today? Those are user known identifiers. I am trying to wrap my head on how FloC would be used by advertisers since the world is not all FloC enabled and cookies are still around.
Oculus Rift - The Climb specifically. Put my hand through a drop-ceiling.
For some reason Firefox absolutely cannot play 720p+ 60fps videos on YouTube for me, whereas opening the same video on Edge I can play 4K 60fps videos without a single problem.
>And prove that your input validation is correct for every possible value

You don't need to check against every single value, you just need to check formatting, length, and data ranges. For your integer overflow example, you made 2 mistakes already, first is that anything that is expected to be positive should be unsigned integer and secondly, when you parse the string, you fail to check against max integer value.

>Unless it's unicode of course

Then validate unicode, lol. All this stuff has defined rules. Furthermore you design your code not to support unicode, and then someone inputs a name in non ASCII, the request will be rejected, which is a much better issue to have security wise rather than blindly accepting any and all input without validation.

>This is provably false though

Based on what, an opinion of some programmers? Thats not really "proving" anything. If you want to make a statement that most programmers don't understand things like why you should never rely on strlen, Id probably agree.

But Im not really concerned with distribution of skill within the modern programmers, I against the assumption that "you should not write stuff in C because its very hard to write safe C code".
You prove to still be misunderstanding. Firstly in that "Signal's Audience" is not a thing under contention - it's willing parties who are already both using Signal being prevented from using that tool to talk about [x] with one another. It's constraining communication by content once you've already granted someone the tools that is the problem.

Even so, I agree you have neither a constitutional nor a moral right to anything of Signal's in any case. And yet, the world would be a better place - for all people, Signal's staff and shareholders included - if they gave it freely. Nobody is obligated to spend their own time or effort to improve the world, but if we want the world to be a better place then somebody has to.

The more accessible unfettered communication is, the better the world is able to become. Full stop. Restrained communication is less capable of improving the world, because restrained communication is less capable of changing the world at all, because those invested in the status quo have incentive to restrain communication which could make change.
CSeries was on the few exceptions. Their train division flopped and was sold not a long time as I recall.
oil >> tanker fuel >> diesel >> kerosene >> jet fuel >> RP1 (rocket fuel)
Nope, I believe it also stops if you disable search hints. They send keystrokes to the search engines because that’s how you get the search suggestion when typing in the URL bar.
> My main argument is that the competency for writing C code isn't that much higher than for other languages.

I think that goes against observed reality, and the consequences of these errors are worse in unsafe languages. Look at heartbleed - a bounds-checked language would not have allowed that problem to be anything more than an exception, instead process memory was open for reading.
What if you change the search engine in Chrome and disable all telemetry? This is the comparison we should be making.
* ''Women armament workers'' (Linux Cookbook)

* ''Woman Blacksmith'' (Linux Networking Cookbook)

* ''Woman on Circus Trapeze'' (Network Security Tools)

huh! not animals!!
> and any solution that tries to deal with those just ends up being equivalent to what already exists: Delete and repost.

I'd love this honestly. Even if it was just a delete and repost under the hood, generally I find I want an edit button just after posting and noticing all the typos.

As long as the interface interacted like an edit form rather than have me copy and then rebuild the tweet I'd be good to go.
Ha, that’s fair, but a magazine-style model is only one way to go. Something like diminishing cost for adding additional subscriptions (with the discount split between the newsletters I subscribe to) would be effective in making me spend more there. (And probably abandon an off-substack paid subscription)
Apple TV isn't censoring this movie. It is still available on their platform. They simply aren't buying exclusive distribution rights to this movie. That isn't censorship anymore than them turning down purchasing a movie I just filmed in my basement is censorship.
It makes sense (for Shell) because a lot of streets and buildings in the UK aren't charge-point friendly. Add to that the outdated electrical infrastructure in many places: any more power demand would necessitate upgrading wiring from substations to streets.

What the real problem is though is that successive Governments have failed to properly invest in the right type of power stations, and I'm not sure if renewables could handle the extra projected load. See: https://www.gridwatch.templar.co.uk/
You may like to read up on Orsted (formerly DONG). Formerly a major oil & coal energy producer, now one of the largest global players in green energy. It continues to be a remarkably successful transition.
I suspect you're right that most users wouldn't pay, but I've gone to Red Hat's website many times over the years looking for a package that suits me and there's nothing. There's a segment of at least one (me) where they're missing out on some money for doing no additional engineering work.

I can get the workstation offering for $299. And then I can support free-as-in-libre software, I can run the same system my customers are running in production, and I get support that's probably better than Microsoft's. I don't really know what device issues I'm going to run into, though, and in my experience it either works or it doesn't - if I have a new wireless device they don't support, I'm under no illusion that my $300 next year will be the difference between them supporting it or not.

So maybe I'll get the self-supported option. But that's kinda steep - over half the cost of full support. Especially when one way to be confident about device issues is to go install the community distro (Fedora) for free and see if an old release works. If it doesn't, I'm not betting on Red Hat. If it does work... do I want to start this whole process over again, or do I just want to get to work.

Well here's another deal breaker: if I'm trying to run the same distro my customer's use in production, I'll have lots of virtual guests. No can do: my workstation license only permits 1. Let me get the server license and just install KDE myself. The self-support option only allows physical hosts. Let me get the next tier up. Now I'm up to $800 a year, and I, as a developer of software for Linux, am going to have a very unusual use case for them, I think. Should I commit $800 for 1 year of this? Does the server edition run KDE well? I doubt many people are trying that. Now I'm too nervous to cough up $800 knowing it only lasts a year anyway.

I could see myself buying a Lenovo laptop with Red Hat pre-installed and skip this, but I would want to be able to run more than 1 virtual guest with the same system - I'm not sure if Lenovo customers get special terms. Or... I can just buy a laptop I think is better from System76 and use Pop! OS. As long as there's something resembling CentOS or Scientific Linux or Rocky Linux for virtual guests, I can get close enough to my customer's production distro that this is still by far the most attractive option.
That's for sure, and more fringe interests would still be more informative than more mainstream interests, too. It wouldn't be as direct and therefore provides a bit of a barrier.
It's good when a company does it because they create value in the economy. It's only bad when a person does it because no value is created.
Gotcha. You might have point on the marketing stuff. This is literally our first meeting to organize so we need determine all of that as team in the coming weeks and months. Thanks for the input :)
the stock market is doing something useful in the real world.

the aggregate success thrown off by the stock market is a measure of the usefulness of the stock market.

participating in that is what enables to stock market to provide its usefulness.

so, yes, success on the stock market is a function of usefulness in the real world.
The courts were never given anything to hear. They can’t just go to trial on hearsay, innuendo, or wild speculation. You have evidence or you don’t, this isn’t like a court room drama where they decide to go to trial first and see the evidence later.
These groups should really just be using Secure Scuttlebutt. There's an already existing cultural affinity for them there, and they can have sovereignty over their digital existence.
Another common physics-breaking trope is inertial dampening. You've right about the prevalence of "exotic matter" too.

I get the psychological desire for this: that space isn't the massive tyranny of distance it appears to be. But all the evidence we have thus far is that there is a universal speed limit, as depressing as that might be.

Which, as an aside, is what gives me the most confidence we don't have aliens in UFOs on Earth.
I want to use firefox but I have a very stupid problem that makes it extremely annoying:

I have to use federation to login to slack. When Slack opens a page in the browser, that works fine, but then once I'm signed in it takes me to the web interface rather than opening the native client back up.

This isn't a tech support forum obviously but if someone had a hint of where to look, that'd be really helpful. I'm on ubuntu running i3.
That's probably Firefox's own Firefox Multi-Account Containers[0]. Groups caches/cookies into designated categories for each tab (personal, work, shopping, etc.), with smart recognition for assigned sites.

[0] https://addons.mozilla.org/en-US/firefox/addon/multi-account...
Instead of downvotes, I'm curious what evidence there is on either side of this claim.
♥ Mozilla.
It's nice to see some competition in this space, especially open source. I'm a little confused though I thought Singer was the open source version of Stitch (which you mention briefly): https://www.singer.io. But maybe Singer doesn't have all the UI features that Stitch does and that's where Airbyte is different? I would love to know more about the differences
They seem to respect their inflated salaries.
SQL and aggregated data: is there a better way?
Belarus and Pakistan have significantly lower death rates than the world average. Would you characterize those countries as having high collective civil will?

https://www.worldometers.info/coronavirus/#countries
Perhaps it's not that surprising that the curmudgeon with one foot out of the EU already decided to take the second one out as well.
I use both systems. I can’t remember on which system I saw it happen. Personally I’m fine with relaunching immediately the browser. I just replied to give the information asked, but it seemed that somehow it made some people upset. I really don’t understand how and why, tough.
What's funny is that they wrote the same kind of articles about Tesla while institutional investors were shorting it. Now that the short didn't succeed, Tesla became the good guy.

If Bloomberg wasn't already a billionaire, I would just write the classic ,,good luck staying poor''.
Wealthy couple chartered plane to Yukon,took vaccine meant for Indigenous elders
well there are some warts...

1. no multiline lambda function?
- breaks flow of writing fp code

2. default-arguments are 'shared' by default?
- have to 'break' this sharing by assigning 'None'...
- very unintuitive / I don't know any language that does this...

Anyway, not everything in python is 'pragmatic', and adding types is one of the first steps in going in the right direction.
>... unlike Amazon we aren't under same economic pressures as a typical VC or investor owned company.

I think it's a high bar to say that (a) the economic pressures faced by a typical VC backed company are the same as those faced by a typical investor owned company, and (b) that Amazon faces the same pressures as a typical investor backed company. Public company investors don't usually expect the kind of meteoric growth that VC's do, and Amazon has a long history of reinvesting in itself to the detriment of their profitability. Not the playbook associated with stereotypical public company economic pressures.
I'm planning a few encrypted long-term backups (ie. stick it in a temperature controlled safe for a few years).

What's the best medium for this? SSD or HDD?
When proponents of dynamic languages tell me "that's what the unit tests are for", I say good for you that you have unit tests.

However a unit test may simply inform you that you have something wrong with your program, whereas a type checker will (more often that not) show you exactly where the error is, and usually as you were typing it.

Reality is that unit tests and type checking both have their place even if there is overlap between the two. Type checkers can however remove the need for trivial and repetitive unit tests.
This is essentially a crowd-sourced Ponzi scheme. But is it really so different from the market at large right now? It's more clearly identifiable in that there are explicit signals in the message board. But the primary signal is probably the stock trajectory itself, just as it is with the broader market. People are buying mostly because people are buying, and the higher the price goes, the more sensitive it will become to perturbations, until something---maybe a tiny fluctuation in some obscure part of the market---causes it to collapse.
A good ad network's JS should be able to tell how long the ad was in the viewing portal, or for a video interstitial how long it played before the viewer skipped the end. That sort of signal could be useful, especially the way many sites use horizontal ad banners like horizontal rules in the pages.
If the default is to be opted-out, why would they even need to communicate at all with third parties? I'd say that it is bullshit.
Thank you. Obviously, I’m not on this Wikipedia list. :D
If there were 4 adults (and not 2 adults and 2 kids) with that amount of extra weight in the minivan, then you would see that they would be cutting it extremely close or be over for the maximum recommended amount of weight.

Besides, it’s not just the pounds that matter. Would you rather be hit by 200 pounds of hardness/sharpness/person bouncing to-and-fro or not be hit at all during a car crash cause that 200 pounds, whether object or person, was secured?
You need the temporary containers plug-in to manage it for you.

https://addons.mozilla.org/en-US/firefox/addon/temporary-con...
I absolutely love this "vintage" web design. The author's page[1] is very impressive and I love the atheistic. Wish more creative people in the industry would take design risks like this.

[1] https://ashleyblewer.com/
For those down-voting, I should have added this: https://bugzilla.mozilla.org/show_bug.cgi?id=1456885
The entire point of Airbnb was to let people rent out their spare housing capacity - it just became so wildly successful that people used the system to become pseudo-landlords.

My car sits idle 22 out of 24 hours a day. If someone else handled the insurance issues and found drivers willing to pay to use it outside of the times I utilize it, I'd have no qualms about lending it out for an appropriate price. The low end estimate for an Uber driver after expenses and Uber's cut is $8.55/hr. If my car averages half that it's $35k/yr that I don't need to do anything for.
That's a good question but I won't attempt to answer it for your case.
Ack, no, I want the behavior described in the link! I hate that chrome goes deep into sites :D
Show HN: 7 Days to Die Server Hosting
I'd like to see something like the firefox container extension automatically open a new container for every unique domain name. It could get tricky for eg. federated logins, so I'm not 100% sure what the implementation would look like. But it'd be nice to have the option.
In the current state of things sure, but what if we had a language or tool that made this a breeze? I would find this pretty cool.
The reality is more complicated than that. This line of "pro-Israel fanatics" goes back quite some time, albeit in different forms. Take British Israelism as an example. [0]

Granted, British Israelism would morph into an even more insane (and downright misanthropic) off-shoot, but you know, humans gonna human I guess. I think these attitudes about Israel have existed for quite a long time anyway.

[0] https://en.wikipedia.org/wiki/British_Israelism
This is going to happen a lot. I don’t understand why we are not simply increasing production and giving it to everyone who want the vaccines.

Especially so because this particular vaccine has cold storage requirements.

I am pretty sure that half of the intended eligible population is reluctant to take it. We can’t wait till outreach succeeds.

Latino farm workers who are essential are super suspicious. Until they can be convinced, are we going to keep delaying vaccinations for the willing?
I've found the Reject All button _more common_ in the last few months, but due to a lot of sites that have added it also adding a legitimate interests section which is seperate, to the point I'm less trusting of sites that have recently added reject all.

For all the hate that Yahoo gets for theirs (shown above), at least it does have a mostly functional reject all function, even if it requires two button presses (the end of the footer does tell you to go manually opt out of facebook/twitter).
I have always heard that Truvada (prep) was extremely effective at preventing HIV infection. These new injectables are reported by the article to be 89% and 66% more effective at preventing transmission.

What is this based on? Was I misinformed about Truvada's effectiveness? Is this a decrease in an already very low chance of transmission? Or is this in comparison to people forgetting to take their daily pills vs a shot that a health care provider had record of administering?

It's currently common in the gay community for sexually active, healthy people to take Truvada proactively to protect against HIV because it's understood to be even more effective than condoms. If there is a better option or if the current option is not as effective as widely believed then standard of care should change.
It's verified documentation
There is a free developer program (that's been recently expanded) that you should probably take a look at.