skysight-inc/HackerNews huggingface dataset:
2 points then;

1. Do you know SQL currently? Because your previous comments implied you don't

2. SQL is a bad implementation of the underlying relational model. And it's just bad in other ways. For one, it's bloody wordy:

select * from people

but as SQL is an expression language, why not?

people

From an answer of mine a few days ago (slightly modified here) to pick out differences:

(
select *
from t1
except
select * from t2
)
union
(
select *
from t2
except
select *
from t1
)

I'd prefer to write that crap as

(t1 \ t2) + (t2 \ t1)

or similar. If you write a lot of SQL, that matters.

SQL aggregates don't nest easily. Transactions are screwed up (https://news.ycombinator.com/item?id=23569513). SQL is poorly composable (https://news.ycombinator.com/item?id=23550420#23561301). For better or worse it has nulls therefore tristate logic. This causes errors! And more.

BTW. transactions don't work in the way you might think, atomically. Which is why MS added https://docs.microsoft.com/en-us/sql/t-sql/statements/set-xa... and I'm sure Pgres has similar. From the link:

"When SET XACT_ABORT is OFF, in some cases only the Transact-SQL statement that raised the error is rolled back and the transaction continues processing"

That peculiarity is from the standard BTW.

SQL is problematic. It could have been much better.
IIRC Apple doesn’t require in-app purchases for “physical” goods. Obviously a JPG of a barcode that lets me on a plane or into a movie theater itself isn’t a physical good, but I guess it’s in service of one.

There are a couple of exceptions though for digital goods (I think Amazon has an exception for their Video service, but not Kindle. People rumor this was part of a deal to get Apple TV onto Amazon Fire products.)
Update policies on Android (I want to use my phone until it is completely broken) made me start to look at Apple. But then I realized it is not an alternative.

In another thread someone compared Apple with a dictatorship and this is right. Maybe you will feel safe but there is no freedom. And when you don't do as the dictator pleases you are in trouble.

Companies get too big and too powerful. Some say this is the beginning of a new world order, like the industrial revolution changed how the world was ordered.
Hmm okaym I stand corrected.
That would be a stupid strategy for Apple, for a multitude of reasons:

1. Fighting it out in court, and then paying damages is probably going to be cheaper than 18 billion USD.

2. I don’t know if AppStore profits (NPV of discounted future profits) make it even worth 18 billion USD.

3. If they buy out Epic, they’re signaling weakness which is basically asking the next company to play the same game.

4. It just provides more evidence & impetus for those pushing for antitrust action.

There is technically a chance Apple might eventually acquire Epic, but if so, that would be driven by Apple seeking an interesting platform for its VR hardware, not to just close down this lawsuit.
internet is restored, for now. There could be some ways to bypass blocking (e.g. SSH tunnel via TCP works just fine, unlike all popular proxy protocols), needs more investigation. Until next time then :/
Gtk does use css, but not for the purpose of layout. Their layout rests on the same good, understandable and no-bullshit primitives (GtkContainer subtree) as before the time css-like theming was introduced. Gtk css solved a problem of theme engines (clearlooks, redmond, etc) which had to be done at low-level and thus were less easy to create or modify.
I disagree. I think the primary beneficiaries are the universities themselves and their alumni networks. Employers, particularly elite employers, know about affirmative action - and not just racial affirmative action. Job candidates are sometimes judged by employers in the context of advantages they might have received - employers are known to "unconsciously" penalize candidates who list diversity clubs, fraternities (legacies), and sports teams - three signals that a candidate may have received a non-academic boost in college admissions. In the United States, the right sometimes calls this effect w.r.t. race the "Clarence Thomas effect," as he famously struggled to find any law firms that would employ him, despite having a law degree from Yale. Many universities with affirmative action, including elite universities also have a racial gap in the graduation rate and average GPA exiting university - suggesting that some of those black C-GPA Harvard students (well, black C-GPA Princeton students, Harvard doesn't really give Cs) could have B or A students at Carnegie Mellon or Emory and had an easier time finding employment after graduation. So while some members of the minority group may benefit from affirmative action, I'd argue that many more members of the minority are actually hurt by affirmative action, either because they're forced to compete slightly above their abilities or because they're evaluated as if they received unfair advantages by employers after college.
> Apple 30% makes no sense

Apple provides useful services with its App Store: filtration and curation. The degree to which this is effective is debatable. But that it has an effect is not.

Apple also extracts socially useless rents from its App Store. The degree to which this exists is debatable. But its existence, given Apple's dominance in app industry profits, is not.

The first costs Apple in terms of labor, tools and research. The second is a result of their independently-profitable devices business. These costs are roughly the same from app to app, review to review.

One solution might be to charge a fixed fee per review. This scales perfectly with Apple's costs. But it's prohibitive for small players. A scaling fee structure relative to revenues promotes first movers, thereby keeping the app ecosystem fresh. Apple came up with a 30% flat rate. This made sense when apps made hundreds of thousands of dollars. It does not make sense when they make hundreds of millions.

A simple answer is a sliding scale. 30% for the first $20mm in a year. 20% for the next $40mm. 10% after $60mm. This is more than generous to Apple. It beats Epic's request for a 12% flat fee at $400mm. And it continues letting Apple give new entrants, who are both more sensitive to costs and more needing filtration and curation, a field to play on. As a bonus to Apple, it reduces the incentive for developers to litigate as a function of their capacity to sue.
Don’t force shit onto every Apple user. One app store is for security and privacy. Apple curates and that costs money. I don’t want my and my families and friend’s ios devices turning into the pile of hot garbage android devices. If you don’t like it, leave! Or make your own device to sell!
Install Linux Mint and be done with it
Here's a great video to accompany this: https://www.youtube.com/watch?v=yVdH_dYlVB8 The rest of this guys channel is equally as good, the animations are fantastic.
Excuse my ignorance, but why does there even need to be centralized stores at all? I understand that in the past the primary means of distribution was retail boxes, so studios had to have publishers to at least handle the physical aspect of putting games out in the market. Due to the wide availability of a fast internet connection, the mechanics of a game release is different today, and the primary means of distribution is digital.

Steam and its alternatives brought conveniences to the developers by providing easy advertisement, a streamlined way of delivering patches, an actual digital store to perform transactions, and also more recently started to serve as a major platform for the communities of many games.

I am not a game developer, but I guess that nothing that these stores provide is essential to publish a game and keep it alive, and any developer might simply put a site online, sell the game there, and allow me to pay directly to them. This is probably a niche opinion right now, but given any transaction involving digital goods such as e-books, music, software, games, etc. I am delighted whenever I see the content creator do this.

You may argue that this would limit the discoverability of games by a huge factor compared to them simply being advertised on the front page of some online store, and I agree, but I think if Steam had not grown to be as massive as it is today, that job would simply be delegated to the gaming magazines, forums, and many other independent platforms where the creators would more freely have a chance to promote their content.
Google Play is a competitor with Apple's app store at the level of being an important component in an ecosystem that you choose between. They are comparative.
This guy isn't looking for solutions.
> Also, it's worth mentioning that the layman discussion around whether Apple and/or Google fits the dictionary definition definition of a monopoly is a red herring. The government doesn't determine whether or not a trust is a monopoly based on that definition

I disagree. The market power test is an objective measure of exactly what the dictionary definition of monopoly is. The problem in lay discussions isn't the definition of monopoly but that markets in lay discussion are delineated by descriptive boundaries of markets rather than objective measures of actual competition like the market power test.
You think they’re going to stay that competitive after they monopolize everything?
Probably Google? Never seen a bad story of them on HN get traction.
I think the timing is very unfortunate. Shortly after Trump’s executive order targeting Tencent and ByteDance (hopefully with more to come) then Epic (heavily backed by Tencent) launch an attack against Apple.

Tinfoil hat on: Apple is probably worried that if Trump gets re-elected then they would be forced out of the Chinese market unless they allow third-party app stores where people can download the Chinese apps that Trump would force them to remove. Apple will therefore opt to allow third-party app installations (which would hurt them a lot if we ignored the Chinese market) rather than lowering their fees or allowing third-party payment providers.
The British East India company was a government actor. It’s silly to consider them otherwise simply because it was technically a “joint-stock company.” It was part of the government. Wikipedia even notes:

> Originally chartered as the "Governor and Company of Merchants of London Trading into the East-Indies"
The government funds a lot of services that are not yet profitable. ARPANET back when AT&T was convinced that packet switching would not work and would not be profitable. Space programs. Clean energy research. GPS. Weather. Subsidies for electric vehicles. DARPA funding Boston Dynamics. Medical research through NIH funding.
I just did. 202p Lenovo T490. Installed Linux Mint on all three of them, one for me and the rest for family members.

Everything works out of the box
Wow. This is extremely dangerous.
The future of SARS-CoV-2
I might be interested in easily playing Epic games on Linux, but their walled garden doesn't allow that.
Xbox Ultimate Game Sale Is Here, Buy Games at Discounts
> the concern isn't that users will jump ship from the App Store [...] but that developers will

What is the practical difference to you, as a user, between:

A) Not being able to install Fortnite because it's only available on a third-party iOS storefront,

and

B) Not being able to install Fortnite because it's not available on iOS.

If apps jump ship from the official store, you personally as a security-conscious user won't be able to install them. But if apps jump ship from iOS, you also won't be able to install them. So who cares if developers move off the official iOS store? Aren't they already free to do so today?

----

I'm going to go out on a limb and say the difference is that (deep down) we all know that Epic is right, and Apple really is one half of a duopoly -- a half that controls over 50% of the entire mobile app store revenue in the US -- and that it would be insane for an app like Fortnite to drop iOS. I think the difference between the scenarios above is that (deep down) both you and I know that Fortnite isn't really free to abandon iOS as a platform, and that the stranglehold iOS has over the market is the only reason apps like Fortnite are on iOS in the first place.

We know that given the choice, consumers and developers would both choose a more open device. And we know that the only reason the closed ecosystem works at all is because many developers and users don't have a realistic choice about whether or not to accept Apple's terms.

The reason people see the two scenarios I list above as different is because, yeah, all of us on HN do actually know that Fortnite doesn't really have the option to walk away from Apple devices, and without a 3rd-party store Epic will be forced to agree to pretty much any terms that Apple requires -- they have no negotiating power. And once we admit that, then it becomes a lot more obvious why developers are asking for some kind of regulation around app store policies.

If dropping iOS and supporting only Android or PC was actually a realistic, sufficient option for most developers, then you wouldn't be worried that they'd all jump ship the moment they had a 3rd-party store as an option on iOS -- those developers would have already left the Apple app store (and iOS) behind.
Not sure what assumptions are to be made by comparing this with US population by ethnicity except that they should be match up - which I don't agree with.

Also are Jewish people considered White in this case? I simultaneously see that they are referred to as minorities but also don't see them represented in statistics such as these when comparing ethnicity in X with ethnic population in the US.
My comment does and it’s even further down ;)
Google explicitly says in their policy that you don't have to use their in-app billing to pay for music.
Anti-clipboard-abuse doesn’t feel like a good example. It’s a generic (albeit new) OS function that scales immediately to all apps, once implemented.

The argument for ongoing App Store funding is that it has to scale with the number of apps available, each requiring hours of human work to review and police.
Worked nights doing what exactly? It seems that he only did the initial work of finding the customer.

My advice would be to look for exit path and walk away from this situation when it becomes possible. You can easily make more than $9/hr. on freelancing marketplaces once you establish yourself a bit.
What Makes Jio Different?
Under Apple's clarified guidelines, if a University put out a remote learning app to help students deal with the pandemic better than a browser solution, Apple would be entitled to 30% of each user's tuition.

Once they have a few slow quarters and pull the lever on taking a cut of app mediated real-world services, we may see 10-30% of each Taxi ride going to Apple.
That would be the smart approach, not too much money in it though.
The idea that a person’s country of origin, where all laws and political dynamics are compulsory at birth, is somehow equivalent to the luxury item that is an iPhone is... bananas. Me thinks you stretch too far.

Edit: ‘equivalent‘ should be ‘comparable’... obviously the OP is not saying they are equivalent.
Hi, it's me, I'm Fred
I used https://mycarguy-sf.com/ in SF and http://halo-motors.com/ in Seattle (latter are actually in Bellevue). Ironically both sites look like used car lots with very limited inventory but I discovered the former from a yelp search for "car consultant" and ended up buying a Mini Cooper from his lot. The latter was recommended to me by a friend whom Halo Motors helped find a semi-classic but I again ended up buying an underpriced Toyota from their lot.

A nice side benefit is that most of these mom and pop dealers will sell you secondary warranties at cost, which was a big deal when I was a first time car buyer with a post-BMW acquisition Mini Cooper with a CVT but I drove that car into the ground so it wasn't a consideration the second time around.
Yes, there are many things worth discussing which would be better left not written down.
You should consider quitting your job before killing anyone.
Most people want a secure device and are not tech savvy. Apple here is providing a service of a curated App store.
Of course it exempts real estate...
Oh okay. I thought those people in the streets were shouting something about reparations for slavery and what not. My bad.
> When I don't want to worry about that crap I use iOS

This is a false dichotomy. You still need to worry about that. Exploits for iOS are cheaper than exploits for Android[1], because exploits for iOS are so abundant[2].

[1] https://arstechnica.com/information-technology/2019/09/for-t...

[2] https://www.securityweek.com/zerodium-expects-ios-exploit-pr...
While I believe this is your experience, I don’t believe it’s possible for the average engineer in the Valley to save anywhere close to $2m over 8 years.
They failed because the efficiency was theoretical and never tested before in practical terms on real cargo sea routes.
Fortunately, $150k is not a joke to the many people not in your situation, which is akin to winning the lottery. I work remote for low six figures and it'd make a huge difference for me.
Curie temperature
It is explicitly stated in google policy that you can use direct credit card payment for music.
On Android you can install apps from third party sources.

It's a hassle to instruct users on how to allow third party sources, which is why Epic eventually caved to Google Play's demands, after distributing Fortnite outside of Play for a year or smth.

Still, it's not the same thing. In a situation in which Fortnite gets banned from Play, their marketshare on Android doesn't go to zero, and given kids are driven to have their game installed, one can argue that Fortnite would be able to survive just fine on Android outside of Play.

And your main point, that the platforms don't give a rat's ass on freedom, is childish. Yes, they don't, we already knew that. Still doesn't change the fact that one is unlike the other for developers, users and their freedom to do what they want with their devices.
I didn't post to show Apple is breaking rules. I wanted to show they were 'freeloading', the same thing they are accusing Spotify and Epic of . They aren't worried about 'user experience, security and convenience' here.

Google has a problem with games like Fortnite and PUBG, because then they would lose too much. Kids spend millions on Fortnite.
You just need one ML scientist for 4-5 software (or ML) engineers. If you wand to optimise time to delivery of products, you have much more to gain by improving the software engineering part, because regular SWE it's 90% of the product.

One of the main differences between ML in academia and industry is related to sourcing the training data. In academia they just use available pre-tagged datasets such as ImageNet, in industry you have to collect, clean up, organise, train, iterate with new data.
As grand-nibling comment suggests, it's primarily about vocabulary and definitions, but also how objects can be put together to form new objects. In combination, we end up with "universal properties", behaviors of objects which are the same in many different contexts.

If you want to get some surface-level mind-blown experiences, then there are some cool pages out there, in addition to the papers I already linked, which have great diagrams. [0] shows a periodic table which relates categories to truth values and sets, which is helpful for understanding what folks mean by "category theory is just as good as set theory for foundational work".

More mind-blowingly, category theory is "formally formal", which means that we can use category theory to formalize its own concepts. This leads to n-category theory. Because of this, we have tables like [1] which relate category theory's own building blocks to type theory and logic.

Category theory was originally the study of natural transformations. Any time that you find enough data to define a natural transformation, then that's interesting; the component categories are then also interesting objects of study. That's still what motivates its presence in physics. There are at least two other perspectives though, a logical perspective (a category is a deductive system for a formal logic) and a spatial perspective (a category is a topological space), and they're both rich as well. But the richest perspective is going to come after you've explored all three.

[0] https://ncatlab.org/nlab/show/periodic+table

[1] https://ncatlab.org/nlab/show/computational+trinitarianism
How much do you think Walmart, Amazon, Best Buy and friends mark up the products they sell?
It continues to surprise me that tech-literate people fall for Apple's privacy marketing when it doesn't hold up to the most basic scrutiny. You can't even install an app on your device without telling Apple. https://news.ycombinator.com/item?id=23796808
That sounds like you have a story to share. Feel like elaborating a bit?
> Under Apple's clarified guidelines, if a University put out a remote learning app to help students deal with the pandemic better than a browser solution, Apple would be entitled to 30% of each user's tuition.

I think they have mechanisms for distributing apps within an organization.
Absent that healthier economy it seems smart to at least root for the side which is not running concentration camps, USA's and Apple's sins considered.
Some news said that the tanker got closed to island to connect Wi-Fi. OMG.

https://www.lexpress.mu/article/381284/membres-dequipage-con...

https://www.news24.jp/articles/2020/08/14/10699738.html
> As an example, HN could start requiring users to link their LinkedIn accounts.

What about those of us without a LinkedIn account?
In technical terms, they're not even a duopoly.

Apple has maybe 25% of the market. I say "maybe", because that percentage is decreasing every day. Especially globally. The reality of the situation is that Google is killing Apple in terms of marketshare. And Apple is eating Google in terms of profit. It's a situation that is a bit unprecedented.
Why is this flagged? A working postal system is a required element of many YC companies.
And yet iOS exploits are cheaper than Android exploits, because there are so many iOS vulnerabilities.

https://www.forbes.com/sites/jeanbaptiste/2019/09/04/why-zer...
I think the most interesting part of this is ESP_8_BIT driving composite video from software using 1 output pin.
Very interesting comment.

The statement was written with the lens of very different goals (corporations maximize profit within the context of selling goods and services where governments - usually, serve the people sufficiently to maintain control & power over its people by being “great leaders”).

Corporations usually sell goods and services, but do not have control over individuals most fundamental rights including those of freedom, health or even life - like governments often do. Corporations also rarely have militaries nor are the final backstop for when disagreements occur.

Your example is interesting because it compares probably the most government like corporation to ever exist (the Dutch East India Company) and the most “nurfed” head of state by most metrics to ever exist (I.e. the least powerful relative to power of the nation - the American President, while being the head of the largest economically and most powerful country, role by role is quite restricted and limited in scope and control by design of the founding fathers).
Legal Compliance and Taxation Outlook of America
Web Application Firewall Installation, Configuration, and Best Practices