skysight-inc/HackerNews huggingface dataset:
If any non-null value for deleted_at indicates a logical delete, it seems like TIMESTAMP is the wrong data type for that column.

I mean I guess I can imagine a scenario where you want to know _when_ a record was logically deleted in addition to a flag that says is_deleted, but maybe that should be two different columns.

Or at the very least, `deleted_at` is a misleading name in that case. Interpreting `deleted_at` as "is deleted after but not before" is definitely a reasonable _enough_ interpretation. I agree it doesn't unambiguously mean that, but it's at best ambiguous enough to make for a bad column name if `IS NOT NULL` is the way you intend to check for a logical delete.

> you could to get the comparison flipped by accident, and if it's only in one place out of many that bug could go unnoticed for a while.

That's exactly why I proposed a database view as the proper solution to both whole `deleted_at IS NULL` "code leakage" issue. If you have a table that uses a logical-delete idiom that you intend to query from a bunch of different places in the code, a database view that filters out the logically deleted rows is a much more appropriate solution. It's a universally DRY solution. The single simple view covers all tech stacks, all services, etc., up to and including interacting with the database via some sort of REPL console.

If you need to add `deleted_at IS NULL` to, say, 90% of the queries against the `customer` table and you're afraid someone is going to forget to do that somewhere somehow, it seems pretty obvious kind of "extract common WHERE clause" refactoring is warranted. This is especially true in the actual "business meaning" context here. You are only going to be interested in the logically deleted rows in small number of specific circumstances. Having some way to extract away that detail from the 90% of the use cases where "logical deleted" is meant to be functionally equivalent to "actually deleted" seems extremely warranted. It's a perfect counter-example to overcome an aversion to using database views. I get that the `active_customer` abstraction is probably awkward to implement in a lot of application code contexts (depending on your ORM/DB-query framework I guess), but the database view is a simple and elegant way to address that really clearly defined need.
I published a NFT app named "Meta" weeks before Facebook was changed to Meta.

https://play.google.com/store/apps/details?id=com.ai.art.nft...
As far as data goes, amazon only really cares about the stuff you buy. Their advertising segment is growing, but even then most of it is targeted towards things sold on Amazon.
Just buying a bike here in the U.K. on a cycle-to-work scheme. Are there things I can do or buy that are better than a fairly sturdy lock, not leaving it unattended in stupid places, or perhaps gaffer tapping an airtag somewhere not too obvious? Also not too sure which insurance is good value.
Except when the complex houses married and single soldiers and their families. :P
Same here. I went looking for a non-standup job last month.. I didn't come across any.
Had a VanMoof. The 'bike hunters' was worthless. The "GPS" is actually A-GPS which uses cell towers to triangulate the bike to within .5 miles...not too useful.

When or if you do find the bike on a facebook marketplace listing, the Cops and VanMoof do nothing. As they can't attempt to purchase the bike, and can only be engaged if they see the stolen bike's serial number in the public space.

The benefit was the insurance, where they simply replace the bike with a deductible of ~$100
Show HN: Open-source code editor for transforming data and building ML pipelines
You are not losing all that 4%, most will just launch another browser to for your site if they have to
It's a web browser. If safety is not the one overarching concern when developing a web browser, of all things, the Chrome dev team is clearly dropping the ball.

> Rust provides many of these, but not much of an incremental path there

The incremental path is provided since you can refactor stuff into Rust at a scale as tiny as individual functions. Even an "unidiomatic", C/C++-like interface to "unidiomatic" unsafe Rust code is better than the status quo where no safe subset of the language can possibly exist.

The Rust borrow checking approach does a very good job of establishing memory safety in a way that respects compositionality and module boundaries; most proposed alternatives do not engage with this obvious concern at all. Pre-"Modern" C/C++ idioms are inherently unviable because proving them safe is a global, program-wide concern. The Core C++ Guidelines developers are quite aware of this, which is why Guidelines-compliant code is quite rusty already.
My issue when I lived there wasn't the trash. It was the human feces lining the streets.
Chesa definitely made it much much worse since it was plain policy. Hundreds of small business places got robbed, not just by established thugs, but by opportunists. Why wouldn't they, when the city declares they won't prosecute robberies <$600?
More economical than starlink and better network speeds and cool infiniglider tech? Sign me up! This is cool as hell.
If Ted Sarandos is chalking this up to a softened economy and not his content strategy he is deluded.
The issue with this is that the data is not real-time and Unaggregate claims data is very expensive.
GDPR fines are structured to make it extremely risky/expensive to take the “ask for forgiveness not permission” approach you’re suggesting. I think for this reason, the fine is designed to scale with the size of the offending company’s revenue, not so much with the actual damages suffered by anyone. Take a look at some of these fines, tens of millions of euros cause the UI for your cookie consent dialog is poorly designed? https://www.tessian.com/blog/biggest-gdpr-fines-2020/

When the GDPR rules came out our company (pretty small at the time) pulled out all the stops to get ourselves into compliance, due to the above and other teeth put into the regulations. It seemed utterly irrational not to. Were we the exception, or the rule?
Hand in hand with the increased monetary expense is also the increased energy expense that comes with looking harder and drilling deeper.

Let's say that you have an oil field that contains a quantity of oil that, when burned, would release X megajoules of energy.

The oil company consumes Y amount of energy extracting, refining, and transporting that oil.

At the moment, Y is less than X, but Y is getting larger relative to X. Once Y and X are sufficiently close, it's no longer energetically worthwhile to pull oil out of the ground.
Let's hire people good at programming and let's leave the fluff behind.
> I've been looking for a place to rent a truck so I can replace mine, a couple times a year I do something that no rental truck will let me do

Off the top of my head: Home Depot, Lowe’s, Menards, U-Haul, Penske, United Rentals, Sunbelt Rentals.
> Sheets

Interestingly, I have seen a new app that provides a sheet with HTMX: https://www.licenseprompt.com/ (gif: https://twitter.com/WimpieNortje/status/1520419150245638144)
>5 mins

All your life is in a shadow profile which TikTok has access to.
Yes, i am using big screens lately and the responsive css9 seems to be broken.. like a bad update?

Because it's the first time it's happened.

TLDR Change resolution / screen size
Why is it called Java?
Sure, but that time period is usually limited to 30 days, with an additional 30 day extension allowed if you contact the person and tell them you need more time.

You can’t just declare that it take years to delete data, GDPR sets reasonable limits on how long a company can delay true deletion.
The larger issue is that the SEC is so woefully staffed that they can do as many investigations on tips as they come in.
if a "simple" law is already at "might not pass" anything stronger is not really realistic, is it? (i.e. constitutional amendment)
https://www.uninformativ.de/blog/postings/2018-02-24/0/POSTI...
The main advantage I see of traditional server side rendering (like in Rails/Django) is that you develop a single project, not two (SPA + API).

Instead of api models and client models, you just have models.

Instead of api routes and client routes, you just have routes.

Instead of unit testing api and client, you test one project.

Instead of having the client making N requests to load all the data it needs from the server (and being careful not to return more data than you need for performance reasons), you return an html with all the data it needs in a single request, and nothing more.

In the case of client stacks using SSR (like Next/Nuxt):

Instead of running the SPA on the server so the server returns the html rendered, you just make the server return the html rendered.

The benefit to the developer is higher productivity. The benefit to the end user should follow from that.
I've worked with engineering students in a programming class, they do seem to have lots of trouble with things like zipping files, finding things in the filesystem, finding things in drop-down menus, and installing programs. The overall computer literacy levels are definitely lower than I might have assumed...

On the other hand, when I was an undergrad classmates would struggle with many of the same things (although the widespread use of pip has enhanced new users' ability to screw up their computers at scale and give me headaches). And we've all got a funny story about the guy who messed up the group project's share folder, right? Whether it lived on a floppy disk, thumbdrive, or in the cloud.

I dunno. The specifics change, but human creativity when it comes to making mistakes is timeless.
A Look at DISCO, World Leader in Semiconductor Capital Equipment
Monkeypox Treatments are difficult to get despite the Nation's large Stockpile
>under the GDPR [soft delete] is illegal

This is obviously not always true. Any European can't, for example, delete their online account with their mortgage company and demand that the mortgage company deletes the records saying that they owe them money so they can get their house for free.

Nor can anyone call up their previous employer and require them to delete all the work they ever did from their company's computer systems.

A company can't respond to a tax audit with "well we lost a billion dollars this year but all our customers wanted their accounts deleted so we can't provide any documentation of it." I mean, you aren't even going to get to the audit if you can't fill out your taxes in the first place because you had to delete all your financial records.

Most computer systems/software products in existence aren't free media apps, yet the "privacy circlejerk" constantly talk in generalities as if they are. I'm sick of this, most applications have a business justification for using some form of soft delete for at least some items.
> because they think home protection is a good market

it does say a lot, however, about the current state of community policing, the rise of private "neighborhood patrol" security services, gated communities, economic disparities between upper middle class and poor, in north american society as a whole.

and what trends that investors in home security technology startups see it going in.
If you measure 5, 5, 5, 9999999999, then your measured distribution is a peak at 5 and another at 9999999999. You can't say that 9999999999 is a surprising measurement unless you have a theoretical distribution - usually an implicit one - to evaluate at it and find a low probability. In other words, if being surprised means having your expectations violated, an expression of surprise implies that you must have had expectations to violate.
FWIW, I've never heard anyone say "spa" for SPAs (including conference talks by native speakers, so not just local bubble).
People collect all sorts of fascinating data but then analyze it so superficially, throwing very low-hanging fruit away without a thought. The biggest loss is information about individual variation.

Why do we only crunch data down to averages? Differences in group variation can be measured just as rigorously as differences in group averages. Repeatedly testing an unusual individual is perfectly legitimate and scientifically interesting. There is no Law of Science that says you have to execute a boring protocol that rigidly assumes everyone is the same.

There's a classic story about how the Air Force learned that no one is average, and switched from fixed "average" cockpit fittings to adjustable ones, greatly reducing accidents. But it seems like no one has learned from this.

For heaven's sake, let's try to learn about individuals and what works for them!
Nice to see some of the differences clearly laid out.
Indeed, about 45,000 so far! a bunch of garbage tips though... luckily the downvoting part helps filtering.
You're mistaking people being polite for not taking offence.
Vehicle users don't give a damn about the price of crude oil except to the extent it makes the fuels they use like Diesel more expensive. Our biggest problem is refinery capacity, it's down 1 million barrels per day or 5% from before COVID which has now abated causing demand to go up. Distillate imports from Russia which were making up part of the gap have been embargoed because of the invasion. Worldwide refinery capacity is said to be down 3 million barrels per day.

Natural gas prices were getting bad due to bad policies in China, Europe and the US before the invasion, and CF Industries as one example shut down both of its nitrogen fixing plants in the U.K. last year (the government there arranged for one to reopen so the byproduct of CO2 would be available for other food industry uses).

For that matter, 10 years ago is a curious beginning point to choose because another anti-fossil fuel President was in office at the time. Rhetoric is not going to fill empty bellies in the coming months or make my breakfasts cheaper.
FWIW LAPD told me to use Bike Index after mine was stolen. So if that’s the system they are cross-referencing with then that’s the one I’m going to use.
Nonsense like a "deleted" column on your main data table just seems silly.

Why silly? Yeah, it's one more column, but most DBs just represent dates as bigints AFAIK so it's not really the end of the world.

Sure, you have to be conscious of adding "where deleted_at = NULL" (or the opposite) to all your queries. If you're going through an ORM this is usually trivial e.g. in ActiveRecord it can be a default scope on your model.

On a proper database you can do your "undeleted" with triggers
and it's relatively trivial.

I like this solution as well, FWIW.

If I was retrofitting an existing application with soft-deletes I would definitely favor this solution.

There are some obvious advantages over a "deleted" column on your main table for sure.

One drawback is that you now have to keep two table definitions in sync. You also have to add conditional logic in a lot of places to handle whether a given piece of code is looking at a normal user from the "users" table or a deleted user from the "users_deleted" table. Instead of messing with the WHERE clause on every query, now you're messing with the table name on every query. So that's a wash IMO.
Two UK Airports Are Temporarily Halting Operations Due to “Melting Runways”
I had a friend that worked there and he tweeted about an open position and I applied and got the job.

I talked with two co-founders (CEO and the CTO at the time) on my interview process and when they explained their plans, I saw a common problem that everyone I knew had (banking in Brazil), so my first thought was: this can be a huge opportunity.
AFAIK, there are two separate deals here, one between Twitter and Musk and one between a collection of banks and Musk. Musk didn’t make the first deal contingent on getting the second one.

Having that second deal in place convinced the Twitter board that Musk had the money and the liquidity to pay the amount he offered for Twitter, but otherwise that deal is irrelevant for this case.
One minor meta-recommendation on the sturdy-lock front is to look for content from the "Lock Picking Lawyer" and find out if there are any bike locks that he recommends. He tends to make short work of most locks but there are some that gain his grudging recommendation; the number of severe vulnerabilities in many "high security" locks is eye opening. Edit0: added "front" after sturdy-lock.
Netflix Buys Australian VFX Studio Animal Logic
https://www.google.com/search?hl=en&q=ring%20selling%20data%...

There’s a USENIX paper floating around as well. Known for several years now. Wild OP is getting downvoted, this is known research for a few years.
In some markets ride sharing is very profitable. An accountant, who's my parents family friend used to work for Uber in UK before retiring. According to her just London generated 12 to 15 million pounds profit for Uber per month.
Or NSA. They've got a big problem of not appreciating whistleblowers.
What is the best way for an author of a Python package to develop and test on multiple versions of Python (e.g. 3.6, 3.7, 3.8, 3.9, 3.10), and be able to switch easily among the various Python versions? Every time I try to research this, I get lost in the chaos of Python packaging and environments.

Currently I do a `pip3 install -e .`, which uses the default Python provided by the OS. Then I hope that my continuous integration matrix catches any problems in the other Python versions.
Subjective opinion presented as fact? Say it ain't so.
>> Near end of day... Can you tell? Wrote draught instead of drought.
>Just before your edit, I spent a while amused at the vision of some guy trying to chug the entire reservoir while being egged-on by inebriated friends.
I think that's how I'd describe water usage in the American southwest, sure.
Ok, you raise a good point, the park is actually on Hawk Cove.

One just drives along the Back River to get there
I don't know if you were the exception or the rule, but I know for a fact some do go the forgiveness approach for requirements that they believe would be disproportionately burdensome.

Probably almost all companies actually, including yourself (just to a different extent) - what did you do about the storage remapping thing I mentioned? Did it come up/did you guys discuss it? Do you believe you're in compliance despite your hardware (most likely) not guaranteeing erasure or overwriting of existing data? I'm curious how your assessment of that went, because I doubt one can be in strict compliance without guarantees from the hardware.
Abolish DHS, completely ridiculous that they'd pay the private market for this illegally obtained (or at the very least gray market) data.

The FBI, CIA, and plethora of other 3-letter agencies should be able to cover the bases when DHS is gone.

I know, this is never going to happen but god damn, they're chipping away at our privacy and civil liberties like clockwork. Spying on law abiding citizens IS CRIMINAL totalitarian nonsense; completely unnecessary and counter-productive to the well-being of the USA.
Amazon wasn't one of the companies implicated in PRISM, so there's that. But then again the Snowden leaks came fairly early in AWS's existence.
For some applications this is fine, depending on your app/business logic but for a lot of applications states like active/pending/suspended and "deleted" are not mutually exclusive.

Suppose I soft-delete an active, pending, or suspended user using your scheme.

Now I need to un-delete the user. What status should they have? We don't know.

This is another "best practice" I've learned over the years. Those flags/statuses you think are mutually exclusive? Maybe they aren't. Or maybe they are now but won't always be. It's usually easier in the long run to give each status its own column even if you think they'll always be mutually exclusive. Because I mean, what are you really saving? A few bytes per record? In most cases that's not worth it.
The system that comes on your car will likely never be updated (except Tesla and a couple other manufacturers). Comma allows you to keep using the same sensors, but get the benefit of continued learning — without having to upgrade your car.

If I buy a $40k car and 3 years go by, I'd be happy to buy a system that gives me access to state-of-the-art driving intelligence, using my car's existing sensors.
$30 for lifetime is much less than Spotify, depending on how much other music you listen to.
Sounds like a more realistic restriction is "60 mph minimum"
This strikes me as an ironic microcosm of your original comment.
Guess we’ll find out when a leaks happen, and companies start getting fines.

GDPR does differentiate between structured data (I believe it uses the term “identifiable records” or similar), and huge heap of unstructured data where an individuals data can’t be quickly retrieved as it’s own atomic unit. With much stricter requirements for anything structured.

So for data on a HDD that could be recovered, but is an unstructured mess. You’re probably ok, as long as you took reasonable steps to protect the data, like full disk encryption (which could occurs below the file system, and thus allow you to recover data deleted from the FS with a full disk scan, as long as you still had the keys). If you just had peoples data unencrypted on a HDD, and didn’t securely erase it before dispose, then that’s probably still a GDPR violation.
Prompted by your post I went looking for some, typing 'help' into the start menu search in Windows 11. An app came up called Get Help.

It opens with an ad banner at the top: "Increase productivity and collaboration all while staying organized, using a new meeting solution designed for small businesses. Learn More". Out of morbid curiosity I chose to Learn More but "We are sorry, the page you requested cannot be found."

There are several features in Get Help beyond the primary feature of linking to a broken URL. You can sign in, you can rate your experience out of five, or you can send feedback. There is no Contents or Index, but there is a search box with a few suggested searches like 'How to install Office'. I tried searching 'how to copy paste' (without quotes) but "Your search did not match any solutions." It suggested I sign in to contact support. Closing the app is a little tricky because the minimise/maximise/close buttons are the wrong colour - white on pale grey.

Before closing the app, I selected a rating of 1/5, although my rating had been cleared upon reopening.
The Oil storage thing, I am surprised they get into. Firstly, as an aside I am guessing its segmented: you don't want all your eggs in one basket. But thats a huge open void-space.

Secondly, you normally fill the void in these things with CO or other oxygen poor gas to ensure its low explosion risk, but that makes it immensely hazardous to humans (this is how Noel Mostert said oil tankers avoid explosion risk in the 70s: they vent the smokestack air through the tanks, or used to. I don't know what they do now) -To get into it, they had to do a massive vent/purge surely? Thats mega-expensive. Where's all the equipment you'd expect to be down there, exploiting the access?

Like facilities I have seen pictures of seem to use giant versions of the MIL spec rubberised bladders. Storage of the oil in an empty void seems like a recipe for disaster. Or tanks. I expected an underground tank-farm.

Maybe it was designed for barrels? I can't think of a more unwieldy storage form.