skysight-inc/HackerNews huggingface dataset:
There have always been low-level differences in the way MySQL treats the two (VARCHAR <> TEXT/BLOB) data types, although some have been removed over the time.

A notable example is that before version 8, internal temporary tables didn't support BLOBs when in-memory¹, so that they would swap to disk, causing a performance penalty.

Regarding the length, an important concept is that it can be used for optimizations.

InnoDB adds a certain number of bytes for each value stored, depending on the size. For example, a TINYTEXT consumes 3 bytes less than LONGTEXT for the same value.

Another difference is the location of the data. TEXT/BLOBs up to 40 bytes long will be stored in line, while the limit is 768 bytes for VARCHARs. A 100 bytes long TEXT will require one page access more than the corresponding VARCHAR.

Of course, it's up to the engineer to choose whether to consider optimizations like this or not, but as a matter of fact, those differences exist.

¹=note that this concept is different from tables backed by the `MEMORY` engine, and different from user temporary tables.
Yes, I hope so, because fraud is a huge issue with Spotify.

An older acquaintance of mine is a professional musician living in Nashville doing commissions.

He made a track for a trailer of a video game, but chose not to publish it on Spotify (for reasons I don't know). One of the fans ripped the song from the trailer, uploaded it to Spotify, and was collecting all the royalties.

Even though Spotify keeps taking it down, someone else uploads it again, ad nauseam.
I don't listen to them that much, and they don't need my support.
The Librem 5 (only dev kit is out so far) is similar to this. You can run some Gnome software unmodified, they have been doing a Youtube series showing various apps running on it. My understanding is the phone will be able to connect to a large monitor as well.
It can't 'compile' to HTML, because it doesn't know at compile time what data you're going to give the component. Instead, if you compile with `ssr: true`, the JavaScript it generates is a module that generates HTML through efficient string concatenation. It's very easy to bake out static files as part of a build step, or generate markup dynamically as part of a Node server.

CSS is extracted at build time; typically your styles will be served as static .css files for maximum efficiency.
US Concentration Camp List
Even very dirty river water would still spin your mill, as long as the mill itself is good.

This guy literally confirms that one little open source OS could be as good as Windows $)
They're already putting fingerprint scanners actually under the screen somehow (TIR?) - I doubt it'll be long before they figure out how to get a camera to look through a running screen while being invisible from the viewing side. Ultimate Big Brother tech right there.
That's possible, for some it does nothing, for others it can be the path to non-recoverable schizophrenia. My advice to people who smoke high THC is: if you have had weed-induced psychosis then you might be able to develop schizophrenia with prolonged use of high THC weed. In other words: smoke seldomly.

However, it might also be possible that one simply doesn't notice their cognitive decline. To check on this, people would need to listen carefully to their environment. If they say something is wrong with you, then something is probably not right indeed.

The reason for this is: schizophrenia and psychosis related phenomenon take away the ability to self-reflect.

Unfortunately, I don't have sources for this, other than that I read up on it. But for now, it simply is just one opinion on the internet. Search engines are your friend here, especially academic search engines. And I have friends who are psychiatrists, so those conversations help.
Flotato – lightweight non-electron webapps as apps on macOS
True, but it's an 8.0+ feature. It looks like from the thread that they needed to support older versions as well. Seems odd to drop all of MySQL rather than have a min. version. The more you pry in the thread the more it seems like their developers already wanted to drop MySQL and just wanted an excuse.
We’ve actually had our data leaked by one of their engineers working in his free time. He found an open database and leaked in to the press. He was probably just scanning random ip ranges and stumbled upon it and I don’t think he was targeting CF clients in particular. Hopefully they will stay humble and fix their own issues first.
On a side note an anecdote came out of that leak...
We were then contacted by this big name tech website if the data is ours, before they published the article. Unfortunately the author sent us an email via his @gmail address which did not add to his credibility so his email was brushed off for a day or two until we saw it published. Can’t say if it was a dark pattern of his to not use his work email to notify us or not...
We don't know what exactly happened. They can work their problems out between them or in a court room. Reading allegations and passing judgement on people that we don't know should be reserved for tabloid readers.
This is par for the course in automotive manufacturing. I don't know about the design side of the house, but 60-70 hour weeks in manufacturing were the norm. I'm not sure it should be viewed as unique to Tesla
If you already have a spare disk installed doesn't it make more sense to just add it to pool anyway and just bump up the redundancy to Z2 or Z3?
Flagged for linking to a leftist subreddit instead of the source and editorialized heading (ctrl F "unreliable" on the actual article, no hits).

Actual source link: https://www.japantimes.co.jp/news/2019/07/02/national/politi...
How to battle tech debt (interviews and case study)
This is probably off-topic for HN and should be flagged.

That said, there's interesting irony in that a politician who ran on American exceptionalism is helping to bring said exceptionalism to an end.
>You did forego all privacy and clearly you are okay with information being collected

Absolutely not! I would not be okay with people being able to listen to the audio they record without my consent, I would not be okay with a transcript being publicly available, I would not be okay with the history of the commands I say to it being publicly available. I'm also not okay with audio being recorded without me triggering it to record.

Making limited tradeoffs with my privacy in specific situations is very different than not caring about privacy in general. And "privacy" isn't just one thing, there are tons of levels in many different areas.

For example, I am not okay with cameras that upload anywhere off site IN my house. That's a line that I'm uncomfortable crossing. Not because I think that there is someone viewing every second of uploaded footage, but because the risk of a security breach is high enough and the information that camera would collect "private" enough that I don't think the tradeoff is worth it. But cameras that record the OUTSIDE of my house and upload it somewhere? I'm fine with that. The expectation of privacy is different on the other side of that wall for me, and i'm more than comfortable with the tradeoffs and risks of that going public.

For you those lines might be different, but neither of us forego all privacy because of those decisions.
The link is to a comment in the thread, not the article.
If you did the first thing, you’d be stupid, and in breach of your contract, just as if you shared it elsewhere. And it’d get taken down pretty quickly, algorithmically or not.
Do you have the same complaint about automatic red-eye elimination?
CDNs Should Work Like Databases
Hmm... the thread started with GC, are you sure you want to allocate memory while struggling for the last percent of performance?
Hi! My name is Jordan and I'm a USDSer at the DoD. I'll be sharing my experiences trying to open source software within the DoD at the upcoming Mid-Atlantic Developer Conference in Baltimore (Aug 1-2). As Robbie mentioned, some of us also participate in many of the user groups around town, including DCJS and Women Who Code DC.
Looks like an interesting post, like the case study part!
Here I was thinking this was some sort of urban myth caused by superstitions in an age with less abundance of easily accessible tech information.

Guess I owe my dad an apology now.
The EU thing doesn't apply yet. More likely it goes against labels at a much deeper level: letting people succeed without labels.

I wouldn't be surprised if the labels didn't want to renew deals unless that avenue was cut off. That is much more concerning to them than a copyrighted upload avenue that they could DMCA away pretty easily.
We like it. But it can be actively harmful to the interests of the company. And its impossible for us to have the facts required to know if this is harmful. That's up to the company. So if they decide to fire employees who are spending their free time harming the company, we can't really get upset about that.

Its simply impossible to say, "no but this openness is good for the company" in an informed way. But we can certainly hope the company comes to this conclusion and encourages openness.
Location:
Remote:would consider it

Willing to relocate:yes
Technologies: Go, React, Graphql, Typescript, PHP
Résumé/CV: https://www.linkedin.com/in/topaz-t/
Email:topaztee@gmail.com

generalist full-stack software engineer with 2 years experience leaning towards backend. looking for a mid-level role.
$265 is an outlier, $2000 was more typical: http://www.1920-30.com/automobiles/1922-car-prices.html

Incomes in 1920 (for the selection who paid income taxes) were around $3200: https://www.irs.gov/pub/irs-soi/20soirepar.pdf
Why are you policing other company's employees and presuming to know what their job is?
The poor use the shit out of their used 20yo trucks hauling scap metal and saving $15 delivery fees on bulky things.

It makes me wonder if the poor of 1955 had more picnics.
The interface in vr for elite:dangerous works like this, it does gaze tracking of sorts (tracking the headset) and pops up context menues (weapon systems, radio/communication, navigation etc). It works really well imnho. Otoh the interface is similar in regular 2d, but feels clunky and gimmicky there.
This is my take. For all the talk of international brain drain, we don't have a narrative for the more local equivalent.

Similarly, we worry about disrupting natural biomes through deforestation or overfishing, but we don't think about sustainability applied to human communities, with a few exceptions (reservations get some attention, though not sufficient attention).

What do we do? For one, I don't think it's hard to make an ethical case for remote first workplaces.
No, it's a driver operated cross between buses and taxis. You book a ride in an app between a starting point and a destination. Both locations must be on a grid of "virtual bus stops", spaced around 500ft apart; drivers are required to stick to them and cannot pick you up or drop you off elsewhere.

Their system tries to bundle multiple rides going in the same direction, so your ride might include a slight detour to pick up other passengers. You get an ETA including these detours in the app beforehand.
> Apple said it received 29,183 demands from governments — down almost 10 percent on the last reporting period — to access 213,737 devices in the second half of last year.

> Apple also received 4,875 requests for account data, such as information stored in iCloud — up by 16 percent on the previous reporting period — affecting 22,503 accounts.

I wish they were more specific. What does "access" mean? Location? All local data? Even encrypted data?

What data from iCloud? Email addresses, or the full contents of Notes and Drive?

Maybe I'm being naive, but I assumed that when something says "Apple can't read X data" it means under all circumstances. But if they have a backdoor, client-side encryption probably doesn't matter.
You can partition your drives based on the size of the smallest and make your pool on those partitions.
Also, you couldn't possibly follow ruby's style guide with tabs:

https://rubystyle.guide/#indent-conditional-assignment
I'm sorry, what? What's supposed to be strange about this? They have a product, why would it be "creepy" that they advertise it?
Show HN: Fast and clean extension to help find new trending projects
And how good your employees are... How good your review process is... How good xyz is...

If your engineers are so solid, and them making a mistake on a given release is individually 0.5%, and you have 50 engineers, you will see the probability of nothing going wrong is about 77%(0.995^50), and something going wrong is 1-0.995^50. Pretty low, i might say.

Dont do this to your engineers. 80% test coverage is a sweet spot, the rest is caught better with other approaches. No reason to kill engineers productivity everytime something fails on production by blaming their tests arent good.
Spotify and the like generate pennies for artists because the record compnies part own it and have price fixed it to hell and back. The only significant profit comes from touring and merch sales. As a starving artist, pirate my shit, see my show. Nobody cares about plays except for getting distribution deals.
Their statement is somewhat ambiguous. They may have tried to express that "you can't add a column of the TEXT class without specifying the exact type".

So they could be "right", but expressed the concept in an imprecise form.

In a way, I think this shows their lack of expertise with MySQL - I reckon that somebody with a long experience would have phrased the concept more precisely.
.Net Fiddle Now Supports .Net Core
Sure and the source code has also been leaked before. But a "clean room" implementation is not allowed to look at such things.
ReMASC: Realistic Replay Attack Corpus for Voice Controlled Systems
It was a git thing.

Never post aws secrets to git.
America’s first rocket man,the rise of crypto,and AI reconsidered:Books in brief
Fortunately and unfortunately, I nearly always travel with one or more young kids, which means I can't realistically do stuff like this that'll delay things (they have small bladders, little patience, and are curious). However, they usually have me go through the metal detector instead of the backscatter machine, so I tend to avoid that part of it.

Before our last trip, I read about the facial ID thing, and I was worried because my passport was expired (we were traveling domestic). Fortunately, it seems neither of the airports we went through were implementing it yet, so I'll have time to renew before it's a thing.

I just wish we can all come to our senses and realize that the TSA doesn't really make us safer and that it just makes everyone mad. Unfortunately, people just seem to put up with it.
I agree. I'm originally from Charleston and have always said that it's not like the rest of WV.

I'd say the real heart of Appalachia is Pikeville KY.
None of these capabilities have an existential requirement for a centralized networked infrastructure spanning the globe.

Stop and think how ludicrous it is that your being able to say to the room "pick a random song and play it loud" requires fiber on ocean floors and huge buildings running servers and the rest of it.

We're being socialized into thinking privacy is an impediment to progress.

It is just a very bad idea to create a turn-key surveillance society and hope and cross your fingers it never gets used.
zpool replace poolname olddisk newdisk

Keeps the olddisk online and utilizes it until newdisk has resilvered, then detaches it. It seems equivalent in safety to

zpool attach poolname olddisk newdisk
Wait for resilver...
zpool detach poolname olddisk
Yeah, that probably invalidates your passport.

"Photos must not be digitally enhanced or altered to change your appearance in any way"

https://travel.state.gov/content/travel/en/us-visas/visa-inf...
That would be really interesting project. Only up for it if it's open source.
> we don't generally disable RTTI or exceptions

Keep up the good fight! "Exceptions are slow" is a realy outdated opinion
Partial indexes allow you to do stuff like keep session tokens for some longer time to facilitate logging of attempted use of expired credentials, without significantly hurting your authentication-validation performance. In most cases you will not hit the disk, as the partial index is in memory.

In general, you can keep selective indexes in memory, possibly even with supplementary columns to eliminate disk access for the actual data you're trying to fetch by the key the index is based on.

Even Sqlite has partial index support...
It's a bit more complicated :-)

I wrote the details in another comment. You can find references here:

https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.ht...

and here:

https://dev.mysql.com/doc/refman/8.0/en/storage-requirements...

"Bad performance" is not exact. I'd say "worse" performance, in the cases where TEXTs cause extra page accesses. The distinction is important because in some cases, a performance that is "negligibly worse" can still be "good" - as in general, in software engineering :-)
The way you're phrasing it, they need to "admit guilt". They are guilty of nothing. First of all, what kind of heartless jerk fires every one to win PC points? That's a really bad practice, not fair to your employees, and I certainly wouldn't want to work for a company who did that.

Clearly, there are problems finding women. There are fewer women; that means it is not possible to have 50/50 across the board. He just said that they are lowering the bar. What are they doing about hiring that is unfair? Probably nothing, if they have to hire less-qualified women or a more-qualified man.

There are fewer women in tech. Why is immaterial to the current discussion. For better or for worse, that's where we are. If you want my two cents, I think part of it is risk. I worked in a start-up for a few years (not in the valley), and there was one female developer in a company of thirty. Why? I think men (especially young ones) are more willing to pick up and move for a high risk/high reward opportunity.

But all that aside, seriously, who actually advocates firing every one so you can have a nice press release? Would you want to lose your job to give some random woman one?
Their security must be really bad; no video evidence at all has come out of our own secret camps. It’s total information blackout. Our press is either utterly powerless or utterly spineless. Obviously I’m not trying to justify what China is doing, just saying, we need someone to take some risks for fucks sake in both countries and get some footage.
Dozens of kids die in hot cars every year–a new bill aims to prevent it
Oh boy, a hot take from a reddit nobody on the front page of HN.
> Nowadays I have shared playlist for family and friends, and it lacks magic.

The physicality of the medium is just one aspect - another source of magic was the lack of a skip button. Well, that and the fact that most people had fewer distractions back then and regarded listening to music as an actual activity, not merely background noice.

Your comment makes me nostalgic - few things feel as magical as carefully compiling and recording a mixtape for someone special and knowing, to a certain degree, that there's a good chance the gifted person actually takes the time to listen to it just as thoroughly. As a music lover and collector I still have the tape decks and, more importantly, the selection to create those tapes, but good luck finding anyone being able to play them.

On a sidenote: There's still a niche audience for tapes. If you spend time on Bandcamp you'll see quite a few labels and artists offering their release in good old tape format. There also this limited series inviting various DJs, selector and crate diggers to share their mixtape: https://www.alteredsoulexperiment.com/products
Totally agree with you. I think also that it's very possible that delivering-adverts-with-minimal-privacy-infringement is a different class of problem to just "delivering-adverts". Maybe it's a type of problem where profit can only be extracted by means of huge economies of scale and well-staffed teams of ML experts? Like deep-sea oil drilling versus drilling in the desert?
Nesting multiple branches of ternary operators doesn't work well but if it's a sort of “if elseif elseif else” situation I think this looks pretty nice:

x > 0 ? 'positive' :
x < 0 ? 'negative' :
'zero'
Overheating cars killed at least 52 young children in the US in 2018.
Small study with mostly small doses and better than expected outcomes IMHO.

I have several friends using CBD for anxiety and depression (in addition to normal meds.)

IMHO, it has profound potential medically. Anecdotal evidence is unreliable, but one close friend of mine started taking doses at my insistence while going through cocaine and heroine withdrawal. It make a profoundly noticeable change in her attitude.

I hope that more clinical studies are funded regarding it's use for those matters because a cheap and readily available medicine to help with these symptoms is severely needed to help those seeking to end their addictions would be greatly beneficial to society at large.
Both anarchism and libertarianism have one thing in common though: both are adolescent utopian fantasies, completely unworkable in the real world because they are not evolutionarily stable strategies.

https://en.wikipedia.org/wiki/Evolutionarily_stable_strategy
My mother is bed-ridden and partially blind. She cannot use a smartphone. Alexa helps her call me.

I do not deserve to have my privacy obliterated.
some honest feedback from someone avidly using K8s since 1.1.

- im not sure what k8s problem this is solving. the first thing your talking about is building docker images, which k8s has nothing to do with.
- are the k8s config files accessible? where are they?
- the sanic.yaml file looks like yet another DSL i need to learn. how is that simplifying things for me? i have no idea what your example config file is doing either, none of it seems to obviously map to anything in kubernetes.

This feels like more of a docker build cli than a kubernetes cli. also, does this actually create clusters? like kops does? if not, this just seems to add a tool to the toolchain rather than simplifying anything.

idk, maybe it's cool, but it seems complicated.
If this is the case, why would spotify not just outright say that? It seems it would calm a lot of the backlash, and artists would be more understanding.
It looks like you're not the only one! From the comments on the top response:
> "If true, I owe some baby boomers apologies for things I said about 20 years ago"
Call him and tell him!
For what it's worth, it's not just Microsoft who care. You're not allowed[1] to contribute to Wine if you've ever seen the leaked Windows source code. I think it's weird that they consider your mind to be "tainted" forever, but whatever. I guess they want to be cautious.

(You're also not allowed to contribute to the Wine CRT if you've ever seen the CRT source that's legally distributed with the Windows SDK.)

[1]: https://wiki.winehq.org/Developer_FAQ#Who_can.27t_contribute...
> People need to learn personal responsibility

Yeah they do but from what I've seen in my life, we're centuries or millennia away from the average person being like that.

So the mobile OS vendors adapt to the average human. It's only natural.
So you wanted him to write a different book? Maybe he had different goals and that's fine.
Probably because it makes far more people aware that ReactOS even exists.
Give Your Yard Back to Nature
"So how come we got this smartphone crap, instead of actual portable computers that could, among other things, work as cellphones"

I think because they care about milking users, not about them being creative. I myself is very disappointed about what smartphone could've been for people and what it actually is.
Human Lives Might Be Long Enough Already
This. All the major labels did not support spotify out of good will-- Spotify uses hollywood accounting to give the labels the spoils. Same exploitation of artists thats been going on for 100 years.
The Palmer Method of Business Writing [pdf]