skysight-inc/HackerNews huggingface dataset:
> This syntax is not as commonly used as the one above

This is going to need some sources. Is it true today? And why did they put parentheses in the ON condition?

Worth nothing that there were variants of the WHERE syntax to support left joins using vendor-specific operators such as A += B, A = B (+) -- those are clearly deprecated today. [1] [2]

I have a really hard time finding any source on the internet that recommends using the WHERE style joins. So by extension, I wouldn't expect to be used much anymore except for legacy projects. MS SQL Server docs docs mention ON syntax being "preferred" [3], and MySQL says "Generally, the ON clause serves for conditions that specify how to join tables, and the WHERE clause restricts which rows to include in the result set." [4]

The PostgreSQL docs seem misleading and outdated to me.

[1] https://docs.microsoft.com/en-us/archive/blogs/wardpond/depr...

[2] https://docs.oracle.com/cd/B19306_01/server.102/b14200/queri...

[3] https://docs.microsoft.com/en-us/sql/relational-databases/pe...

[4] https://dev.mysql.com/doc/refman/5.7/en/join.html
How Bellingcat Launders National Security State Talking Points into the Press
The fact that Arkk's own website refers to itself as an active equity etf should prompt you to reconsider your definition of these terms.
I purposely put very little info on LinkedIn to look like a desirable employee and to avoid clueless people from looking for career advice from me.
Man charged with plotting to blow up an Amazon data center in Virginia
If I must have ads, I'd prefer not be tracked by hundreds of untrustworthy companies, and I'd also prefer not see irrelevant ads... This therefore seems like the best bad option...
It was a mistake to give an option to discuss this to start with. It's always if not this than that, x brand is better than y,etc.
What matters: is it a Windows/Linux/Mac shop?

No matter what brand,the base unit comes with enough RAM,
processing power and spacious SSD.

Everybody gets the same brand,as it's easier to support from the IT perspective.

Keyboard,mouse,monitors should be an individual choice. Some want to ruin their vertebrae by staring at a tiny 13" screen and be happy about it,while some need 3 monitors and 2 keyboards to feel the power,why not.

Not sure why some companies are so tight when it comes to the equipment for developers,as it's always a small fraction of the overall cost of the position.
what is clearer about implying the 30 posseses something? the post said 'low 30s', so to me that would imple 30-35, or even 30-33 if one wanted to call 34-36 mid 30s and 37-39 high 30s.
FLoC is new to me .. a quick check
Chrome Browser on a chrome-book shows

Federated Learning of Cohorts - Version: 1.0.6

Chrome : 89.0.4389.116 (Official Build) (64-bit)
Namespace is a site for peer-to-peer learning
It is a very similar feature to Apple Segments[1] already implemented in iOS on which sadly not a lot of documentation is available.

[1]: https://support.apple.com/en-us/HT205223
I don’t think that’s the real goal. The real goal is to remove cookies so that compares other than google cannot use them for tracking. Then google uses FLOC as a substitute; they’re the only ones who can use FLOC so it works out great for them.
A doctor dreams of moving to Canada
Django + PostgreSQL. That's it. The frontend is just server-rendered Django templates.
Georgetown’s Cultural Revolution
I mean it's a spectrum. If you put 100% of your wealth in SPY then you're actively choosing to disregard over half of the global investable equity market.

Asset allocation is another active investment decision.
So, FLoC is a mechanism for facilitating your being targeted by commercial propaganda, but not as accurate/personalized as other mechanisms by Google, Amazon and others. Am I getting it right?

But - if the regular, more accurate/personalized, mechanisms work in Chromium - why use the less-accurate ones?
Physical transfer doesn't really matter. Either you've incurred a debt (in which case they're legally required to take cash) or you haven't (in which case you're free to walk out of the store, leaving the ice cream to melt).

The store would need to require that you pay before the scooping began to avoid this, IMO.
> CSGO player will tell you the anti-cheat doesn't work, I know first-hand.

> It is in my opinion the greatest loss to gaming that a classic, legendary game like Counter-strike got completely ruined by lack of care by a company that profits millions off of the case unboxings.

have you played the game in recent years? this has not been the case for me or the people I play with at all.

when playing on high trust-factor accounts, cheating is basically eliminated.

the experience for newer players is pretty bad but once you convince the system you're trustworthy, the algorithm does an extremely good job of not matching you with cheaters.

what valve lacks in boring, sensible solutions they make up for with interesting often much more complex workarounds
(see: the open-world csgo danger-zone map shoved into a game with a room-based engine)
This is how I feel about JavaScript. I used to let the HN expert problem solving crowd show me all the problems and think of how bad it sucked. Now I’m happy it just worked most of the time.
Ask HN: Would you be interested in using the terminal for productivity?
Hi! My name is Joseph and I am a second year CS student. I basically live in the terminal and do everything there developer-wise, and I thought it would be cool if I build a productivity tool within the terminal, something like reading emails or sending files to people?

The Terminal makes doing things so much faster and easier when you know how to use it, maybe this would be useful to people in other industries to boost their productivity?
LSD and other psychedelics actually have incredibly low harm potential. They're usually at the absolute very bottom of any harm chart.

In fact, mushrooms and LSD are the two least harmful recreational drugs per the Economist chart from 2010. Number 1 is alcohol and number 2 is heroin and crack. Meth is a pretty distant 4th. [1]

They're not addictive, in no small part because they're not really "fun" in the classic way cocaine is. They're interesting, but you're really not in a hurry to do them again. Further, the LD-50 is really, really, really high.

[1] https://www.economist.com/graphic-detail/2019/06/25/what-is-...
I have three libraries supporting API 14, one app API 16 and another API 21. There's rarely a reason not to support at least API 21 for general apps. Almost only very specific and niche APIs were added after that. Not supporting at least API 24 is unreasonable and most likely due to ignorance. Java 8 is only supported since API 24, but everybody switched to Kotlin ages ago.
Sounds like he was running a sex work business?
It's an unfocused rant. He should have picked one target.

He mentions NFTs. Those are starting to worry me, because they may kill off the virtual world business. Two more crap virtual worlds were announced in the last week. I'm not going to name names, but here's some of the hype:

Blockchain! NFTs! Token presale! Golden Tickets! Rewards Pool! 20% Annual Return! Owned by the community! Upcoming VR Blockchain Conference!

Open for Make Money Fast now, actual VR world scheduled for Q2 2022. Vaporware.

There are some blockchain-based virtual worlds that already exist - Decentraland and Sominium Space. As virtual worlds to visit, play, or work in, they suck. "The metagame (trading land) is the game", one reviewer wrote.

Also, despite all the hype about these crypto-based virtual worlds being "decentalized", few if any let you run a server. That would allow others to create land, breaking the monopoly of the promoter. Most of these have very limited land area, both to pump up the land price and to minimize operating cost.

Something that's not well understood: NFTs are very pumpable. Because each one is different, there's no real market price. A few fake transactions can push what seems to be a price way up. That seems to be happening now.

It's not like you can actually sell something at that price. With a fungible item, such as a stock or a currency, there's a market, a market price, and some buyers. In those, you can't keep the posted price up unless you have buyers This time-limits market manipulation for fungible items.

NFTs, like collectables, lack that property. NFT markets don't crash, they become illiquid and stall. You see high posted prices, but nobody is buying. Look at collectables on eBay to see this. You can still try to trade Beanie Babies there, but see how many have zero bids.

The real reason for NFTs is that, not being commodities, they are not regulated by the CFTC, and not being securities, they are not regulated by the SEC. So hyping is legal.
You're right that the future of deep space communications is optical. There's a forum on Reddit:
https://reddit.com/r/lasercom
Can you expand on how Brave is an ad network?
I've met and worked with quite a few engineers who aren't comfortable working around women. They're typically very dismissive of them. Some conversation topics that surface these kind of details revolve around their experience with diverse teams and their opinions on meritocracy.

Again, as I said in a separate thread, I don't have a standard checklist of questions and just go with the flow of conversation.
Definitely sounds sketchy, though it still sounds more legitimate than MobileCoin. At the very least Akoin has a timeline of when all the coins will be released, something MobileCoin has so far refused to give.
True, but it's entirely voluntary:

- clamp(a, b, c), where a, b, c are all l-values would copy everything. Not destructive by default (but wasteful on "big" types).

- clamp(a, std::move(b), c) would potentially destroy b, but that's something the caller explicitly opted into.

- clamp(a, T{ something }, T{ something else }) would be an implicit move, but nobody is going to accidentally use those r-values anywhere else.

The non-const ref version returning is not something I quite like either; it would make more sense to me to have `void clamp(T& x, T const& l, T const& h)`, where the semantics would be more like `x.clamp(l, h);`. But to retain the same API I returned the reference.
I suspect as much, but I'm trying to see if that's just speculation or if it's a conclusion I can reach given other factors.
Push notifications aren't just for humans. They can be used to push messages to service workers that for instance, might sync local data for an offline mail client. This is a really big deal for PWAs. PWAs are a lot like electron, except they do not include a separate browser runtime, they just use your existing browser, and are managed by the browser.
It's both relieving and stunning how accurate this is to my own experience. I did TERRIBLE in high school (and college) math, almost entirely because I would constantly make little mistakes in the basic arithmetic. The broader concepts? No problem. But then I'd try to do a problem, slip up a few times on the basic math, and get the wrong answer. And there went the points (and test). I took to calling it "Math Dyslexia," although they're only really similar in that both involved unusual last-mile problems rather than fundamental knowledge or intelligence issues.

I suspect you won't reply, this being a throwaway, but was there any ADHD involved? That's what I've gradually settled on for myself, not the "bouncing off the walls" bit, but the bit where you have trouble focusing on anything but the things that are "interesting" to you (and then HYPER focus on those things).
We use a few of those. They are closer than Wordpress to the requirements of a custom template and/or a flexible content model. They’re also architected in a way that makes modern dev workflow easier (e.g., they don’t store full URLs in the database) and making architectural decisions to support static hosting and CDNs is more reliable and flexible. As we do custom development, generally, Wordpress increases the budget or reduces the quality and longevity of the final product. We would only use it if required by a client.

For time-limited DIY or clients with no budget, though, Wordpress with a $50 theme is often the way to go. There will always be a large group that can’t move to systems that require more design and development knowledge.
Huh?

ON is required by the syntax. Why start every line with a keyword that describes the line except the ON portion of a JOIN? It's inconsistent and has no clear benefit.
i just started going thru some elixir/phoenix tutorials and it looks esoteric and interesting.

i hadn't really considered whether or not it was an 'alive' ecosystem because i was not considering building anything real with it/them.

but i did have a thought -- let's say Erlang/Elixir -- it's super-duper great, in part or mostly, because it has some insane parallelism/comm/microservices/threading/etc. model.

could we not just 'bolt on' a new language?

so, typescript 'transpiles down' to javascript/ecmascript/something.

scala runs on the java jvm.

can java run on the erlang jvm? or python?

maybe create a typescript-for-erlang?

maybe it already exists and it's called go/rust/etc.
Try using the full text search feature of your database?

Otherwise you could use something like Algolia.
I talked to him about it when I met him 10 years ago and was much more optimistic then. As far as I know this isn't any closer to being on the market now than it was back then.
Who said anything about abolishing cash or requiring the blessing of a third party?

All I said is to have a right to be able to exchange cash for prepaid cards, for places that only accept cards. And to be clear, that should be a right that doesn't require any third-party "blessing".

Obviously, if you can exchange cash for a card, then cash still exists as legal tender.
Google (and a small number of other companies, notably Facebook and Amazon) are also able to continue "traditional" profiling due to their extensive first-party traffic / backend integrations.

If FLoC goes as they plan, there will be less tracking overall, but the tracking there is will be considerably more centralized, less technically transparent, and cement incumbent market advantages. (All totally coincidental unfortunate side-effects of Google's concern for your privacy.)
Lsd and mdma build up tolerance quite fast and have crosstolerance between each other. Also, almost zero people take lsd and drive. And lsd is anti addictive in general.
Interesting, didn't know that. In that case then how does it identify a cohort in a useful manner? Surely websites will need to temporally tie together the values to be able to target ads?
You’d like Craft if you like Statamic. There’s a lot of overlap between their developer and user communities.
>Companies can either spend more on recruiting fees, or more on better devs that will try to get their friends hired...

Yup, half of the team I'm on is made up of people who have worked together in the past and are good. That's how I got the job and how I get all my gigs. I haven't had to really interview for a job since 2002. LinkedIn is entirely unnecessary when you have a large enough network of people who enjoy working with you. The jobs come to you.
You don't have to have ads at all. The best option is an adblocker, and a non-Chrome-based browser.
Good to see Brave sticking to their privacy guns. FLoC is a brazen attempt for Big Ad (aka. Google and its ilk) to keep their spying-on-users gravy train going, now that GDPR and similar laws are making their old methods illegal (without consent).

No one wants to consent to being spied on, so FLoC is circumnavigating the GDPR consent requirements, letting them spy on all Chrome-users without consent.
Opium goes back thousands of years to. Honestly I don't know how it came to be demonized.
Sports bookmakers will ban your ass if you look to be any kind of sharp, or engage in arbitrage (exploiting their slow pricing).

Casinos wont let you put a billion $$$ on red or black just because they have a 1/37 edge on the roulette wheel. That variance is to high.

There are failure modes
The recursive irony here is that Alphabet implemented FLoC to put a moat around tracking adtech, and Brave consumes Chromium for its own means of generating revenue from vending a browser (BAT), so of course there’s no reason to propagate FLoC.
Linux md-raid supports LSI MegaRAID drives just fine.

https://askubuntu.com/questions/1310586/megaraid-lsi-raid-to...
Anyone know what network it'll run on?
I would love to switch from tmux to dvtm + abduco, but dvtm doesn't have 24bit/truecolor support.
Bad Voltage did a good show recently dedicated to FLoC.

https://www.badvoltage.org/2021/04/01/3x26/
I agree but sadly I don't see something so dosage-dependent ever becoming mainstream. Another GABAergic in a similar vein might have a better chance.
https://brave.com/brave-ads/

Company Overview & Core Offering

Brave is the first global digital ad platform built for privacy, offering advertisers the opportunity to participate in a premium, brand safe, and opt-in ad ecosystem, designed for a future without 3rd party cookies.
How to actually test web UIs
I think the issue is that drinking is about far far more than simply getting drunk.
Game companies literally think they have the right to own your machine. This is the kind of garbage they force gamers to install on their machines:

https://www.theregister.com/2016/09/23/capcom_street_fighter...

https://mobile.twitter.com/TheWack0lian/status/7793978407622...

Their software also takes screen shots, walks the file system, scans people's processes... Any similarities to malware may or may not be mere coincidences. They're also known for false positives: banning people for receiving special strings via text message, unknowingly installing mods with hacks bundled in or due to the presence of development tools such as debuggers or even virtual machines. Good luck trying to reverse such a ban, the entire gaming community has already been conditioned to accept any decision as final and to even defend this practice. When coupled with DRM, this essentially means your license to play the game has been revoked with no refunds.
1. The more accurate ones require a cookie banner.

2. The more accurate ones are going away.
The weird thing about tackling these seemingly Goliath type problems is that at the start it requires a lot of patience to get going and can be demotivating to see no progress or trickle-slow progress, but once you visibly see that the gears are starting to crank, it is very rewarding.
So I'd imagine it has "linear-like" ownership?
The documentation is stellar and it makes Dream looks accessible even for a non-ML'er like myself. I also liked how you introduced HTML through preprocessing.

I wish F# would take a similar approach. Nothing seems to come close.

OCaml on Windows seem to only run under Msys or cygwin. Do most OCaml devs develop on Linux?
I’m with you.

Story time: Years ago the Signal app would silently wake up in the background, upload 20MB+ of my contacts’ photos, and then shutdown and do it all over again every time I received a silent notification. Due to my membership in a few large groups this was very often. The result was gigabytes of cellar data usage in a week.

Fortunately my experience was rare because I both had a lot of contacts with photos and I ran the desktop app. But it was infuriating to track down and it made me realize that silent wake ups were even possible on iOS. (Or used to be)

I don’t know what the right balance is, but I think there should be some middle ground.
Can you point to a specific video? I watched livestreams as it was happening, and have seen a lot of the Parler videos.

My impression both from the videos and from right-wing twitter in the lead-up to this event, is that some q believers thought that various government and military leaders were going to step in, expose, and arrest members of the "deep state". Some of the more out there ones thought that the "deep state" leaders would be executed for treason. They're insane, as is par for the course in American politics, but weren't attempting a violent revolution. The rhetoric of "stop the steal" was wholly consistent with that of "the resistance".
Depends. There are sports betting platforms outside of the US that work like stock exchanges.

Betting exchanges can offer good liquidity, tight spreads and commissions as low as 2%
Why is this dismissed as poor reasoning? The only part that I might take issue with is the 8hrs/day as this might be a bit much depending on the project.
This post might give some answers [1]. FL is a machine-learning framework where models can be trained while keeping users' data on their device rather than sending it to a server.

[1] https://ai.googleblog.com/2017/04/federated-learning-collabo...
Towards the Science of Essential Decentralised Infrastructures (2020)
"Dependence of our society on digital infrastructures is growing daily, confronting us with an urgent task of building ethical and democratic alternatives to monopolistic big-tech platforms. We call upon the scientific community to put our talents to this challenge by creating decentralised infrastructures for trust-based economic and social cooperation. We empirically demonstrate that a public infrastructure to establish trust between peers in decentralized networks is possible at significant scale. Our work is based on over 15 years of improving our distributed systems which were used by more than a million people. We present six stringent criteria for designing trustworthy infrastructure, called zero-server architecture. Adhering to these principles, we designed a novel trustworthy networking infrastructure, called P2P-Apps. It enables smartphone apps to communicate without any servers, by forming a scalable overlay that uses our generic mechanism to build trust between peers, Trustchain. P2P-Apps are generic and can be expanded to serve as an alternative to centralized infrastructure owned by Big Tech."
Did Rubin keep project managers for this activity or did Page fire the Android ones too?
I wonder how long, before Google sabotages Chromium to hurt Brave and other downwards forks?
Multiple New York Times Staff Previously Worked for CCP-Controlled Media: Report
In light of this news I vote we never allow anymore New York Times posted to this site.
Is there some established definition of “sex ring”?

Ring:
a group of people drawn together due to a shared interest or goal, especially one involving illegal or unscrupulous activity.
"the police had been investigating the drug ring"

could we maybe be a bit more specific? Is the claim that this was a “prostitution” ring, which would be illegal, though possibly not immoral unless there was coercion? Or was this just a group of people having “sex”, which I believe is still legal in the United States?
Google the phrase kill sticky for various snippets of code that can be placed on your bookmark toolbar.

In practice, you end up needing at least two or three different buttons to handle different sites. The one I usually use is

javascript:(function(){(function()
{var%20i,elements=document.querySelectorAll('body%20*');
for(i=0;i<elements.length;
i++){var%20p=getComputedStyle(elements[i]).position;
if(p==='fixed'||p==='sticky'||p==='-webkit-sticky')
{elements[i].parentNode.removeChild(elements[i]);}}})
()})()
The issue with this is that the US simply don't have enough population density in their urban areas to make this convenient. Train is only convenient if you don't need to drive to the station beforehand.
Remember the TV ads regarding telephone calls and collect calls?

"You have a collect call from ... 'we-had-a-baby-it's-a-boy' ... do you accept the charges?"

"No." [Hangs up]

"Who was it?"

"Jimmy and Susan. They had a baby. It's a boy."

[Buy our better value telephone service!]
Right, but if you've taken possession, you've definitely incurred a debt. If they've scooped the ice cream but haven't handed it to you, while there may technically be a debt at that point, I expect most stores would just throw the ice cream out if you insisted on paying with a payment method they don't accept.