skysight-inc/HackerNews huggingface dataset:
A lot of NFTs are pixel art because it's very easy to integrate with the typical NFT model: make a handful of swappable components (hair, eyes, mouths, noses, accessories), a handful of skin tones, and a handful of backgrounds, then spit out every possible combination of those as "unique" NFTs.

I can imagine the sub's moderators got fed up dealing with people posting endless nearly-identical looking images from the same set (either by the original company trying to make a quick buck, or the buyer desperately trying to flip their investment) and decided to just burn the whole thing.
Witty, but ignores the artist <-> artwork <-> fan relationship dynamic that is at play here. To me the scene feels closer to a platform like Bandcamp than it does the more speculative world of Opensea.
Snow Crash (Neal Stephenson)
Non-white != democratic / blue
Maybe because they don't apply?
It's a little unfair to call this 80% of a solution, but it pretty much is.

The demonstrated speed is awful, which is alright in theory since you can just run more of them in parallel, but it does pose an issue if it's added to a facility that is running near capacity and can't put more trailers on doors.

50 lb limit is below state of the art (humans), but some companies have that as a limit. It's ok.

The real deal breaker is that it seems to be designed solely for cube volume, and not just any cubes, perfectly regular cubes. The demo videos also seem to be very light stuff (10-20 lbs?) and have a lot of impermeable surface like tape, I'd guess that 50 lbs is only doable under very good circumstances. Maybe even dusty boxes would be a problem.

edit: 40-50lbs is plenty for cardboard cubes to warp, flex, start breaking apart, etc depending on the contents. This happens even with a human holding onto opposite corners, relying on a single flat surface just isn't very robust.

I think grip is the big problem. When a robot can reliably toss poly bags, strapped printer paper boxes, and tubes, it's going to get a lot of use. I've seen that sort of stuff for smaller things, but it seems to be extremely hard to scale up to heavier weights.

It's a bit funny, but this is probably 5x as useful in reverse, loading trailers and pallets.
> I can't see just saying "you're wrong, read history" as productive conversation

You're denying a very foundational economic fact which, as a society, we litigated over a century ago, so giving you a resource (I can cite chapter numbers if you'd like me to) seems appropriate. Capitalist forces will always tend towards optimality and working people to the bone (including children) is optimal. This is why we need to have governmental forces preempt this by making these kinds of things (e.g. child labor) illegal.

This isn't really a dig against capitalism, it's simply how the system works by design. In other words, you're denying the precise thing that corporations optimize for: worker productivity and shareholder value.
Have bought several Teslas over the last 3 years (S->X->Y). Quality improves each time I’ve bought one. Lots to complain about, still wouldn’t buy from another manufacturer.
FTR I've owned and captained boats on the Great Lakes, New England, and now in Florida for about 30 years. My experience differs from yours.
> Storing the encrypted database in the cloud and downloading it is the same as storing it locally if the decryption protocol is performed locally.

The problem is that, with web-based password managers, you are not only downloading the database, but also the code to decrypt it. A locally installed Keypass requires your PC to be compromised, whereas for LastPass it is sufficient for their servers to be compromised (while not avoiding the problem if you are compromised, either).
What if you do SELECT a + b, SUM(x) FROM t1? Should the implicit GROUP BY be on (a,b) or (a+b)?
Yup totally agree - OP is an interesting proposal and has provoked a lot of quality commentary regarding the tradeoffs of clarity vs conciseness, implicit vs explicit, FK performance, etc.

But IMO you’ve raised the important long term consideration - do graph based schemas and query languages obviate the need to model foreign keys explicitly? If this JOIN FOREIGN proposal is an incremental step forward, what’s the next big leap?
Rarely, rarely, you hit the mythical 1 promile case where the blockchain works where other options don't.

But it's rare, and usually involves actual involvement with the creator, not some scummy mass production scam like Bored Apes.
This pattern is more of the norm than not for expensive high-tech cars. Rich people like nice stuff and are willing to pay maintenance and repair bills.
1. This problem is solved. In Amsterdam, the elderly and disabled can get very small, speed-restricted vehicles to use the bike paths.

2. How is a car safer than a train or bus? Definitely agree cars are more convenient given the current design of American cities. But consider if you had a nearby train station with an express line to downtown. By taking the train, you avoid sitting in traffic, get there quicker, don’t have to worry about parking, don’t have to worry about how much alcohol you consume before driving, and help your health by walking a bit more. Of course, few American cities have public transit that good, but that’s because American cities are designed for cars, not because public transit has an inherit problem.

3/4. You’re thinking about this from a car-centric point of view. But that’s totally arbitrary. What actually matters when considering city policies and society? Hunks of metal? No, people matter. The quality of life for people living in the city should be the utmost priority. Why is the person crossing the road? Well, it turns out that you need to walk to places even after you get out of your car. The problem is that humans don’t have a convenient transit option from one side of the street to the other, because cities aren’t designed to promote walking, despite walking being the most space, time, health, and energy efficient transit option for short distances.

Containment is totally irrelevant, imo. Sure, highways must be separate for effective transit. But it’s absolutely impossible to design highways to every single location, especially in extremely location-dense areas. We’ve attempted to do that with the so-called “stroad,” and it has been a massive failure. Those multi-lane roads by strip malls and chain stores are very dangerous for drivers because cars can’t be contained, and that’s without hardly any people walking around. To avoid that, you need to design walkable areas for “destinations,” which completely deprioritize cars.

Also, traffic is irrelevant. The purpose of transit is to allow people to get from A to B. car traffic exists to allow that transit. Forms of transit with large vehicles self-create their own congestion. (Like cars) Some, like buses and trains, can be scheduled to avoid that problem. But individual people walking or biking can saturate a given space with significantly more people per second without creating severe congestion. This is crucial for cities, which is why it’s ridiculous that cars have been prioritized in city centers for so long. It’s such an inefficient transit option for dense areas in basically any way you look at it. It’s not even that good for drivers, since city driving is always dangerous, stressful, and congested.

Keep cars to the highways for medium/long-distance trips. But there are many better options for dense areas, and that’s where big cars killing people is a problem.
SQL is relational algebra, the core of relational algebra is Selection, Projection, Cross-products, Unions, and Set Differences.

SQL is a language that implements Relational Algebra/Relational Calculus
I think it could be both a user and an industry issue.

Lately I’ve been experimenting with treating many libraries as a starting point in some of my projects. Meaning I read and use the code, often removing things I don’t need.

So I fork and maintain my own lesser / crippled version (and hope authors don’t take this as passive aggressive criticism!). This helps me lower attack surface and better understand what’s going on.

This doesn’t work for everything obviously. I’m not forking an OS or database, so there are still lots of black boxes, but for some stuff for I’m liking this approach.

Now if another dev inherits my code I doubt they’ll see it my way. The industry wisdom points at simply assembling libraries and only writing your specific business logic. So what if you use a library to do one thing that just happens to do 100 other things (this having a much larger attack surface and bug potential)?

I don’t know yet if I’m being foolish or if I’ve stumbled on some ancient programmer wisdom I simply failed to grasp earlier. At least I’ll probably never run into a leftpad issue.
The spine on my Latin translation is far too tattered for me to crack open and scan an example page, but, yes. It's very, very simple and easy to read.

One of the peculiarities of the translation, that makes it so simple to read, is that it opts to use genderless words where possible. Using words like "illi" instead of "eae" for example.
Interesting that it's inside VS Code.

Quite an extensive "plugin".
I had a hood come open on a car I was driving once. It was definitely some scary shit. Luckily, I was on a long, straight road, and was able to decelerate in a controlled way and pull off the side of the road.
Germany has a massive corruption problem on the higher levels.

It's not as visible for outsiders, because nations with corruption issues usually also have police and office workers essentially doing shakedowns to do their jobs, and that's not really a thing in Germany.

What is quiet widespread is politicians and office worker enriching themselves either directly from budgets theyre responsible for or by doing things for corporations which pay them handsomely.
In a universe where foreign key index names are important we would specify better names.

I think stuff like “documents_by_user” as foreign key names and explicit index usage would improve peoples awareness of how indices get used and would generally be a positive
No one in this thread mentioned licensing or legal issues.

As an edge case, consider a CLI that solves a trivial problem but also turns the computer into a space heater via an always-on service. It will rightfully damage the author's reputation with the users and they'll avoid using that person's code again, but they won't sue of course.
Just a reminder that cars are recalled all the time and the only reason you are seeing this article is because it is Tesla. Any other manufacturer and this would be a non-story especially on HN.

Did Ford recalling 185k vehicles a couple days ago make the front page of HN?

How about Toyota recalling 200k vehicles also a couple days ago?[2]

Maybe Honda recalling 725k vehicles a month ago?[3]

EDIT: Lots of people are taking this as a defense of Tesla. That isn't my intention here. I am providing context to this issue. Someone who isn't familiar with the frequency that cars are voluntarily recalled is going to conclude that this is a bigger deal than if viewed in the context of the auto industry as a whole.

[1] - https://www.detroitnews.com/story/business/autos/ford/2021/1...

[2] - https://www.justicepays.com/news/toyota-recalls-over-200000-...

[3] - https://www.caranddriver.com/news/a38425033/honda-passport-p...
No, not "anyone", just average healthy people.

3-5% of the adult population have serious immune deficiency and are at very high risk (the vaccine has limited to zero impact on them). Everyone else (including children) getting vaccinated protects them.
Google working on replacing the open internet protocols with their own again.
You’re right, but it can still be fixed after the problem happens
Clint Burton / Hawkeye's Laboratory
Last time I moved I spent a fortune on double corrugated boxes. I bought a cardboard stapler and taped it.

Heavy boxes still needed support from the bottom.
That claim of yours could use some support. As a pedestrian who agrees traffic lights are there for a reason, I increasingly find crossing the street when I have the right of way to be one of the riskiest situations; many drivers like to make a right turn on red (while I am preparing to cross to the right of them) but are so invested in their plan that all their attention is directed to checking for the approach of vehicles from the left.

The sense of entitlement among some drivers just beggars belief. The other day I crossed the street with the pedestrian signal. Beyond the traffic signal (to my right) there were two police cars with lights on blocking one lane to cordon the scene of a recent accident and redirect traffic. While I was crossing a vehicle just casually ran the red light and nearly hit me. When I angrily pointed to the light indicating I had the right of way, they angrily pointed at the police cars, as if their presence somehow superseded the existence of the intervening traffic light.
> With the above proposal, it seems the foreign key name could be left out in the common case of there being only one fkey between the two tables too.

Yes, this was indeed my intention. The common case with only a single matching foreign key constraint would not require being explicit, but one could be if needed in a natural way.

JOIN films f USING FOREIGN KEY films_did_fkey
Believe it or not, Amazon Prime Video has a pretty large selection of documentaries. They are just hidden behind all the banners they throw at you for the mainstream content.
Thanks very much for that detailed explanation — it helps a lot!
An electric car with a stationary bike in it.

Yes. This is definitely the solution we need. There's no other way to get exercise whilst transporting yourself.
I tried Lexapro 6 years ago when I first attempted to work on this issue. I was prescribed some minimum dosage(I forget what). I will never forget the first day. I didn't feel happy or sad or even anxious. It was as if every emotion was stripped out of my head and instead it was replaced with perfect neutrality. Nothing mattered int he world anymore. I had no thoughts or opinions, just complete neutrality of thoughts and emotions. This also became my most productive week in years. The thought process was literally "Ok I have this task to do, let me do this task, I am done with this task, ok lets do the next task. Repeat until there are no more tasks." No breaks, no distractions were noticed while the task is being performed.

Unfortunately, the side effects were so bad I gave up after a week. Horrible nausea all the time. Such extreme fatigue that i'd sleep 16 hours and still feel exhausted. Not to mention other side effects that are not appropriate to discuss here.

I am considering trying this nightmare of a drug again because I still remember that productivity but man that first experience literally felt like poison was seeping into all areas of my body.
At least my state had a variety of non-age-related (self-reported) criteria for phases of eligibility including occupational and various health conditions.
This is incredible. Nice work. Would love to see the number of comments/upvotes
>“Typically, you’ll have two people unloading each truck. Where we want to get with Stretch is to have one person unloading four or five trucks at the same time, using Stretches as tools.”

GP is correct. 1 supervisor + 8 robots replaces 8 people.
Consumers tend to rate higher satisfactions with "luxury" goods (i.e., goods at premium prices, regardless of material quality or value) than they do with non-luxury goods. It occurs to me that that bias affects Tesla's reception as well.
I had the similar friend, swam everyday 10 laps at least. Never a blip during regular checkups. Organic Vegan

2 months after the second shot, hes perfectly fine
From the Scientific American article:

> the so-called normal distribution of statistics assumes that there are default humans who serve as the standard that the rest of us can be accurately measured against.

The time has come to ban the use of the normal distribution for human stats. End the bigotry!
as predicted in the early 1990s

https://www.youtube.com/watch?v=PI_Jl5WFQkA
There aren't any fundamental rights which require someone else to provide them to you. For example, your right to free speech does not oblige others to provide a platform for you.

Now, "rights" can be created by law, but those are a different meaning of the word. A more apt word would be one of "privilege", "license", "obligation" or "power".

For example, it is often said that the President has the right to veto legislation. No, he doesn't. He has the power to veto legislation.

The words right, privilege, license, obligation, and power are probably the most misused words in the English language.
Lets have disabled FK then.

postgre, seems to not have it, but the proposal could include also "disabled FK" part.

teradata, oracle, sql server already have option for FK "disable/no check".

https://docs.teradata.com/r/eWpPpcMoLGQcZEoyt5AjEg/df1PvVh6e...
https://docs.microsoft.com/en-us/sql/relational-databases/ta...
https://docs.oracle.com/cd/B28359_01/server.111/b28310/gener...
In Regression Tests, Conditionals = Complexity
When I was about 13 or so, my father brought home a foot-tall stack of Scientific American issues. He was a logger, but knew I was interested in science. This would have been mid-80s.

I read each of those, cover-to-cover, so many times. Barely understanding anything the first time; slowly increasing my comprehension over the months and years. Writing programs in BASIC on my C64 to recreate fractals, or simulate evolutionary processes. It really affected my life profoundly.

I say all that to just emphasize how heartbreaking it is to see what a trash magazine SA is now. In print since the middle of the 19th century, and ruined just in the last 10-15 years. It's a true loss.
No, motorcycle could go 25 MPH. Loaded trailer 2.5 mph. Sounds about right to me for urban areas :)
just a reminder that product recalls (especially vehicles) are discussed all the time on HN [0], and Tesla isn't somehow special for being mentioned here.

[0]: https://hn.algolia.com/?q=recall
As the other poster wrote, 100,9F is not particularly high. Here doctors recommend to keep fever below 39° (102,2F). When my child had the flu, we achieved this by alternating between Ibuprofen and Paracetamol in order to keep the doses low.

All the best to you.
At what point do you stop assuming people are arguing in good faith? Because it seems unbelievable that everyone is.
and then later in their life they become impossible to fix at a reasonable price.

somebody might sell you a mostly okay running older BMW 7 series for $4500, fully loaded with all the options but take a look at the parts and labor cost to fix something on it.... you might as well throw away the whole car.
There's more to the story. Ford, Toyota and Honda makes significantly more cars and models than Tesla.
Not to mention the headlights. I can deal with most of the rest of the stuff, but the headlights are downright dangerous to all other drivers around. They're rarely correctly angled, so due to the base height of the truck they'll frequently be right at eye level for smaller vehicles. On roads with short or no barriers, they also blind oncoming traffic in addition to whoever happens to be in front of them.
I’m not trying to @ you here, but… are you sure you really know?

Cryptographic signatures offer gold-standard, definitive proof of authenticity/non-repudiation. “Trust of content”, as you put it, is the problem they solve.
Oddly we had the current President and VP also saying they’d never take a Trump vaccine[1]. So it’s truly very political for many people and not complete science based even when now they claim to adhere to science. To wit:

September 6, 2020: Kamala Harris says "I think that's going to be an issue" when asked if she would get an approved coronavirus vaccine.

July 28, 2020: Joe Biden suggests the coronavirus vaccine won't be "real" and may not be "safe."

August 6, 2020: Biden says the vaccine is "not likely to go through all the tests that needs to be and the trials that are needed to be done."

September 3, 2020: Biden asks "Who's going to take the shot? Are you going to be the first one to say sign me up?"

September 7, 2020: Biden said he would take the coronavirus vaccine "only if we knew all of what went into it."

[1] https://www.presidency.ucsb.edu/documents/campaign-press-rel...
Reuters is a much better source of information. Look up the ownership of The Independent.
Since you're making broad, sweeping generalizations, I can play. There are 7 people in my social circle who are Tesla owners but not fiercely loyal. They are not rich. And none of them have experienced more than minor issues in their ownership.
blue noise dither: http://www.imaging.org/site/PDFS/Papers/1999/RP-0-93/1786.pd...
This is really good! Would be great if there was a way to rename the created tables!
I, personally, feel like this is a rather pointless addition to an already somewhat bloated language. It it isn't saving that much typing (we have NATURAL JOIN's already, nobody is using them), is kind of inconsistent with other language principles (we should be able to join anything to anything if we need to, see SQL-89) and limits JOIN flexibility (you don't have to join with "=" operator, JOIN's supports different types of conditions and are equivalent to WHERE clause)
> Yeah maybe, so what? No shame in that; everyone's gotta work somewhere. You're also ruling out people who are there for personal reasons, or because they genuinely like the place, or they don't have any "higher" aims.

No shame indeed. It's just weird that they brag about their best interns leaving for better companies. Usually, the point of having internships is to attract and retain talent.

> Last time I checked, Apple or Tesla (or Google) weren't planning to sell liquor in Ontario. They're not competitors.

They are when it comes to tech hiring. By their own admission, they hire from the same pool.
A missing comma after "rescued" perhaps? With it, it would mean "they returned", rather than "they have been returned".
Hunger was something we read about: lockdown leaves Vietnam’s poor without food
> That is, I think it's fine for participation to be refused to people based on their vaccination status

This doesn’t make sense either. You are already free not to participate. You can’t demand non-participation. Especially as it is not proven that vaccination prevents transmission.
I have no opinion about why the name of Reiser is still used, but in your first link there is no mention of Reiser.

In an Algolia search I can't find any conversation about a name change on HN:

https://hn.algolia.com/?dateRange=all&page=0&prefix=true&que...
[dupe] OneZoom tree of life explorer (via Anton Petrov)
Tesla's have limited rear-view visibility due to aerodynamic shape. Not a big problem, but once you get used to backing out while looking at HD screen, lack of it is quite a hindrance.
If you visit Massachusetts, and go to Battleship Cove (https://www.battleshipcove.org/) in Fall River, inside the USS Massachusetts you can get up close and personal with a WWII era firing control computer. It looks both very sophisticated and antiquated at the same time.
Then it should display a downward pointed cone as a daytime signal and regular power vessel lanterns in the dark.
You're flipping the frame of reference for each case which is what makes it confusing. Staring up or down a waterway, opposing traffic are on opposite sides (left or right). From each boats perspective, they are on the right side.
Video discussion/intro here: https://youtu.be/4DJqw06xtNo
While I wish there were a way to easily refactor queries when making these changes, this is not different than it works for renaming/dropping a column..."In the worst, an re-name/drop of a column will end up breaking a bunch of queries, which is insane."