skysight-inc/HackerNews huggingface dataset:
Silent truncation only occurs if strict sql_mode is disabled. Strict sql_mode has been the default since MySQL 5.7, released over 6 years ago. All prior versions have hit EOL support, so there is literally no supported version of MySQL which has this behavior out-of-the-box.

The topic of MySQL utf8 vs utf8mb4 was discussed in depth just six days ago on HN: https://news.ycombinator.com/item?id=29793916
That all depends on whether one views prison as a deterrent, a punishment, or an attempt at reformation.
I think your definition of art is just a partial one. As an example, the characters drawn for an RPG are works of art. They are receiving monetary value in return for that art. So its commercial/entertainment art, and a place where many artists aspire to be.

Your definition is what I would call "culture defining art", which is art that some part of the culture identifies with (or more specifically, a person's way of communicating that they can identify with). The currency here is tribalism, i.e. it creates a way for two or more people to bond together through what they feel and think.

>Those who have the courage necessary to become artists, and renounce the vulgarity of the world, will continue to do so.

Courage is trumped by needs. If they need pay rent, buy food, support a family, pay for a car, etc, then no matter what they are sacrificing some part of their time in order to obtain those things. Thus any artist who can make money off their work would have more time for their work, and possibly grow faster.

>Those who delude themselves into thinking they're creating anything while being employed in commerce, will be managed out.

Seems like you're too attached to the idea of what an artist is and isnt?

>Ironically, if it's that important to you, why don't you start giving monetary support directly to artists?

Because Im not building something that is taking away from their dreams (e.g. living off their work/passion).

<side thoughts>
I wonder if people are aware of the consequences of automating creativity? IMO humans need human input in order to stay human. The less and less we come into contact with humanity, the less human we'll become.. and at the very end of that long path is a bag of chemical reactions that's forgotten the meaning of "how are you?" [1]

Which made me think, perhaps its the inefficiencies of life that is what makes us human

[1] This is because some company/companies will realize/have realized that tuning the machine to become most efficient at creating what the masses want will be the most profitable path.
But the question is if you want to work at the 21% of companies that use Microsoft.

Based on my own experience, you probably don't. They tend to be legacy companies in low-growth areas and lower pay.
In 2022 with a new release of MySQL or MariaDB, is it still possible to create a database with "utf8" encoding? Does it print a warning?
Do you have a source for that increase? I was not able to find it. Seems very suspect considering that the earths outer crust is approximately 20 to 30 miles thick. Are you suggesting that if we go approximately halfway through the outer crust, say 15 miles, the temperature is going to be 725 degrees warmer than surface temp?
It is not the case that "things" are interesting in and of themselves.

An audience finds them interesting or not. Interest is a property of the listener or observer.

You can just comment on the things you find interesting, and presumably there are some people out there more or less like you that will find the same things interesting.

It is worth noting that it takes some skill and effort to make things interesting for an audience, and that can be substantial.
Alot of recruiters namely in London are outright liers.

So much so they will have you go through the job process to meet their targets or even when they know better candidates are being put forward.

They employ so many unethical tactics it's best to always check with the company directly if the role still exists.

We work with many recruitment agencies and having seen and heard what I have I no longer would take any at face value if I was on the other end.
I'm assuming this recruiter doesn't recruit for a company, but instead works for a recruiting company. It's been my experience that they tend to be myopic with their skillset and end up setting up a cycle--experience finding candidates with X skillset, so work with companies that need X skillset, which means they need to source candidates with X skillset.

Is MSFT stack the darling of Silicon Valley? No.

Is it used widely? Yes.

MSFT and Google had no interest in losing cloud market, so you will be fine in either ecosystem.

At 40, with no interest in management, my suggestion would be moving towards principal architect / principal software engineer roles, where you are considered the defacto company expert in X. Sounds like you have a lot of MSFT technology experience, and I have to imagine you will find work until you no longer wish to work.

Also, I would consider marketing your skillset; MSFT makes good products, and teams/companies may not be aware. I wouldn't say "Why are you using Javascript and not .NET" as that is not a wise question, but rather, show how investing in MSFT toolchains would benefit their org.
Plus, always a good idea to hedge: against lithium shortages / gouging and battery supply chain disruptions.
Sure, but by then theoretically that would apply to all grocery stores, so these startups would then have no advantage at all
There is a reason that mine has the subtitle of "it's like /dev/null but with more content" (https://denner.co/posts/)

I also mostly use it as a public brain dump for things that I don't want to forget.
Ask HN: Why are academics satisfied with not changing the world?
"Please don't post shallow dismissals, especially of other people's work. A good critical comment teaches us something."

https://news.ycombinator.com/newsguidelines.html

Also, please keep religious flamebait off HN. It leads to religious flamewars, which are tedious, nasty, and dumb.
>For example, if you work in the auto industry, there are a lot of different corporations you could work for

There really aren't. Perhaps if there were, union representation wouldnt be so desperately needed.
I've been using ploomber for a month and so far, I really like it. The developers have been super helpful. It hits the sweet spot for writing developer-friendly, maintainable scientific code. Our data science team is looking at adopting it as our team's standard for deployments.
I would say that an organized group of workers that calls itself a union and advocates on behalf of those workers for labor rights is a union, and I think most people and dictionaries would agree with me. If that's not what you meant by the word "union", I think the burden is on you to provide an alternate definition for this discussion.

For example: "an organization of workers formed to protect the rights and interests of its members" - https://www.merriam-webster.com/dictionary/union
That's cool that you can use this to keep track of when new episodes/seasons air. With so many different streaming services, it seems nice to keep track of the shows you watch in one place.
It’s also easy to imagine how it happens… const char *buffer = malloc(…; memcpy;… etc… pretty fast pretty straight forward
Yes, these old sayings are often grounded in reality, even if they are part of a larger philosophy based on faith.
I think the antitrust issue is in the targeted digital ad market because FB has all of these products in the social networking space.
Conrex – Elixir package for topogographical and isochrone maps
Now that it's cross platform, you're not locked into an MS stack anyway. Even for older projects that might want to get off .NET Framework to get out of the lock-in, it would be a lot more efficient to port it to .NET Core than another language/framework.

If the new kids really don't want to use it, specializing in it might be an advantage for the older crowd since we'll happily take the work if they don't want it. I work with some pretty big companies that still run .NET 2.0 based services. I think there will be work in it for a very long time.
I'm curious now...got any source for you "Mafia in the USA runs health care and show girls" statement?
Yes. Of course! With additional pipelines for all sorts of things, and HVDC!1!!
Socialist movements which pushed for workers rights in Europe are more based on Marx than unions. Most modern worker parties has their roots there, but of course some of the more extreme socialist policies has been dropped in favor of capitalism.
Another argument against UBI
> The outer cloth is not an accurate indicator.

Ah, I see what you mean. I’m pretty sure that I’m not seeing an illusion most of the time, because I’m not looking at the cloth. I’m looking at the very visible skin beneath the gap. But it makes sense that the outer layer of cloth could be misleading.

> The too-tight nose piece is probably because that’s how the masks are packaged.

You’re probably right. I normally see this on the center-folded masks. This would mean that people are just throwing on the mask without fitting rather than doing an astonishing bad job at attempting to fit, or intentionally fitting to create a space. That’s certainly more understandable.
That they exported more than they imported. All countries (or I guess at least) both import and export electricity depending on their needs. In the end the total says if you imported more or exported more.
Indeed, hence why many need to understand that Rust vs C++ isn't a zero sum game, and any improvements to C++'s own security story are more than welcomed.
We ship GitHub Mobile every week
I think it's at least a decade since Texas Instruments introduced the FRAM series of their MSP430 microcontrollers [0]. Good to know there are efforts to bring such technologies to "bigger" computers - having TBs of RAM in your laptop must be fun.

[0] https://en.wikipedia.org/wiki/TI_MSP430#FRAM_series
I am super excited about the multi-tenant use case supported by tag pruning. Great work!
Astronomers uncover largest group of rogue planets yet - https://news.ycombinator.com/item?id=29749459 - Dec 2021 (24 comments)
Ask HN: Any interest in restarting the “Who is looking for co-founder(s)” post?
There use to be a monthly "Who is looking for co-founder(s)" post on the lines of "Who is hiring". That monthly posting seems to have stopped.

If there is enough interest in restarting the "Who is looking for co-founder(s)" monthly post, then I am ready to take that responsibility on 1st of every month. Please let me know if you want to restart the monthly post.
I have decided that I will end any interviews where the process does not feel right. That means I will not work anywhere that requires leetcode, whiteboarding, live coding, take home tasks, or other exercises that have no bearing on my actual job or thirty years of verifiable past performance. These are all an insulting waste of my time, and I will have none of it anymore. They only demonstrate the willingness to squander enthusiasm and ability.

When enough people walk away from these interviews, they will get the message and the status quo will change. In the meantime, I will continue working for shops that do not feel the need to use such abusive interview tactics.
https://www.dictionary.com/e/slang/karen/

> Karen is a pejorative slang term for an obnoxious, angry, entitled, and often racist middle-aged white woman who uses her privilege to get her way or police other people’s behaviors.

There are actual people with this name, and even if it was not racial, is it really okay to use pejoratives and denigrating terms, especially if that terms happen to be a quite common name in some parts of the world, like Denmark and Norway.
It could be he's thinking of the historical definition which included support for 5 character encoding with a maximum codepoint of U+7FFFFFFF or ~2 billion.

https://en.wikipedia.org/wiki/UTF-8#History

That was restricted I believe primarily for compatibility with more limited encodings like UTF-16.

I guess it's possible that at some future point in human history when UTF-16 has been purged from memory, the 5 character encoding might be allowed again. :)
Related: time to explain UTF-8! (In case anybody is curious. I personally think it's extremely clever and worth understanding:)

Characters <128 are encoded with a single byte: 0xxxxxxx

Characters >128 are encoded with multiple bytes.

A two-byte character looks like:

110xxxxx 10xxxxxx (11 useful bits, representing code points 128-2047)

A three-byte character looks like:

1110xxxx 10xxxxxx 10xxxxxx (16 useful bits, representing code points 2048-65535)

A four-byte character looks like:

11110xxx 10xxxxxx 10xxxxxx 10xxxxxx (21 useful bits, representing code points 65536-2097151)

Now, technically this scheme could expand to 6-byte characters without getting confused with things like BOM/etc, however any code points larger than 2^21 wouldn't be representable in UTF-16, which has its own set of constraints. This means the unicode consortium has basically limited themselves to two million or so possible code points, which is why UTF-8 doesn't need to go more than 4 bytes. (I wonder if a future unicode version will require a larger limit and would thus create a new "utf8mb6" scheme, and drop UTF-16 altogether?)
Exploring the Security Implications of GraphQL
LitmusChaos Becomes a CNCF Incubator Project
In addition to the other responses, plane cabins have very low humidity, which can take out your mucosal protections from getting a cold. It's really common to at least have a scratchy throat after flying just from dryness, and often times catch a cold afterward.
A warning. I just downloaded this to try it out. To test I searched for directions to a location I travel to often. The directions didn't even get me out of my neighborhood before telling me to turn left onto a median divided road which doesn't have a gap in the median to allow turning left at that particular intersection. No other mapping app I have tried has ever made this mistake.

EDIT: For giggles I tried a few more mapping apps and websites for the same directions. No others made this same mistake but Bing Maps and MapQuest want me to drive on the jogging path around a pond which separates my neighborhood from the next and then use the streets in that neighborhood to get to the main road. I think both sites used base map data from TomTom.
There are a lot of comments here debating the merits of unions in general.
I am interested in hearing peoples opinions on this particular situation at hand.

In the case of Google specifically, what problems or grievances would be addressed by unionizing?
Good advice for anyone.
Speak for yourself. I only want to wear masks if they're proven to work. I'm not playing dress up for no reason.
Good point, and good examples. Excited online discussion about companies like those are what I mean when I say it's popular on the internet. It's not impossible, it's just not the technology I would be betting on. To get a sense of what one is up against, you can work through the math comparing gravitational potential energy to electrical potential in typical batteries. I can't find a good link right now, but what I remember finding is that (in the ideal) a typical lead acid car battery has enough stored energy to lift itself into space! Conversely, if you wanted to store the same amount of energy as in a typical car battery, you'd need to be dropping that amount of weight from the top of the atmosphere all the way to the ground.
As a matter of fact, as of the end of 2021,Firefox does not actually have "hundreds of millions" of users anymore. It has 198 million.
Kia, Ferrari and caterpillar are not competitors despite all producing vehicles.

In the same way TikTok, LinkedIn and WhatsApp are not competitors. Every sensible person understands that.
It's not quite lithium ion efficiency, but it serves a different duration energy storage market (up to 24 hours vs single hours for lithium ion battery storage), and it has a much longer service life (50 years), so the levelized cost of storage might be lower than lithium ion battery storage.
What is the actual harm? I can choose between copper, coax and fiber and there are at least multiple providers on the copper.

Prices are reasonable and speeds are good.
Are they? If most air is coming around the edges I’d expect that whether the mask is woven cloth, surgical, n95, or solid plastic just doesn’t matter much.
I mentioned this last time when the FTC refiled its complaint but the FTC still has a pretty tough case to prove here.

Among other points the core of the FTCs complaint states Facebooks market power dominance by stating its largest competitor is Snapchat. While not impossible I think it'll be tough to convince people that platforms like Twitter and TikTok operate in a completely different market than Facebook does while also saying that Snapchat is in that market.
Not true at all. As a user of AWS and Azure, I can say that I prefer the latter and it is gaining rapid market share. As a CTO I see a lot of resumes every week and there are plenty of startups being built on .NET

I was actually bearish on MSFT about 10 years ago, but since Ballmer has been gone I have seen a big improvement in cloud, developer tooling and a clearly different attitude towards Linux and open source software. Very confident in .NET now.
Yeah, and whenever there was a pandemic in the past there was a heightened period of death and typically poor economic conditions for a while. It’s not as if pandemics haven’t happened before; they have, and they have devastating consequences which is why we’re so proactive about them.

People will locally optimize in the absence of government intervention, which means lockdown-like conditions are inevitable as people simply stop going to work in large enough numbers they cannot be replaced.
> We apparently do live in somewhat different worlds, as I do not spend much time with the media you are complaining about, or their counterparts on the other side of the political spectrum

What mass media do you watch, then?

> I agree that it is unseemly and unfair (and counter-productive) to ridicule people who are genuinely confused (a position I hold regardless of whether the issue is scientific or not)

By writing off, in passing, the people who refuse to get vaccinated due to possible side-effects of the vaccines as “genuinely confused” you’ve just ignored a large part of my point so far.

Why—and I hope it’s obvious that I am excluding the mentally ill, chronic conspiracy theorists and propaganda bots in the entirety of my argument—is it not warranted for a person to be skeptical if they can’t validate a claim? I trust this claim myself, but I am painfully aware that any non-circular argument I can present in favour of that claim will ultimately hinge on an appeal to authority. To say “this is the claim, it is true, those people who don’t believe this claim are confused” is to exhibit the behaviour of a religious person (just replace “claim” with “God”).

> It is especially not clear to me why the issue of relatives with strongly differing views over this particular issue should be off-limits.

Do you believe those differing views should be off-limits, then? Because that is exactly the attitude I meant to bring in question. “I’m not going to engage with them, they are wrong and I am right because science is right.” This attitude arises from the aforementioned philosophical ignorance leading scientific findings to be treated as sacred and unthinkable to cast doubt upon; it shuts down the potential for dialogue and fuels further unnecessary polarization.

Take the unconditional belief in science on one hand, combine it with certain lapses within scientific community itself (such as the outright politics played with respect to COVID origin—it seems impossible to really tell whether X or Y occurred so far, and yet we observe the pattern of members of scientific community being publicly dead-sure of X and ridiculing Y because they had vested interest in X) on the other, and the skepticism may be understandable.

> moreover, there is strong empirical evidence that it is both effective and safe for almost everybody

Please, you don’t need to preach this here.
I don't know much about Google but one of the (many) things that always made me uncomfortable while I was at Facebook was the cynicism with which they ignored contractor's issues.

It often came up in the company Q&A, and it was often ignored or glossed over with an answer by Sheryl detailing how contractors "actually had it pretty good". That is, unless there was recent public press coverage how they in fact did not "have it pretty good" in which case the answer was your usual "we're working with our outsourcing partners to make sure every contractor has what they need to do their best work", etc.

I am an engineer. I might've been more difficult to hire, but I wasn't doing work that was nearly as important or taxing as content moderation contractors, for example. Revert my work and some obscure internal metric somewhere is a little worse. Revert a content moderation contractor's work, and thousands get exposed to suicide, CSAM, graphic violence, etc.

I know the value of an employee at companies like this is determined by how difficult they are to replace and how their work affects company profits; "anyone" can respond to content reports but not "anyone" has the technical knowledge I do. I just think it's wrong that people working on something so vital to Facebook have it so much worse than the rest do. Facebook could and should do a better job rewarding and protecting the people doing the hard, dirty work— it definitely has the means to.
Uhm. Let's first try to tame Yellowstone by using it as geothermal power plant, ok? :-)
More like "100 ASCII characters. Unknown number of emojis."

You'll get codepoints truncated if you use bytes.
Same here. Which is extremely weird because the house numbers can be CLEARLY seen in the street view!
Is that really an issue? Its really a missing data problem. Your data is "missing" and facebook can infer with some probability you exist and the people your "shadow profile" might interact with.
This article didn't mention density/cost. That's a key reason why we still use storage.

So let's wait and see.
Relevant XKCD: https://xkcd.com/1337/
>> think that was because most Americans were of European descent, and many were relative newcomers with connections to the old countries,

I think it was more because Japan attacked the US. Germany and Japan were allies and Hitler was developing intercontinetal rockets. If I read it right the US was very "America First" before Pearl Harbour. How ironic that the U.S got back to America First again...