skysight-inc/HackerNews huggingface dataset:
Having used a variety of soft delete strategies in Postgres, I can confidently state this is the wrong way to do it. Your code gets littered with "WHERE is_deleted" everywhere with the constant issue in PRs of watching for "that one time" you forget.

Best strategy I've come across so far since Postgres doesn't support system versioned tables like MariaDB and MS SQL Server?

• create your table with a timestamp range (tstzrange) type with a default of [clock_timestamp(), 'Infinity')
• make sure your table has a primary key
• create a history table that looks exactly like your main table
• use the Postgres table inheritance to have the main table inherit from the history table (yes, I know that seems backwards)
• add update, delete, and truncate triggers to your main table, copying OLD.* values (soon to be replaced) to the history table with the timestamp range end to be the range start of the NEW value
• add a second delete trigger that adds the OLD.* values to the history only the range start and end are both the current timestamp (makes looking up deletions easier and distinct from updates)

Once you get it working like you want:

• create the history table and triggers automatically with event triggers on "CREATE TABLE" so that new tables are automatically system versioned

So inserts are free and updates/deletes are only about 2% slower when tested on AWS Aurora, but the app layer doesn't require any extra complexity and the database can keep relational integrity at all times. History taking up too much space? Just DELETE from the history using a timestamp cutoff.

SELECTing from the history table due to inheritance rules always shows the current entry as well as the complete history of a record while SELECTing from the main table just shows the current records as expected with no query overhead from the extra WHERE clause. App maintenance moving forward is MUCH easier at the expense of DDL changes taking a little more forethought. Adding and removing columns requires making policy decisions about your history: truncating history, archiving and bisecting, or adding NULLs to columns that didn't previously exist. This is a policy decision rather than a technical one though. Use what best fits your use case.
Yes, and that's very nice if you have a heat pump. I suspect people with heat pumps use them for heat. It'd be weird if they didn't.

But, to restate my previous comment: if you have a natural gas furnace and a GPU, but no heat pump, and are deciding which to use for heat, it doesn't matter how efficient the heat pump you don't have is.

If you own your own home and have the capital to get a heat pump, great, do it. But a lot of people rent. They can't just swap out their furnace for a heat pump.
Used it way back in my Windows 7 days, it was a great solution to keep system directories clean from all clutter that installed programs add and fail to remove during uninstall.
This is something I've been wishing for a while - some kind of initiative to help make a small Android device available. So I'm happy to see this, especially when it's backed by someone with influence in the industry.

The author's motivations don't see that strong, though. I mean, if Apple improved the notification system and the file management, would this project exist? Or is it that unlikely to happen in a few years?

Anyway, I really hope the project works. I really do. And I'm willing to contribute the way I can.

I've been trying to make the switch to Android for years, but couldn't find a decent device, despite few attempts over the years.
Plenty of room down south, we'd be happy to have you both.
> no container in competitive online gaming.

Actually in competitive scenarios, e.g. tournaments, there are. Add to the fact ranked play is generally better behaved.

Speaking of parents, from my experience playing hockey, they are usually the worst offenders. Yelling at not just the refs, but the kids too. I've seen intimidation in more than one occasion.

At any rate, concern over the prospect of kids being "angry" is a weak take.
iPhone convert for the small form factor here, too. I had Android since the Galaxy S1, but in 2018 switched to the iPhone 8 as there was just no decent SFF android device. I considered the Pixel 3a, and I am glad that I didn't go for it as it dropped out of support and no longer receives security updates, while I'm today still on my fully supported and updated iPhone 8. Next phone will be one of the iPhone SE series.
Sometimes websites with big popups fuck with you, but then again we ought to be avoiding those websites anyway. I haven't noticed any issues with apps.

Typing is much easier than you would think. With swipe typing it's almost at par.
India is also one of the few countries mandating 2FA for all payments. As a consumer, it's a real boon knowing that no shady merchant or card skimmer can just arbitrarily charge your account. Was pretty spooked to find out how things work elsewhere.
> No actual new value is being created

That's your whole theory, and there's nothing weird about it. Everyone knows young men take risks to make their fortune and gain esteem. It's just window dressing for a claim you threw out there without any supporting argument.
This is becoming very common in academia. The university I used to work for is beginning to require that all research is published in open access journals. Do you know the ludicrous fees universities pay to closed-access journals?
This would probably be a dealbreaker for a lot of people. Unihertz makes small android phones that are on the thicker side, and I've been hesitant to buy one because of their girth (despite there not being any alternative small android phones on the market).
Reforesting with zip lock bags (2020)
Well, there are two categories of wages for tech workers: FAANGs and everyone else.

If the tech stock bloodbath continues, that certainly will impact wages on the FAANG side. People might start leaving for places that offer more cash comp, or FAANGs might increase RSUs to compensate.

It seems like a lot of the recent wage growth is at the lower-mid tiers, which make up the bulk of the industry. So, if companies that pay in the $80-120 range start cutting back on hiring, we might see a softening of wages for normal developers. I have not seen this happening...yet.
I guess I just find it weird to have a page on Wikipedia about a quantity with no mention of what that quantity has ever been measured to be?
Not only smaller hands, but smaller pockets.
One interesting feature on my Samsung Galaxy S9 is "one-handed mode", which shrinks the screen area to about the size of the iPhone Mini screen, leaving black bars along one side and the top. It's interesting that they're aware of the issue and have a software solution.

One-handed mode is decent when holding the phone parallel to the ground supported by your hand, but still doesn't cut it for holding the phone up since you'll need to grip the entire phone body anyways.
You get it slightly wrong, the problem isn't that they're interesting. The problem is that they're marketed to be profitable.

The most interesting stable coin is DAI. It's not particularly profitable, and it's stable and it will be stable no matter what.
> Your piracy is an excuse for data hoarding, which is a problem.

Not OP, but I’m guilty of this.

However, I also rewatch anything I like and love introducing people to things they haven’t seen. It’s great being able to share a large library of curated content.
A rebuild of a 160tb raid 6 array of 12 18tb disks for me takes around 3.3 days.
I'm just guessing, here, but it's possible you're missing the exit strategy where the insiders are calmly walking towards the escape pods.
I guess the only reason for me not to try this is how insecure I am about seeing my make-up free face in HD haha Solid write-up though!

For those with no camera, DroidCamX works rather well too!
> Do you really think anyone in Siberia, one if the poorest places in the world, cares about carbon emissions?

Unfortunately they care. For now only poor face real consequences of climate change. They are to poor to mitigate its effects.
Pegging has never worked for fiat currencies, and I don't know why anyone thought this would work for cryptocurrencies.

One classic example is when the US dollar was pegged to gold, and then the fiat dollar was inflated until the banking system collapsed, resulting in the Great Depression.

Earlier examples are every attempt at bimetalism.
No, my point is that bad research which conforms to people's priors should not be taken seriously.

There are many experiments on video game playing. Most of them are short run, obviously. But never underestimate researcher ingenuity. Here's a cute paper which uses as an instrument "did your roommate bring a video game to university"? Not beyond critique, but plausible: https://economics.uwo.ca/people/stinebrickner_docs/paper2.pd.... It's also relevant because the dependent variable is how much students study, and their resulting performance.

More to the point, if anyone seriously thinks video games will raise kids' IQ, and can persuade funders of it, they could simply give the treatment group an Xbox. That would be expensive - say $20K-ish - but much cheaper than the benefit of an extra IQ point or 2, over millions of children.
To repeat:

> one casual offhand cargo update away from catastrophe

There is a scary amount of libraries who don't even bother specifying patch levels and will auto update everything upon request without question, even worse cargo doesn't make it explicit and as such version "1.0" is equivalent to "1.0.*" in the cargo manifest. Please refer to my previous comment about bad actors not respecting semver as much as many would love them to.

`cargo audit` can be compromised by bad actors. `cargo update` also. If you have a security first application then always vendor, this isn't rust specific.
Musk is projecting his own insecurities onto Biden, because he understands the frightening, dichotomous utility of the teleprompter.

It's also related to his desire for platforming any-speech as a way of covering for his personal dragon, the pouty underdog bad boy who does bad things and you can't stop him. This is a position of emotional strength for Musk and his underlying hidden agenda is to build support for its continuance, which he doesn't really know how to manage, or even separate from its at times inappropriate nature.

Teleprompters are very troubling to people like this. On the one hand they are really good at helping humans--who at times enjoy the thrill of improvising like a paid stage comic--rather stick to the job they need to do and then walk away. They help you execute to a broader plan in that way without getting derailed.

But they also stifle what can feel like very authentic speech, driven by moment-to-moment opportunistic expression.

I believe Musk is subconsciously troubled by this dichotomy. He is not sure what to do about it, which creates stress as he experiences a background drop in perceived execution control (I can get buy-in, but only if society is in partial control of my words! Eek) vs. expression control.

In these little speech-complaint episodes, Musk is attempting to couch his personal need for buy-in to his entire, known-flawed persona as others' issue with boxy, restrictive discourse. In this way he only has to own half of the dichotomy. But I think he really believes in both sides and isn't sure how they reconcile.
With regular use the battery lasts about as long as the iPhone 13 Pro, that is to say, slightly less than a full day. But the point of this phone is that ideally you are using it less.
I still use Netscape occasionally, mostly for testing and nostalgia. Not many sites work with it, but I make sure that mine do.

I accessed fool.com with Waterfox, which is directly descended from Netscape.
For those of us with less than perfect skin, using a webcam can be a feature.

Also I found out that the difference in image quality between a good webcam and a semi-professional camera is not that big after video compression.
I wanted this and it didn't exist, so now I use an iPhone 13 mini. I'll likely replace the battery on this a few times since rumor has it the mini model won't be continued. It's too bad that Apple is running entirely on the sales numbers of the mini itself for that decision, as since getting an iPhone 13 mini I've bought 3 of the newest model of macbook pro for members of my family, started using Apple TV+ and Apple Music, and bought myself some Airpods pro. Apple brought me into their ecosystem with this device so from my perspective it seems like it could be worthwhile for them to continue making it.
https://archive.ph/M2ae1

I thought the most interesting excerpt was:

> Last October, the central government released a guidance pushing for the “high-quality development” of vocational education, which prioritizes training in areas such as advanced manufacturing and alternative sources of energy. In this new era, the government’s ideal young graduates aren’t joining hedge funds, flipping properties, or listing metaverse-related startups; they work in what Wang calls “the physical world” and proceed to “make babies, make steel, and make semiconductors.”

> In response, the tech giants, from Tencent to Alibaba, have done things like set up common-prosperity funds: multi-billion-dollar pledges toward “high-quality growth” initiatives, such as revitalizing rural villages and improving gig-worker welfare. In 2020, Jack Ma fell from the Party’s good graces, and found his influence curtailed and the I.P.O. of an Alibaba affiliate company suspended. Afterward, he embarked on an overseas trip, to Spain—to study farming technology.
It was just paper released less than a year ago during chip shortage, I doubt that they produced any significant amount of them.

Their performance was also luck luster compared to the consumer rtx cards.
I can’t tell if you’re being sarcastic but do take their claims here with a huge grain of salt.
California essentially has a referendum system. But it's very confusing. Every ballot has like ~20 of them so as an informed person I have views on many of them. But then there are ones like "Should we fund this stem cell research project for 4B that looks into this" and people have no idea how to vote. Things sound good and then you realize it was funded by very specific group of people and the money would go to their own project. Even though we shit on legislators having super well-informed people with staffs actually does lead them to work out kinks and negotiate good policy that pleases a larger swath of people.
it's variable and depends on when the legacy account was created. I have one domain with 10 users and I have another domain with 200 users.
https://en.wikipedia.org/wiki/The_Turner_Diaries

The Turner Diaries are basically classic literature to the extreme right wing and have been around for well over 40 years now.
Have you heard about qutebrowser?

Some others to check out:

Luakit

Waterfox

LibreWolf
I forgot about how much services absolutely suck on Linux even if you legally paid for them! I paid for Disney+ to watch Mandalorian and I spent an hour trying to watch it on my Linux device because I don't have a smart TV. Apparently Disney just outright blocks any Linux devices from using their service. I really hate piracy, but I hate DRM so so much more.

I never did get it to work either so I just cancelled the subscription
I'm not paying more than $300 for any phone, small or big. My ideal size was the Xperia X Compact, but a little bit thinner and with no bezels. Or the phone I got after that one, a Samsung A40 but 1 inch shorter.
I really like my Bolt. Has a touchscreen (and carplay/auto) but it is a pretty no-frills kind of vehicle, esp. with a lower trim level
Who are the others? I would like to read more about this.
The US Military Is Building Its Own Metaverse
If you wanted to trade some other crypto for USD without incurring taxation issues, you could get a "pegged" stablecoin and hold that without incurring any taxation since you haven't redeemed anything for money, and maybe trade it for other coins later on if you so chose.

There's function in the stablecoins in terms of crypto trading, but of course there's risk that your always pegged stablecoin isn't.
Gitlab went public last year, so VCs no longer have much power over it.
Im surprised Figma doesn't allw for this... only because their app dev kit with phone mirroring desktop is pretty sweet... I could see how it coud be adapted for this purpose
I think I might actually get this. How well does this work with Google Fi?

So years and years ago, when my main phone was a Nokia N900, I would occasionally walk into phone stores and see what was out there out of sheer curiosity. One day I saw an HTC Wildfire S, and I fell in love with the form factor right away. Unfortunately, I never bought it because I had my N900 and it was just too damn useful to justify giving it up for a cheap Android phone, and to this day I regret not buying one. It was so small and so cute and I wanted it, and now even if I do buy a used one on eBay it'll just be a glorified brick because it doesn't have LTE and no apps will run on its ancient version of Android. This is the closest thing I've ever seen to the HTC Wildfire S since... I think I actually will buy it, at least as a backup device.
One interesting feature on my Samsung Galaxy S9 is "one-handed mode", which shrinks the screen area to about the size of the iPhone Mini screen, leaving black bars along one side and the top. It's interesting that they're aware of the issue and have a software solution (along with similar features like the camera shutter button that can be dragged around to a more convenient location to tap).

One-handed mode is decent when holding the phone parallel to the ground supported by your hand, but still doesn't cut it for holding the phone up since you'll need to grip the entire phone body anyways.
Agree. Especially if you change the wording a bit.

I do think something like Brexit is fine for a referendum. It's a singular issue and clearly very important. In California we have referendums for weird tax issues that become impossible to be informed on and it leads to bad outcomes.
does the standard deployment use a centralized proxy?

like it's your Basic Architecture in the diagram in your docs. so i feel like i'm being put on.
'Night-time solar' technology can now deliver power in the dark
I wonder if Microsoft will reconsider their pay bumps.
This is where I am. Love the idea of a small phone like the android Palm Phone, and almost bought one. But my iPhone 13 Pro Max is basically so big I use it in place of my laptop for many, many things. So it basically replaces my dslr because of the camera quality and my laptop unless I’m writing software. Though I would love a small phone, I didn’t buy the Palm which would have been perfect for when I’m running or something, so I’m not sure I would buy this, even though I want it to exist.

Palm phone fwiw also got discontinued for lack of interest as far as I know.
That's only if you actually hit the record button and are actively recording to the memory card, but if you're using the DSLR as a passthrough, it works all day. I have done it w/ my Sony a6500 and it works really well.
Yeah you can imagine two purposes for the mini:

1. Cheaper iPhone

2. You don’t want to carry a big iPhone and you have a Mac/iPad nearby anyway for anything complicated so a big phone is unnecessary.

The second case should motivate wanting eg their ‘pro’ cameras in the small phone but the first case motivates making it cheap and low-margin. You can also imagine a world where apple markets a mini phone as also being an optional companion to a bigger phone, but they already have the watch for that.
How does this compare to using something like the Raspberry Pi HQ camera and a decent c mount lens?
I use the Tasks plugin for this. Tasks are created by creating markdown lists. You can put tags in with hashtags and due dates in with (and this bit I dislike, even though there's a command for it) the calendar emoji followed by a date.

E.g. (note HN strips out emoji)

- [] Write documentation for Foobar #docs #personxyz (cal emoji) 2022-05-22

You then write a query in a markdown code block with a custom query language.

E.g.

```tasks
not done
description does not include #deferred
due before today
path does not include Templates
```

For recurring tasks, I combine with the periodic notes plugin, I put the tasks in my daily/weekly (I don't use monthly but it is an option) with labels like #wednesday if it needs to done on a specific time. Then I include appropriate queries in my daily notes to bring up the relevant tasks, and I also have a Todo note with various longer term/backloggy tasks.

There are other plugins you can use, like Dataview which is the subject of this post (but means each Todo needs to be its own note), or the Todoist plugin, but Tasks is the one which works for me.
Of course you can. Otherwise we wouldn't use fiber optics everywhere. You only need a teeny tiny amount of power transmitted to carry a distinguishable signal after all.
Kalix: New High-Performance Databaseless PaaS
Show HN: AI generated Magic The Gathering cards
I was clear about what I said:

> Yet we know milk consumed today has adverse effects on the body, one being iron anemia at a young age. I personally experienced this in the 80s and, there was unfortunately no scrutiny around dairy at the time.

Just so we're clear, I stated "milk" in this sentence and I didn't state it was at all ages - I stated "at a young age". Just because this particular research was about toddlers doesn't negate the fact that the issue exists, and I dealt with it beyond that timeframe.

> Every health agency recommmends milk and dairy as one element of a balanced diet.

This is untrue - not every health agency does. Canada does not [0] - there are likely others. Because they were not lobbied by the dairy industry and as such it isn't needed or required for humans to live healthy lives [1]. Considering we are the only mammal to drink the milk of another species it's highly unlikely we need it. Milk is for the direct offspring of that mammal and that particular period of their growth.

[0] https://www.bbc.com/news/world-us-canada-46964549
[1 - PDF] https://switch4good.org/wp-content/uploads/2020/03/Harvard-M...
I'll put Reincubate Camo here as an option too - turns your iPhone in to a webcam.

I was so impressed I bought a used iPhone to use solely as a webcam; the whole setup was cheaper than the Logitech C920 he mentions.

The picture quality is great.
> These things are hard to study by their nature.

Small effects are hard to study by their nature. Big effects are usually easy to spot.

> there are a lot of programmers who feel quite strongly that static types reduce bugs

There are a lot of people who feel quite strongly that homeopathy cures all kinds of diseases, but they've failed to demonstrate that.

> But it’s clear that you accept other practices as beneficial on insufficient evidence

It's not about "accept." I myself practice typed programming without asserting the empirical claim that it reduces bugs, that seems not to be true (or at least, the effect does not seem to be big).

> The question is not whether static types prevent the most common types of bugs, or the most dangerous

So far, we've failed to show that static types reduce bugs, period. You're allowed to like them and promote them, but your feeling towards them does not make a specific empirical claim more or less true.
Sounds like you've answered your own question. Margins are lower, why would they want to sell more of those compared to the regular iphones?