skysight-inc/HackerNews huggingface dataset:
I suspect the latter, but also the limited win.

In practice indexes are rarely used for sorting. It's almost always more profitable to use an index for filtering on the first table, and some mix of predicate pushdown (for hash and nested loop joins) and key lookups (for nested loop joins) for joined tables. And if a merge join is applicable, it's probably on PK/FKs and not on your presumably semantic sort order. And most of the time, the set of rows responsive to a query is small enough that not using an index for a final sort isn't a big deal.

Where an index is profitable for sorting is when you're doing pagination over a mostly unbounded set of rows, potentially with a predicate that matches on a prefix of the index you're planning to use for the sort. The plans for these queries tend to be fragile, you need to take care when adding extra joins and predicates that they don't cause the optimizer to abandon the index for the sort.
Monopolistic synergies are not a legal reason for anything. This is what people imagine the law is, but it isn't.

> They can wield this power to force deals and push out competitors across their multiple business units.

The only way this would matter is if you can prove that they have some monopoly in any one market and use that monopoly position to drive up prices.

So if somehow could leverage their Windows OS as to sell games for 1000$ rather then 100$.

Microsoft does not have monopoly in any one market as far as I can tell.
Sync everything to Google photos -> Twice a year, do Google takeout and save it on a hard drive, throw hard drive in a fire resistant safe

It's cheap, easy and ransomware proof.
it’s there in the graphviz github repo.
Or Microsoft to buy Disney, which is probably more likely.
You'd think the "think of the children" gag has already more than served it's purpose in this world, but then stuff like this pops up...
Ever heard of EA?
How to undo a change or revert to a previous version? That sounds like a pretty fundamental thing that a user would need to do, yes.
I wish this was available for Python. Does anybody know what the Py-equivalent would be (if there is one)?
Spent roughly 1k on a nas system at home which gives me 6tb of redundant storage.

It's raid 0 (2x6tb) with 2 separate backups done nightly/weekly, one in the house and one done in the garage.

The speed of access is unmatched to any cloud system, in the long run it'll be cheaper than online (assuming £10 per month for 6tb of storage).

I made the plunge after trying a few cheaper options plus cloud. I'm happy with the investment and haven't looked back, it's been rock solid. Synology.

The same system could probably be had for less now, the nas box also acts as my docker server which has been running without issues for 2 years. Most importantly it's not a full time job maintaining it, I spend maybe an hr a month if that checking up on it.

Comes with duplication detection and everything you'd need without learning shell can be done using the nice gui. It's just nice having a system anyone can use, no shell scripts in place at all. It just works.
Wonderful initiative! Thank you, Mr. Muffett!
Good. It uses cookies so that one can't simply vote any number of times. Certainly useful.

Have a button to share results over whatsapp.
Congrats never getting into a time consuming git mess, but I do sometimes. This is a very rare event. Recently I tried changing the committers email (each commit has a name and email attached) but that commit was already pushed into the repo, and I could not recover from the resulting mess. Even had to delete my github fork, and fork again. Happens about twice a year, while I used git commits many times every day.
Overwatch league is kind of hosed right now because of the weird shenanigans around OW2. Last I heard, they were planning on dropping team sizes by 1 (so a bunch of pros are getting fired) and they also planned to have next years league play the unreleased OW2 beta (??). It’s in a weird place.
I'm new to git. For now I use it from VSC, but I should probably give CLI a chance.

I must admit that I'm at the point where I shrug, delete and clone the repo if I'm stuck. Some errors and messages were to cryptic to me.
Here's hoping the Battle.net client doesn't get merged into the abomination that is the XBox gaming app.
Exactly. Free will (or lack thereof) is an untestable theory, better categorized as a thought experiment or philosophical debate.
The often mentioned design paralysis of choice between elements and attributes - in JSON there can be many ways to implement a collection of name/value pairs. One interesting case is compound key: you can use a mini serialization format and still make it an object (actually saw this in the wild).
And now you know why they fired dozens for harassment yesterday. Cleaning house for the new owners.
I read that a few years ago and enjoyed it. It felt surprisingly modern; but then again quite a lot of Victorian era stuff feels modern in spirit, like our own times it was a period of tremendous upheaval.
Indeed, I think Matrix state resolution has some CRDT-like properties. Afaik, the goal of this is mainly to manage room state across servers when using federation - but I'd have to dive deeper into this.

However, not all CRDTs are the same (actually, I think the definition is still somewhat vague - most things "eventually consistent" could be called a CRDT). Yjs is specifically designed for high-performance operations and has great support for rich-text collaboration. It also works great while offline - and you can connect different providers as you like (for example, store updates both locally in IndexedDB, and transmit messages over websocket / webrtc / and now, also Matrix). Definitely wanted to keep this flexibility.
I don't know the answer but I do see some things missing that could have helped assuming automation checks this though it may not

They say the domain isn't use for sending mail but it does have an MX record which means it receives emails. No problem, maybe automation receives emails. Some systems will use this to say that this domain is used for email even if just for receiving.

dig +noall +answer -t mx guerrillamail.org
guerrillamail.org. 3600 IN MX 1 mail.guerrillamail.org.

To tell automation that this domain does not even receive mail, one could optionally set:

guerrillamail.org. 14400 IN MX 0 .

However...

dig +noall +answer -t txt guerrillamail.org
dig +noall +answer -t txt _dmarc.guerrillamail.org

The above two have no answer. They are missing SPF records and DMARC policy that could explicitly state the domain does not send email. It should instead look something like this:

dig +noall +answer -t txt guerrillamail.org
guerrillamail.org. 14400 IN TXT "v=spf1 -all"

dig +noall +answer -t txt _dmarc.guerrillamail.org
_dmarc.guerrillamail.org. 14400 IN TXT "v=DMARC1;p=reject;sp=reject;pct=100;aspf=s;"

But those records do not exist. This is assuming some automation is in play here and very much assuming that automation checks such things. I have no idea if that is the case.

Email headers can be spoofed so I would expect multiple reports to come in from multiple noteworthy organizations before dropping a domain by a human. If their registrar are understaffed then it is entirely possible they are relying on automation for this.

The part I do not understand is why they are dealing with the legal department unless the reports are coming in from multiple organizations. Could their systems be compromised, sending spam and they don't realize it? Could the legal department just be going through the process but just want to get rid of a domain that is causing them to receive baseless legal threats? Anyway at this point if I were them I would unlock the domain, get the transfer code and move it to another registrar. If they refuse to give the transfer code then get a lawyer to make it clear to the registrar they won't give up.
There doesn't appear to be any clear proposals put forward. The goals under "Our campaign" are vague and high-level. How exactly can E2E encryption be done without putting children at risk, as they put it? This page at least appears to be silent on the matter. So it's hard not to come away thinking that this is just a "think of the children" attack on E2E encryption as a whole.
True, but that wasn't exactly welcomed either.
There's not likely to be any more mac x86 development from anyone going forward, and I think M1 is enough of a branch that it makes it difficult to justify it.
I've been vaccinated twice and my company will force me to get a booster. My second vaccination produced serious adverse side effects that lasted several days. Very scary. Are you going to guarantee that I'll be OK when I get my next shot? If I'm not, will you compensate me? Of course not. I have to assume all the risk because you think your strategy will help you survive.
Ask yourself where and when the Genocide convention applies?

Maybe only to select group of Western states. The UN is toothless, and international justice is just realpolitiks.
Free JavaScript Game Dev Book – Makejsgames.com
Disney? it own all the media and franchise IPs like Star Wars, Marvel...etc.
But that's not the case at all with Android and has never been. I don't think any of that would happen, the vast majority seems to stick with the default app store, while the rare technical user who wants to sideload has the freedom to do so, everyone wins.
> But are these things a normal user would need to care about?

... yes? I've used all three of those commands in the past, although I don't remember what they do. and I'm hardly a git expert.
No chance. COD has consistently been a huge money maker on PS and Vanguard was #1 last year. They would lose out on way too much revenue, not to mention that massive negative sentiment that would bring towards Xbox and big game / console manufacturers. I think certain games like Halo and maybe some Bethesda will stay (ones that have previously been exclusive). But acquiring a AAA company and then cutting off half of your customer base seems like a big mistep.
Text Classification: Transfer Learning vs. Zero-Shot Classifier
There's tycoon games and strategy too. Stardew Valley and Rimworld are at the top of their genres. And games like Dominions, Telltale games. Horror might be up there.

Do we count mods? DotA and CS would be indie if so, but are now quite commercial.
I can believe the introduction of frustrating DRM. But I can’t believe they changed all the characters’ appearance to fit to their new woke sensibilities. There’s no reason these give these guys your money.
The fallacy of false dichotomies. Things aren't either totally useful or totally a scam. That's what I'm trying to say, we shouldn't jump into quick conclusions one way or the other, especially without trying to really understand first.

I have my views on positive use cases for the blockchain and/or cryptocurrencies, and I got that by learning and building stuff with it. On whether the technology is a net good or bad to society, I don't know.

One can refuse to participate in anything without completely dismissing its merit. But that's the polarised world we live in :/
I would say that if there is anything Japanese, and many other asian big corporations, are known for, is consolidation.

Samsung, Toyota, Hyundai, Sony... They all are huge conglomerates spawning across multiple industries.
> Isn't a more common and general solution to the first problem to index the expression lower(email) (1).

OP mentions & dismisses it in passing before the proposed solutions:

> A query searching by a function cannot use a standard index. So you’d need to add a custom index for it to be efficient. But, adding custom indexes on a per-query basis is not a very scalable approach. You might find yourself with multiple redundant indexes that significantly slow down the write operations.
If a child wants to be "protected" online then it would be up to them to enter their actual age. But you are right, the government will take any excuse to get users verifying their age.
Yes there is ... https://europa.eu/europass/en/europass-interoperability
They need approval from shareholders and regulators in every country they operate in, and then do a bunch of legal work. It's not unusual for such big acquisitions to take years to be finalised ( for instance a regulator might impose divestment or limitations), or even to fall through ( e.g. Boeing-Embraer, Alstom-Siemens, Nvidia-ARM).
For well-designed projects it's not only possible but required.
I'd start with a trail camera. They are designed for outdoor continuous use and there are a variety of price points.
You're right that a lot of indie games are metroidvanias or roguelites. However, AAA games exist on an incredibly narrow scope these days too. You have shooters, sports, open-world action games, and that's basically it. Rarely do you see big studios deviate into unknown or experimental mechanics.

Indie studios have produced a lot of games with varied mechanics that are just a huge breath of fresh air for me, personally.

You'd never see a AAA studio making Factorio or Satisfactory, for instance. Probably unlikely to see them make a game like Darkest Dungeon, or Don't Starve, or Stardew Valley or Terraria or Starbound or.. the list goes on. You just might have to look a bit deeper to dig through the roguelikes and platformers.
Its odd that they are framing it as social media companies are now "starting to roll out e2ee"

All the main messaging platforms have some sort of e2ee, apart from gchat and FB messenger (that I know of, I'm not considering snap/insta/twitter/tiktok DMs)

Given that Facebook are going to outspend the government significantly to prove that they are encrypting and making your messages private, its going to be an interesting fight.
> Very scary. Are you going to guarantee that I'll be OK when I get my next shot? If I'm not, will you compensate me?

No to both, it's your choice not to get it and if it's that serious go to a hospital for an exemption

You already have a process in place for this stuff, if you aren't exempt there's no excuse

Those side effects really suck though, hope you're OK now
Diablo 4 on Game Pass definitely makes for an interesting value proposition. Maybe login will actually work this time at launch :p
This bodes very poorly for any nation that falls behind in the AI race.

Not really. The chance of any sort of aerial dogfighting happening in a war are next to zero. The cost of planes, and pilots, is so high that almost all the effort spent these days is on killing your enemy with over-the-horizon weapons fired from hundreds of miles away. AI-powered dogfighting in aircraft is military marketing.

A nation could develop world-class AI planes and they'd be absolutely useless against a hypersonic missile fired from mainland China or a Russian submarine, nor would they be any use against a guerilla army in Afghanistan or Iraq that doesn't have the capability to fight in the air or that has 30 year old planes that can be shot down with 50 year old tech. War has changed; making better versions of old weapons is a waste of time.
The Nintendo Switch waves hi...
Sure, but stuff like Call of Duty and Battlefield have hacks and cheats literally 2-3 days after release so not sure that part of the corp's intentions is realized either.
Back in the day sure, but the blizzard of 20 years ago is long gone. Diablo 3 is an abysmal followup to D2, every CoD is just an annual rehash, hearthstone is an absolute moneygrab, and HotS is the most watered down moba I've ever played.

Overwatch is cool though.

edit: and oh my god, let's not forget the absolute dumpster fire of warcraft 3 reforged.
Also endurance. Now you're only limited to hardware endurance and refueling capabilities rather than pilot fatigue --affording much better performance.
Well, consider that you could buy any kind of game first hand for $60, then after finishing it, you could be able to sell if and get some money back.

Today you pay $30 (for some games, but a lot are still $60, $80, etc.) Plus the DLC, credits, extensions, registration to an account no ability to sell it or buy second hand.

Game industry got pretty bad, I've enjoyed it in the past, and I have the ability to just move on and ignore anything game related, what I am upset about is that today's kids are squeezed and coerced in order to play anything, and that is why I wish we had governments trying to put a stop to the current gaming companies greed
This is the second big publisher they're buying recently, after Bethesda.
A mucher better explanation of git interals:

https://git-scm.com/book/en/v2/Git-Internals-Git-Objects

It is surprisingly simple and efficient. I am starting to think this Linus guy knows what he is doing.
In addition, I believe they have already announced they plan to continue support for other consoles/systems, and they definitely announced they support a PS "gamepass". Wouldn't be surprised if ABK would be included in a PS gamepass (Microsoft ultimately makes money from that).
>a pretty legitimate reason to shut a service like that down to me

Meanwhile physical cash is preferred for criminal acts. Would you similarly blame the issuer of cash for these crimes? What about footwear? Most criminals wear shoes or boots. Running shoes can be used to evade capture. Should we hold Nike accountable?

>does anything but benefit those with the most resources in the system. As long as that remains true, how do we expect it result in a more fair system than what we already have?

If fairness is the virtue we are seeking, then how does the plunge protection team protect fairness?

If fairness is the virtue we are seeking, then how do Cantillon effects factor into your argument?

If fairness is the virtue we are seeking, then how does a central bank formed by the blue-blood oligarchy advance this cause?

If fairness is the virtue we are seeking, then why does the central bank protect financial markets at the cost of all participants in the market?

(Pseudo?) Anonymity is what protects individuals from regulatory overreach and confiscations of wealth. True to the form described by regulatory capture, the IRS disproportionately attacks the income of small business owners vs. the super rich, who can afford to keep a small army of tax accountants, lawyers and lobbyists on retainer. Meanwhile the tax code grows ever more byzantine by the year.

https://en.wikipedia.org/wiki/Richard_Cantillon#:~:text=Furt....

https://www.mdtaxattorney.com/resources/irs-targeting-small-....

https://en.wikipedia.org/wiki/Working_Group_on_Financial_Mar...

https://en.wikipedia.org/wiki/Laffer_curve#:~:text=In%20econ....

https://www.marketplace.org/2015/10/20/how-secret-meeting-je....
A Crash Course in Good and Bad Control
Intel to Unveil Bitcoin-Mining 'Bonanza Mine' Chip at Upcoming Conference
Today I only play Heroes of the Storm from Blizzard... It's a nice alternative to other MOBAs, simple and fast when compared to. But I don't waste a penny on their store nor give any helpful feedback. I just play with my friends, and when we're done, that's it, logout and forget.
Counterpoint: It's gaming. It is a space with a low barrier to (indie) entry and it is not part of some critical infrastructure. Maybe it is lamentable, but I am not sure antitrust would be my way to go for this.
Anti-trust hasn't been about competition for decades. The current jurisprudence is that it's all about prices and so long as companies swear prices will go down there's not much stopping mergers like this.

On the positive angle for now at least Microsoft is the company I'd prefer to be buying studios because they're not locking things down to exclusives and are nearly giving games away on Game Pass.
Quick tip: Git branches are cheap. Like super-cheap. IF you want to create a safe point just before doing a tricky merge, just spin off a new branch pointing at the current commit:

git branch blah_branch_backup

Later, if your merge gets completely messed up, you can do:

git merge --abort

git reset --hard blah_branch_backup

That final command will restore the current branch's HEAD to point to the same commit as blah_branch_backup.

This same pattern is useful for other dangerous commands, like rebases or filter-branch.

When you're done, just delete blah_branch_backup.
> transaction must be committed to permanent storage before the client can be informed of success

Transactions must be durable, but that doesn't mean they can't be committed to RAM initially. There are large-scale database systems you have probably heard of that commit to RAM and get their durability from committing to multiple replicas in distinct failure domains.
Ask HN: What Mashups Are Likely with Activision Blizzard Microsoft Merger?
Examples:

Axolotls in Call of Duty

Minecraft Dungeons Diablo Edition
How do you visualize code?
Am I crazy, in that I actually like Twitter threads for this sort of thing--at least in the hands of a capable author? When threaded correctly (as this one is), its easy to follow. And the requirement to condense and split thoughts into tweet-sized chunks creates natural breaks to pause and consider the content before continuing. I find the cadence of "each thought is a tweet" provides a nice rhythm.

Sure, you can do this with paragraphs in a blog post. But Twitter works equally well in my mind!
> It is interesting that you insulate under the house.

I think anyone who's gone camping will appreciate the need for insulation between the ground and whatever you're trying to keep warm - a good sleeping pad is crucial for keeping warm.
> Would you make the same point about religious persecution?

Yes, if your religion caused you to harm people by just being near them because it is optional

Again, it's more false equivalency

Some religions require you to not even look at a woman that isn't covered, they need to go and live in an area where that's supported rather than expecting wider society to support that stupid standard
The remaining up to 40% is also mostly IRL: school, church, camp, neighbors' houses, and so on.

Going after online sex abuse while 90%+ of it happens IRL is like trying to solve climate change by targeting marginal uses of fossil fuel like motorboats while ignoring coal fired power... which... is something we also do.

You target the biggest things first. That's how you solve problems. For child abuse that means targeting home and institutional IRL abuse.
Amazing work. I think there's a whole host of apps that just store some small amount of data for each user that could work entirely on something like this.

Some nice things:

- Anyone can host their own Matrix homeserver, which can then sync its data within a federation, allowing users pretty fine-grained control over what data they share and with whom.

- Add end-to-end encryption, and it becomes even better: data stored somewhere in the cloud (i.e. the user doesn't have to manage a server), but the server knows almost nothing about what you've stored aside from some metadata.
> How many people are really going to care about a Valve system that can't run any of the popular games from the MS catalog?

So far, it seems MS is quite happy to put its games on Steam as an additional revenue source. Looking now, Xbox Game Studios has 49 games on steam, including its latest and biggest offerings, such as Halo Infinite and Forza Horizon 5[0].

[0]https://store.steampowered.com/curator/3090835-Xbox-Game-Stu...
Sounds like an amazing deal for Microsoft. Activision shares had it rough recently so the price isn’t that bad and ITS AN ALL CASH DEAL.

With inflation probably coming in a big way it sounds like a great idea to spend all that money now.