skysight-inc/HackerNews huggingface dataset:
Also didn't TikTok have some kind of creator's fund while Vine had "monetize somewhere else," which led to an exodus of serious creatives?

In any case, it seems weird that they completely gave up, and even weirder that they Twitter didn't start chasing once TikTok figured out the formula in this space. Network effects are a thing, but with the prospect of a TikTok ban flying around and general unhappiness around aspects of its algorithm, it feels like there is room for a challenger with the strategy of "wait for TikTok to stumble."
That changes things. I was just going by the article.
You appear to be correct:

> The RAF didn’t specify why it suspended flights, but a spokesperson said “the runway has not melted” as early media reports indicated.

https://www.cnbc.com/2022/07/18/london-flights-suspended-aft...
Not only that, a clean room isn't enough. You need to hire programmers straight out of college who have never looked at GPL code. Just kidding, it's even worse than that - most developers right out of college have read at least one character of GPL licensed-code. Even stack overflow is tainted, because the questions and answers there were written by people who read GPL code.

It's best to exclusively hire race car drivers and fedex delivery workers to your software development workforce, as they are statistically least likely to have been exposed to GPL code (per bureau of labor and statistics).
I'm surprised the law's developed enough for that, I'd think it would be on the (non-)driver either way.
You're missing the word "web" in there a lot of times.
Views are a simple solution to this problem. Pretty much all moderns RDBMSs support updatable views, so creating views over your tables with a simple WHERE deleted_at IS NULL solves the majority of the author's problems, including (IIRC) foreign key issues, assuming the deletes are done appropriately.

I feel like a lot of developers underutilize the capabilities of the massively advanced database engines they code against. Sure, concerns about splitting logic between the DB and app layers are valid, but there are fairly well developed techniques for keeping DB and app states, logic and schemas aligned via migrations and partitioning and whatnot.
Unusual IMAP sign in activity reported in Microsoft account
Luisa Rodriguez on why global catastrophes seem unlikely to kill us all
I disagree. Disney are EXPERTS on making magic happen. I fought vacationing at Disney tooth and nail, it was so expensive. It was one of those life long memory vacations that will sustain you when the kids are gone. My fair memories are far less intense years later.
Ya it’s insane and unfortunate how the chicken tax wrecked trucks. Was it really directed towards VW though? I thought it was more against Japanese auto makes.
This was it IMHO. Vine was a bit too restrictive. While there is a case for very short video it makes production hard and you end up starved for content. I think Vine might still be around if they had set the limit at 30 seconds or a couple of minutes. Still tight, but not like a straitjacket.
I just went to the best Giants game of the season for $25
Isn't the CMB far more uniform than we would expect it to be if the speed of light was not the same in all directions?
Can you share the lists you mentioned?
It would also be easy to prompt you to consider rewording if your title has a question mark. There would be some false positives, but I'd think the vast majority would benefit from rewording.
Interesting article, good to know the historical context.
Maybe so, but sticking to the site guidelines takes precedence, and you can always make your substantive point without breaking them.
"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."

But... weren't you using all those env and data info from the soft-deleted set?

I've typically been using soft-deletes for most projects for years. People have accidentally deleted records, and having a process to undelete them - manually or giving them a screen to review/restore - has usually been great.

Yes, if there's a lot of related artefacts not in the database (files/etc) that were literally deleted, you may not be able to get them back. But that's an ever greater edge case in projects I work in as to not be a huge issue. We probably have some files in a backup somewhere, if it's recent. Trying to 'undelete' a record from years ago - yeah, likely ain't gonna happen.

People are used to 'undo' and 'undelete'. Soft-deletes are one way to provide that functionality for some projects.
I also had my fair share of repairing home appliances (trying to anyway) and in my N~5 sample size I was not only limited to failed control boards.
But having seen those control boards I am honestly surprised that they even survive the warranty period. They are that cheaply and badly made. From the circuit board itself to the components used. And of course not designed to be repairable at all. They have more in common with a cheap calculator than something that controls kWs of power. But allowing the manufacturer to use leaded solder would have made zero difference in their reliability.

People absolutely can build reliable electronics these days, but it will be slightly more expensive than not quite so reliable electronics.
Higher profit margin has a higher priority than making sure the product survives long after the warranty period has ended.
Especially if the consumer only looks at the initial price without taking into consideration how long it will last. Which is also hard to do without reviewers tearing the machine to bits. Being expensive does not mean it is actually any good and will last a long time.
Not exactly - you can renew them for 12 months (or less) at a pop for free "forever"

Or you can register them for multiples of a year (starting at 1 year) for money
This does appear to be the case:

> The RAF didn’t specify why it suspended flights, but a spokesperson said “the runway has not melted” as early media reports indicated.

https://www.cnbc.com/2022/07/18/london-flights-suspended-aft...
I'd argue that "pro-science" is absolutely a position. People holding this position might argue that science isn't the best way to learn information about the world (e.g. divine revelation or intuitionism might be preferred), or that the application of science to find solutions to our problems leads to bad outcomes (e.g. Luddites or Mennonite/Amish communities).

Whether we agree with that position or not is a whole different beast, but it absolutely is a real and tenable position that people can and do hold.
Sounds like TUKE (or any other uni in Slovakia). I've studied Cybernetics/AI there from 2008. Your comment is eerily familiar to me, even though I don't think I attended a course with the professor.
Practically, high albedo materials (essentially they reflect a lot of light but aren't necessarily mirrors because they do scatter the direction of that light) can reduce building's HVAC energy consumption. They can also effect city level microclimate (mitigating the heat island effect).

It takes a lot of high albedo area to effect the overall climate. For example, melting ice caps do decrease the albedo of parts of the Earth, accelerating climate change. Large scale increases to Earth's albedo in the form of space mirrors were seriously considered as options for global warming mitigation as late as the Obama administration. However, the risks of unintended modifications to the environment (e.g. crop failures, unpredictable weather) are generally considered too great. At present, space mirrors, with an estimated lifetime cost of $5 trillion for 50 years of cooling, could be a decent "last resort" option compared to the possibility of spending hundreds of trillions upfront to permanently solve the problem with carbon capture (although cost estimates vary widely based on the amount of CO2 that needs to be captured).

Other options include stratospheric aerosol injection (https://en.wikipedia.org/wiki/Stratospheric_aerosol_injectio...) which could minimize the effects of climate change for as little as $55 billion/year, and marine cloud brightening (https://en.wikipedia.org/wiki/Marine_cloud_brightening), which could cost as little as $5 billion/year. Possible side effects might include ozone depletion and acid rain for aerosols. Marine cloud brightening could cause weather changes.

So yes, you could manipulate albedo but it will always come with side effects and costs.
Is the same true in mass surveillance?
Personally I like no delete designs, which give you a full audit history of changes. This is similar to generally accepted accounting principles. https://en.wikipedia.org/wiki/Generally_Accepted_Accounting_...
I presume the availability of 4x4 helps with trucks as well? Does for me at least
I just wanted to touch on the fact that eliding soft-deleted rows from queries is really, really easy - this article makes it out to be a constant headache but here's my suggested approach.

ALTER TABLE blah ADD COLUMN deleted_at NULL TIMESTAMP;
ALTER TABLE blah RENAME TO blahwithdeleted;
CREATE VIEW blah (SELECT * FROM blahwithdeleted WHERE deleted_at IS NULL);

And thus your entire application just needs to keep SELECTing from blah while only a few select pieces of code related to undeleting things (or generating reports including deleted things) need to be shifted to read from blahwithdeleted.
Sounds like an interesting mashup of The Personifid Project, The Time Machine, and the TV series The 100
Dragon speech? Has integrations like Evernote. I know that's online but they have apps too.
Delayed inspections, rivers drying out affecting cooling, cracks in reactors, unusual corrosion, billions in debt after a Rosatom deal, etc.

It's a very nuanced issue, I don't think it's very informed to say it's just due to delayed inspections... The inspections were what found cracks due to corrosion, repairs are taking really long.
Was China Behind Kiribati’s Withdrawal from the Pacific Islands Forum?
Crazy Elon Musk Backers
My experience is that soft-deletes are blunt tools bridging the gap between hard deletes and event sourcing (capturing all the changes against the table, in a replay-worthy stream).

Event sourcing is hard – because the engineers responsible for setting it up and managing it aren't generally well skilled in this domain (myself included) and there aren't a wealth of great tools helping engineers find their way into the pit of success.

The downsides of soft-deletes (as identified in the article) are numerous. The biggest problem is that it appears "simple" at first blush (just add a deleted_at column!), but it rots your data model from the inside out.
How do you account for maintaining integrity in the archive?

E.g. you have 3 users sign up with the same email (a unique field) one after the other with deletions in-between each sign-up?
An Overview of the Linux Desktop for Novices and Non-Users
Clouds and rain occur when dust and airborne micro-organisms serve as crystalization sites for water vapor.

There's actually a positive feedback loop where the more life there is (in, for instance, a rain forest), the more rain occurs there, as plants emit various pollens and atomized oils into the air.

Similarly, if you destroy ecosystems and decimate biomass, there is nothing in the air for water vapor to glom onto and you will soon have a desert.

I have an ongoing disagreement with a good friend that the drought in Lion King was caused by Scar's poor ecosystem management, she insists it was coincidence.
Freenom has free TLDs (.tk, .cf, ….)

The cheapest over time will be .de with as less as 4€ a year depending on the registrar. The cheapest first year domain used to be .xyz with 0.99$ at Namecheap
It constructs a number that is not divisible by any member of the list, so either it is prime, or there is some other prime that is not a member of the list. Either way we can grow the list.
We switched a lot of tables to soft deletes so we could replicate those deletes into our data warehouse. You can also use bin log replication for hard deletes, but every schema change would break it.
Get an ute then?
I've used Soft Deletion so many times so I'll say it's been worth it. I believe using an audit table would have made recovery more difficult for me. Anyways take this advice with a grain of salt. It's only one guy's opinion. As is mine.
I feel like I need to use clapping hands emojis to get the point across, but I will refrain.

---

The US government is more ethical and more respectful of the rule of law and human rights than Russia or China.

Let me paste it in again, so we know it isn't a typo:

The US government is more ethical and more respectful of the rule of law and human rights than Russia or China.

---

The US government is not perfect. Portions of the US government are a danger to the rights of some people, particularly civilians in the middle east. Regarding "cyber", it has several major stains on its history, including PRISM, XKeyscore, warrantless wiretapping, and the current president's support of the Clipper chip in the 90s.

I support privacy protections on mobile devices and mobile apps, and support in general stronger regulations against the collection of personal information by tech giants.

I resent Meta and Google for the amount of data they collect about me and everyone I know with any Android device/Meta app installed.

Every statement I have made can be made while non-hypocritically supporting the statement by the FCC regarding TikTok. It isn't just economic protectionism - it's national security. I don't think a Chinese politician or military official should have Facebook or Instagram installed on their mobile phone, either.
Couldn't a malfunctioning sync process undo a soft delete as well?
Yes, clouds.

With a clear sky, you're radiating (based on your own temperature) out to the blackness of space, which is radiating back at 4 Kelvin. Which is to say, it's contributing basically nothing. You're just giving up heat to the cosmos.

With a cloudy sky, you're radiating (based on your own temperature) out to the bottoms of the clouds, which are reflecting your radiation back to someone else on the ground, and their own heat is reflecting back to you. And such. The cloud looks white in the daytime because it's very reflective, so it acts like a mylar blanket to hold the heat in.
Opponents of SDF base on Japan islet fret as it puts down roots
Ok, but over a million people in the US died from covid and even more with permanent damage.
Are New Geospatial Formats Useful?
Yes, I messed up. Thank you.
> Musk’s lawyer, Andrew Rossman of Quinn Emanuel, argued the expedited timeline was far too aggressive for his team to review the massive data trove at Twitter, which Musk wants to review to verify the percentage of spam accounts on the platform.

Isn't the onus on investigating if a company is fit for acquisition is the one wanting to acquire the company? Unless Twitter is knowingly lying about its numbers (and I don't see any evidence that it's intentionally lying about the bot numbers), does Musk even do a proper due diligence here?

I've already seen a similar case (outside of Delaware jurisdiction) that forced a VC company to either pay a breakup fee (IIRC 80% of the original price) or acquire the company, but I'm not sure of Delaware particulars.
Or requiring weight reductions on the aircraft itself (fewer pax, lower fuel, less cargo).
What happens when a reservoir goes dry
Interesting, hotz really went into stealth mode since a few years back. Much better I guess.
The author didn't mention it, but restoring data from a database backup is a perfectly reasonable way to handle undeletes. By this I mean the situations that are "Oh crap, we didn't mean to delete that!" instead of usual business operations.

I've probably restored data from backup maybe 4 times in my career. I greatly prefer to do this on the rare one-off scenario than to deal with the overhead of soft deleting everything.
Another source: https://smoothiex12.blogspot.com/2022/07/why-russia-is-not-r...
Yes, I made a mistake. Thank you.
Is Tiktok even conventionally profitable? I wonder whether a significant portion of it's resources might be provided by state actors to support it's less 'conventional' uses.
One use case that I think is not sufficiently considered in this is related to two comments I made about a year ago [0, 1].

If you can _actually_ delete something, then that means that a malicious actor can fabricate data an claim that you deleted it. GDPR may be well intentioned but systems that have the ability to remove any record of a thing lay the groundwork for systematic fabrication of data, because any record of the past has been erased.

Operationally, I can totally see why soft delete might be considered to be problematic in certain cases, but from an information security point of view I think it is absolutely critic for protecting users against a whole class of attacks.

0. https://news.ycombinator.com/item?id=27249738
1. https://news.ycombinator.com/item?id=27691442
Too much focus on stars like Trevor Noah that gen Z / millennial didn't care about. Too "production"-y and "professional". Majority of content on TikTok feels more down to earth and relatable and actually interesting. It's the same reason why Vine was popular back in the day, it just felt more human instead of another entertainment product.
It is possible the US government lacks the reach to do what you've described, given how much organized crime is centered in other nations.

But I agree with you overall... Much of the web's concept of privacy and security is baked in with the assumption that it must be technologically enforced because it can't be legally enforced. Change that math and you change the model.
Introduction to Reinforcement Learning by Sutton (My Summary and Notes)
Mad Men at 15: how the advertising drama foresaw the death of the American dream
Yes.

Building a tool that facilitates or even automatically copies code and then using it would absolutely open you to issues.

I'm actually not sure what your thought process around why it wouldn't - if you're byte for byte copying something that you, or a machine, saw, that didn't have rights to use (or rather, didn't have rights to determine how other people use it - and you tried to enforce them) would be a problem.

If you're not supposed to look at GPL code, why would you train your model using such code?
I think the right remedy are damages. It's simple. Musk should pay the difference between his offering price and Twitter's current market cap.
They are not random. Those are the two locations being discussed in the thread you replied to :)
Eh I would rather go to a state fair than Disney. Its less commercial and more down to earth. I went to Disney, and I don't really get it. There's cartoon characters and some rides with huge lines that are maybe better than the local amusement park.If Disney tickets were maybe $30 and there was 1/5 the number of people. But its just a tourist trap.
An audit table is a similar, but not entirely equivalent tool. There are circumstance where both audit tables / soft deletes are appropriate, and where only one of the two is. Other systems that work are append-only tables, event driven systems, and I'm sure there are more that I'm not aware of.
> When property ownership disappears, all natural rights do.

Statements like this undermines their argument. Microsoft secures all sorts of rights under their EULA and is contractual. Enforcing property ownership is exactly how Microsoft has risen to dominance. And that is to say nothing of the a-historicism of this explanation of property rights.
Mapping Major Milestones in the Evolution of North Korea’s Cyber Program
Perhaps you did not comprehend the writeup, which describes this aspect of their analysis in some detail.
Do they still have the very cheap but surprisingly good hotdogs right outside the stadium that you can then bring in, which keeps prices inside somewhat in check?

(Reminiscing over the $5 student tickets available with college ID in the early 2000's)
It seems like I'm constantly hearing about large companies bidding at price x and then winning the bid, only to have the budget run over 10 times the original bid. So it seems in some cases the issue is becoming filthy rich as you rake in billions in profit from deliberately going over time and over budget.
I don't believe that's possible in postgres at least - but I don't think it's a huge concern either - you can have deleted_at cascade via trigger or just use views to hide the data - both are extremely easy to implement at the DB level without the application devs ever needing to worry about what's what.
Maybe they'll run it like Geely/Volvo Auto has been running Polestar? Polestar today is direct to consumer with a handful of showrooms like Tesla, but with a support contract with Volvo Auto dealerships. (My biggest complaint with Polestar is that there aren't yet enough showrooms in the US and I wish I could test drive one at my local Volvo dealership, because would really like to test drive the Polestar 2 and don't want to drive 9-12 hours to do it.)

As for dieselgate, for what it is worth VW seems to be going above and beyond in restitution. They made a larger voluntary factory recall than any of the car manufacturers that have since been caught with minor dieselgate scandals. They've invested more into Electrify America than just the US EPA mandated "fines". They've been seeming to follow through on their promises to aggressively electrify their entire fleet in a very short time window/turnaround. (They claim they will not sell any non-EV starting with the 2025 model year, next year. They seem on track to maybe hit that, with some question marks around some US only models remaining.) It's dumb that it took a scandal like dieselgate to push VW to turning the ship so hard, but they actually might be turning the ship.
Back of the envelope calculation:

Yuma International (discussed above) has 540,000m^2 of runways. Assume a depth of 0.1m of cooling, that is 54,000m^3. The density of asphalt is 2322kg/m^3, so we have 310^9kg. The specific heat of asphalt is 900 J/kgK, so that'd be 310^12J to get rid of 1 K degree. The specific heat of water is 4184J/kgC. If I assume the water goes from nearly freezing to nearly boiling and have my algebra right, that's about 6,000,000kg of water or about 6000m^3 of water, all to lower the asphalt by 1 degree. That's about 2.5 standard bulk units of water (Olympic swimming pools).

By comparison, 2.5cm of rain on the same runway area is about 13,500m^3 (?) of water.

I think it's doable. Anybody got some spare garden hoses? :-)
The C way makes it hard to find the name of the function (or even tell that it's a function declaration) when the return type is long.

std::vector<std::unordered_map<std::string, std::pair<std::string, std::string>>> foo(std::vector<std::vector<int>> x, std::unordered_map<std::string, std::string> y);
No PK, FK or Unique constrains on the archive. Rather use simple index to speed up queries.
Amazing work and thank you so much for making something so cool. With regard to feedback.

- Some features I'm interested in are being able to install libraries or a recommended path for getting access to libraries via RPC to a less limited runtime. For example, lets say I want to use the hugginfaces API to do text extraction within my note. Clojure has some great tools for running arbitrary Python code from within it, but how can I leverage that code from within Weilder.

- Is there planned support for importing from a namespace in another note? My current workflows are everything goes into one note and then I just hide the sections with the code so they don't distract but sometimes there are pages worth of code. I expect over time I'll find a lot of things that have common implementations.
That doesn't compute, because energy consumed by software is literally in what's required to execute the code by definition.