skysight-inc/HackerNews huggingface dataset:
> constantly rebuilding from massive dependency trees and all the other inefficiencies we put up with because it takes less dev effort that way and our performance budgets are being met either way

I've been trying to minimise redundant calculations in our CI/CD workflows, but none of our tools seem to like that.

Docker rebuilds all downstream if one bit of a step changes, GitHub Actions doesn't let you cache on local runners and requires uploading everything to their size-limited cloud cache.

I'm looking for better ways but of course no service advertises their energy efficiency. That tells something about the industry's priorities.
You may end up doing this anyways if you have any application code that needs access to delete hooks, or access control varies across objects. At this point, you are probably using a ORM instead of direct queries, and place logic that could be in the db instead at the app layer.
What exactly counts as fearmongering for you? It seems like +6.37M people have died from COVID so far, most of them being in the US (which has more deaths from COVID than India, which has a larger population than the US).

It makes sense for a lot of people in the US to be scared of COVID, it is a dangerous, infectious disease after all.
This obsession with stock prices and trying to trade on this kind of stuff puts such a spotlight on how humans suck so bad.
I think we'll merge that discussion hither, because this one was posted earlier and has the more substantive source.
The cloud billing risk that scares me most
Assuming you're using a modern database, replication is done with paxos/raft and they are formally proven to not allow this to happen as both edits/deletions are both just entries in distributed event log.
Nobody cared about climate change 20 years ago, at least not enough to build nuclear power. People laughed at Al Gore and called it a hoax or denies it.

People only really started abandoning nuclear power with the advent of fukushima.
i wonder if they think they can continue growing the self driving part with this approach. you will get the hacker types, but dont see this going mainstream.

the way they get around regulators, is they are selling the hardware and the users are responsible for downloading and compiling the software. they support alot of cars but they are utilizing vehicle sensors off the can bus and adas vehicle commands. if the manufacturer decides to encrypt or restrict this then the approach wouldnt work.
> That doesn't improve Brazil, does it?

I happen to believe that it does.

In the worst case, we get to keep the forest.

> Sovereignty means that nobody outside of Brazil gets a say without offering something major in return.

First world countries used to give us money for keeping the forest but the current government (prior to 2019, "the annual donations to the Amazon Fund have amounted to nearly $1.3 billion" [1]). We could get back to that.

However I also happen to believe that, at best, the deforestation part is not important for Brazil's economy at all.

Several others have mentioned [2][3] (and I agree with them) that the deforestation part is actually damaging to the economy and to the livelihood of law-following Brazilians, and is borne out of illegal activity.

The current government could just start following the (Brazilian) law and the issue would disappear. Ah, but police is expensive, you say. Well, they could have used the 1.3 billion from EU/US. Maybe a new government will be able to get that back, one can only hope.

[1] https://gizmodo.com/big-donors-are-pulling-out-of-brazils-am...

[2] https://news.ycombinator.com/item?id=32154495

[3] https://news.ycombinator.com/item?id=32152630
Yeah the jet stream is clearly slowing down because the temperature difference with the arctic is lower than before. But to be honest I don’t care much about my karma here. Thanks for the nice answer in any case
Your taste in database design is probably nor gdpr compliant, i hope you don’t work in the eu.
I've definitely seen soft delete work in practice. A couple things: for small data sets you can implement the naive deleted_at you can hide the records from your users by forcing them to use a view. You can also handle updates on the view to prevent data conflicting with deleted data if you need to.

For foreign key constraints you can set the foreign key to null and orphan the records if the relation is deleted. You could also hard delete them in this case. It depend on your use case.

When the data volume grows or the ratio of soft deleted to normal records is high, you should consider another solution. One solution you suggested, moving the record to a deleted table is a fine one.

The other solution that I've used successfully is to journal your deletions in another table or system. For smaller volumes having an audit table Journaling the data and storing the pk, fkeys, and a serialized version of the record, json works great in postgres, works well. For large volumes or frequent deletions something like Kafka or PubSub work better.

You may very well find others interested in consuming your audit journal to track changes. Updates and even inserts fit great in the more general case.
you're not self-hosting. you're using a managed hosting product. Digital Ocean (an entity which is not your self) is hosting things for you. On top of that this blog is hosted by Substack (also not your self). nothing intrinsically wrong with either of those, but if you simultaneously espouse the greatness of "self-hosting" and the awfulness of "cake-eating corporations" then this comes off as egregiously phony.
I follow along with written words and listen at the same time. The apps I use automatically scroll the page and keep the current text in focus.
OpenEMR version 7.0 has achieved ONC 2015 Cures Update Certification through the SLI Compliance Certification Body. This certification is vital for medical practices in the United States.
I guessed it was because you needed to essentially be a studio to produce Quibis and you could create a TikTok from the app. And yep. That's a large part of it.

If you want to succeed socially, you have to allow the masses to be generators of content. YouTube and Twitch were grown along these principles. Now they're more on the produced side of things, but in the early days, it was grab a camera and go.

And you can still get a lot of mileage out of that setup on those platforms.
> Rossman said more time is needed because it is “one of the largest take-private deals in history” involving a “company that has a massive amount of data that has to be analyzed. Billions of actions on their platform have to be analyzed.”

Why wouldn't you do this before making an all-cash offer at a significant premium above what any analyst would have valued it at? It couldn't just have been a ploy to cash in on TSLA stock before it fell from its unsustainable heights could it?
> But, because it doesn't actually prevent a cloud provider from competing with you with your own software, there have been a few (non-open source according to the open source definition) licenses created that specifically bar this sort of use.

Excellent note, and very accurate!

I can start a company that sells your AGPLv3 software tomorrow. I just have to comply with the terms & conditions. If I'm doing absolutely nothing but operating the software without change, I can satisfy the license by saying "git clone github.com/your/software", done.

Where things get murky is on the concept of linking/derivative works. If I operate a cloud service and make changes to your software to make it use my cloud systems efficiently, those changes have to be open-sourced under AGPLv3. Does that leak too much proprietary information about my systems? Very possibly. That might be enough to stop me. But if I keep going down that road, I end up risking a legal argument that our systems have become so tangled together that parts of my software fall under AGPLv3.

For most companies, this is simply not worth the risk. MongoDB took it one step further with the SSPL:

> you must make the Service Source Code available via network download to everyone at no charge, under the terms of this License. [...] “Service Source Code” means the Corresponding Source for the Program or the modified version, and the Corresponding Source for all programs that you use to make the Program or modified version available as a service, including, without limitation, management software, user interfaces, application program interfaces, automation software, monitoring software, backup software, storage software and hosting software, all such that a user could run an instance of the service using the Service Source Code you make available.

This is basically the anti-AWS license: for AWS to run MongoDB proper, they'd need to expose source for huge amounts of their backplane. It's also not open source under almost anyone's definition.
Comments moved to https://news.ycombinator.com/item?id=32145324, which was posted a bit earlier. Also the Github page is probably a better source than the Twitter one.
I had the same reaction to the 'code leakage' section, but 'foreign keys'? You can't reference a view; so you either don't use them (fks) or they point at the underlying table and you have the problem described.

You could have views that say 'thing I have a foreign key to is not deleted' of course, but that sort of seems like 'code leakage' again, just in SQL this time.
"fishing for clicks" from a "contrarian perspective" usually means "misinform the public for profit". Giving the best available reporting on what's currently known about a disease that has killed millions isn't "fearmongering", even if as we learn more some reporting needs to be revised.

Equating the two is just nihilism or solipsism, as if there's no reality, just people saying things.
Ha, and then there is the opposite regulation that you have to delete user data.
I’ve been curious with the functionality of short beds - the only advantage I can think of is a shorter wheel base for towing/maneuvering a trailer. Otherwise they make no sense to me
That doesn't solve the foreign key problem. You can still easily have a reference to a record that is "deleted"
People will go to Epcot and “drink around the world” for example
Pretty engaging, nice job!
The “scoreboard” button that appears after you submit each answer was confusing for me. Could it say “next” instead?
> renting a car is not cheap

U-Haul pickups are $19.95 + mileage. For me personally, I think that'd come to something like $50 for a single hardware store trip, plus inconvenience. So far I haven't had to do that, so I can't vouch for that number to be accurate.
But, assuming you don't really need the data, why make your queries more complex and instead just actually delete the data?
AutoTLDR, which uses smmry.com[0]

[0] https://www.reddit.com/r/autotldr/comments/31b9fm/faq_autotl...
I'm sorry, but that's a whackadoodle approach to engineering. 40C is well within the range of expected temperatures, and the men who designed it failed epically. There have been heatwaves in the UK since 1911 where the temp approaches 40C.

https://www.theguardian.com/uk-news/from-the-archive-blog/20...
Ah, my field is Inductive Logic Programming - a sub-sub-sub-sub field of program synthesis. But I need to know the basics!

I think Copilot can be used very effectively, as long as its capabilities and their limitations are communicated clearly. For instance, I think it can make a great boilerplate generator, as long as users stick to short code snippets.

Well, I don't know about replacing programmers. I think that's Sci-Fi, for the time being, and for a while longer still. What I'm more interested in is creating tools to help programmers do their job. Copilot does that already, btw, I'm not dissing it. I'm just pointing out it doesn't represent a sudden shift in capabilities, to be clear.

>> (One of the reasons I like Schmidhuber is that his goal, since early on, is to "Create an automatic scientist, and then retire.")

I didn't know Schmidhuber had said that. My thesis advisor, Stephen Muggleton, was part of an interdisciplinary team who created a robot scientist that can develop its own theories and then choose, and run, the experiments to prove them:

https://en.wikipedia.org/wiki/Robot_Scientist

Another one of those things that are not well-known, I guess. I wasn't involved with that, btw, but I think recent advances could make for a much more powerful system. I am considering something similar as a research project, post-doc.
> Instead, we rolled forward by creating a new app, and helping them copy environment and data from the deleted app to it. So even where soft deletion was theoretically most useful, we still didn’t use it

I don't get this statement. You wouldn't have had the env or data without soft delete? You did use it!

I would say, soft delete isn't a tick the box and done solution as many ORMs make it.

You need to consider the data model, and adjust your queries to that.

It may make sense for a product to be deleted, but orderlines still able to access it to display product name etc.

With blob data, I tend to move that to a "bin" with a 30-60 day grace period. Customers know quickly reporting, we can fully recover, while outside that time they'll have to provide images etc. It's a decent compromise.

Reuse of unique fields is the sticking point I run into often, as mysql interprets null as not clashing with other nulls so composite uniques using the ID and deletion date don't work.
I feel exactly the same way about PCMCIA.

It is my all-time favorite form factor.
There was apparently a presentation by Chandler today on Carbon: https://twitter.com/code_report/status/1549383435642445824
Yes-I really tried to watch Quibi shows and they were really bad. Or better to say: nah… If they made something like Moon Knight or Peacemaker they will be fine: even with ackward implementation.
TikTok is pretty addictive even without an account and reccomendations. The content is funny and those fast dopamine hits are too much. I don’t trust myself to have it on my phone.
Because it's about the business and revenue is what's important. The product is "just" the thing you sell to get revenue. A business with $50k MRR is far more interesting than one with $5k MRR even if the 50k/month business is using 50 year-old technology while the $5k one is bleeding edge.
I use NaturalReader paid subscription with high quality TTS voices for web browsing and the free iOS version of Voice Dream reader for ebooks and mobile browsing.
That’s a good point though. Many tell lobbies are at work, but I think many people can’t take such a harsh change, and I can understand that. We have to focus on changing step by step. The level at which renewables are taking over in many countries is giving me hope.
> we're all in a space where science is unquestioned

Please consider the contradiction in this quote
It's not really irrational. Journalism is plagued with issues where journalists misconstrue a topic because they don't have the requisite background knowledge to adequately cover a topic. This becomes immediately obvious when you read an article on a topic you're knowledgeable about (see Gell-Mann amnesia effect). Expecting a site with more subject matter experts to have less of these types of errors seems perfectly rational.
No mention of the fact that it takes two earners in the median household to see the raise in inflation adjusted outcome. In fact, inflation adjusted wages for the middle class has been flat since the 1970s. So it is even worse for the middle-class than portrayed in this article.

See https://www.pewresearch.org/fact-tank/2018/08/07/for-most-us...
>Please do not take motorized 2 wheels lightly, an e-bike can kill you very easily.

So can a conventional bicycle. Roller skates and pogo sticks can too.
these might be the kindest words i've ever gotten in a hacker news thread so thank you! :D

we've actually built an app for reading articles and ebooks (and RSS and PDFs and email newsletters and Twitter threads): https://readwise.io/read

still in private beta but we'll be entering public beta before summer is over!
Mind cluing me in to who "smoothiex12.blogspot.com" is, and why "Russia makes a lot of energy and aluminium" means they can produce sophisticated circuitry and fancy weapons in suddenly massive quantities?

They can't even make cars internally right now (https://www.drive.com.au/news/russias-biggest-carmaker-lada-...) after first dropping antilock brakes and airbags (https://www.politico.eu/article/war-and-sanctions-force-lada...).
For the control plane part of Crunchy Bridge, on day one I decided to go with the deleted_records table that is mentioned at the end of this post. It's been great. No need to keep around dead data that no one ever looks at.

We don't need to have `where deleted_at is null` on every single query. But the best part though is our actual working data set of records we actually care about is tiny compared to the deleted cruft that would have otherwise been just sticking around forever. Backups and restores take no time at all. It's really cool that postgres lets you have conditional indexes on things, but it's even cooler not to need them.
No - they made it clear that they will use military force if US invades Taiwan. They also made it very clear that they want peaceful solution, because their economy doesn’t depend on waging wars.

Feel free to prove otherwise; note that Chinese statements are quite often misquoted.
Merkel was in office for 16 years. Schröder 8 years. Kohl 16 years.
The question is, would it be a crime to build hardware that circumvents the encryption/restrictions. If not, they can keep going.
I love the idea of Comma. It makes a lot of sense to have an after-market instrument to drive your car. There's no reason you have to re-build a car. You can probably get very far with just a few sensors and connecting to existing car controls. Humans drive perfectly well without lidar or a large number of cameras, so a bot should be able to as well. You can tell how full of shit a company is by the number of tangential things in their mission statement. If they want self driving, and all electric, and made from recycled parts, and give back 2% to the environment, they're prob full of it.

Comma is taking an incremental approach which I like. Most driving is done on long monotonous roads going straight. If you can eliminate that portion, you'd add huge value.

The other cool thing is that its completely open-source (except for code used to train the models). You can install it on your own device and run it, or fork it. I read a high percentage of users use custom forks of the software. They also have a discord where you can talk to the engineers and people working there if you have any issues or questions. Imagine calling someone from Toyota and just being connected to a auto-engineer?

There's a lot to like about Comma. There are few businesses out there with this mindset. I hope other companies take their lead and think outside the box and stop worrying about the next round and just get some hackers together and build something people want.
Which is a decentralized, distributed ledger, so... banking! :)
> That doesn't work the way you think it works.

Vice versa. I know this.

Which is why I'm arguing in favor of missile swarms, rather than hypersonic missiles. A missile swarm will accomplish the same thing as hypersonic, in that it will overwhelm the enemy's air defenses and allow you to prioritize specific targets with high chance of success.

HIMARS rockets, launched 6 at a time (or at least, 6 in a minute), seem impossible for the Russian army to stop. They may have some systems shooting down some of these missiles, but the Ukrainians are clearly hitting a lot of important targets with just 4 HIMARS systems.

Just saturating with 6+-HIMARS coordinating and massing fire would probably be cheaper than deploying hypersonic missiles (!!!). Don't get me wrong, HIMARS are expensive... but hypersonics are __REALLY__ expensive.

Future "Swarms" of missiles can enable missile-to-missile communications (who is still alive? Anyone sensing enemy RADAR signatures that we need to dodge? Etc. etc.) to improve overall missile performance.
These are still versioned in many serious finance systems
In the short term, you can use resistive space heaters. This is, to be sure, 2-3x times more expensive than heat pumps, but given the cost of gas, might still be worth it. Point is, nuclear helps, and a couple of extra gigawatts day and night makes a difference.
And back to the original question, how do you copy the font size from the breakpoint rules, the margin from the second set of rules, and the font family from the third, with a callout to the breakpoint, in a single click using Firefox dev tools?
> It emits about 4% of greenhouse gases [...] But the volume itself is not meaningful - the gases used by AC units are extremely powerful - up to 750 times the greenhouse effect of CO2.

Do AC units emit these gases? Aren't you mixing up CO2 from electricity production and gases that stay internal to the unit?
The name Quibi sounds like a Chinese streaming site for movies. I think that might have an effect on a western audience.

Ironically it was backed by Jeff Katzenburg while TikTok, the actual Chinese platform became successful.

Branding is important
It's unfortunate you see it this way..

Actually, I recommend you do the same. This has helped me to-

- find them more humain when I see these people in family gatherings and other life events

- find that we have some other ideological intersection (vegan, promoting donation to help animals etc..)

It's very easy to de-humanize someone on the internet, this has helped me to understand these are real people, and not "bots" who are paid to say things I find hard to believe anyone could believe in..
It is older and not unique to Sony among Japanese manufacturers.

Nikon, Canon, Minolta, Olympus, and Pentax camera lenses…and Mamiya and Bronica too now that I think about it.

And Kodak color film might be the prototype of vendor lock in for consumer products.

Black and white Kodak roll film formats, now that I think of it, are even older still.
The killer for me was that it had a direct USB CD-to-MiniDisc cable to transfer CDs, with original quality, proper tracks and all. I would have loved to use it!

Unfortunately once opened, the user manual said something along the lines of “Press he record button, plug the USB-to-jack wire, and in 45 minutes, done! It will recognize the tracks by noticing the silence between them, hopefully you don’t have silences in the music, right? Also don’t fuss too much about the white noise due to impedance, it’s a high-quality transfer we pinky-swear.”

I swore never to buy anything from Sony since 1999. I relapsed in 2016 for ONE purchase. And swore again:

Never - buy - SONY.

EVER.
Pretty sure that middle class Americans rarely flew before deregulation in the late 70s. My mom's middle class parents packed the kids up in the car and took a few epic road trips to visit family in other parts of the country in the 60s - flying would have been unimaginable.
Sure, but I just think it's all a bit more nuancend than the way the OPs make it to be. There's always a lot of speculation that goes both ways: either AI is just around the corner, or it's never gonna happen. And there's plenty of opinions and educated guesses in the middle, always.
Exactly.

This is a very weak argument for something that is so damaging as letting the forest be destroyed for what is virtually zero economical gain to the population.
While the right wing media in the UK ignored the climate crisis in their coverage and instead focused on the “positive” side with front pages full of children eating ice cream and people at the beach.