skysight-inc/HackerNews huggingface dataset:
We actually used a similar tactic when transitioning our data to supporting soft deletion. We have a limited number of queries that update data or present data for administrative review and processing - but a lot of wild ones around reporting. We'd rename table `foo` to `foowithdeleted` and create a new `foo` view that excludes any soft-deleted rows. Our reporting queries keep on trucking like normal and read out of the `foo` table (now a view - but they don't care) and we only need to adjust the administrative view to show soft-deleted rows for undeletion operations.

Shell-gaming tables with views can be incredibly useful in postgres.
I’m more a fan of the unsafe ejection method.
The Science of the Perfect Second
I’m confused, I thought they were claiming to remove PFAS? Aren’t those chemicals not solids?
Source?

Maybe in some scenarios it shows a fault that is absolutely unnoticeable, but every real world case I've seen was at least theoretically noticeable by the user.
Video shows SPD cop laughing, joking about pedestrian killed by officer earlier
All of the LiFEPO4 batteries need to be kept above 0C/32F, while charging. [0]

Mine doesn't have an internal heater, so I make sure to keep it disconnected from the solar panels when it is cold out.

I live in a warm weather area so it was worth the cost difference for me at the time. Worst case, I can just get a simple 12v heating pad for it.

[0] https://www.relionbattery.com/knowledge/how-do-lifepo4-batte...
1. I know how Ext4 works in this case, and I don't care.

2. I already explained how I would like the system to respond. Ext4 or any other filesystem have nothing to do with it.

3. Processes don't hold references to inodes. That's nonsense (simply because there's no such thing as a "reference to inode" in any system interface). Process doesn't get a reference to the file from which its executable code is loaded at all (unless you count the first argument -- but that's the file's name, not the file). Who put this idea in your mind I don't know... and any filesystem, be it Ext4 or anything else has no role to play in this. Now, the loader may decide to store the inode of a file or not -- yeah, whatever. A filesystem may even decide to change the inode of an existing file, if it so wants -- since there's no system interface that relies on inodes, it's all a fair game. For example, Shell will usually read the text of a script it's executing a block or maybe even just a line at a time. If you modify the file during its execution, it's usually going to cause syntax errors, but, if you are lucky, you can even write self-modifying programs in Shell. Now, will Shell perform like this if inode changes? -- Knowing Linux tools, I'd say, probably not. Will probably fail in some spectacular way. But do I care? -- Nope. I want this power to delete the executable file as it's being executed. I see no reason not to have such power.
> Yet, macOS seems to get buggier and buggier between releases.

i wonder how much of that is a side effect of constant rewrites of already existing features... i'm reminded of when they tried to replace mdnsresponder amd all the chaos that ensued, or even just swiftui and all its regressions... the dock being rewritten in swift or system preferences etc...
Agreed re: some of the Windows "strangeness". I think there was some amount of needlessly "Enterprise" architecting going on at MSFT back in the day.

There were also very practical solutions incorporated to accommodate the constraints of the hardware of the time that come off looking like needless complexity today, too. (There's also, arguably, some laziness in the old binary file formats that were nothing more than dumps of in-memory structures. That's a common story across a ton of old software-- not just MSFT.)

Rob Mensching, who worked at Microsoft on Windows Installer pre-release, has a nice blog post about internals of MSI.[0] He goes into some of the overwrought architecture in MSI, as well as quirks to overcome performance limitations in a world of floppy disk-based distribution and much smaller memory capacities. It's a good read.

[0] https://robmensching.com/blog/posts/2003/11/25/inside-the-ms...
I was going to suggest that there might be a copyright issue, but it looks like that may have changed last year.

https://www.abc.net.au/news/2022-01-24/aboriginal-flag-copyr...
Ask HN: Do You Self Host?
Just out curiosity I’m wondering if HN has a decent size self hosted audience. Do you self host?

I self host many services on an Unraid, and may eventually move to TrueNAS Scale. It’s not something I spend too much time on, but I rarely hear about Unraid or Truenas on HN. Maybe it doesn’t make it to Front Page because it’s not very popular. Upvote if you Self host and tell me a bit about your setup.

The only reason I self host is control, I gave up switching SaaS tools every couple of years to the latest and greatest. I appreciate that a lot of FOSS still works great after 30 years, it’s boring, dependable, and slow to change. Mostly set and forget. Unraid not having a k8 cluster is starting to show its age, but TrueNAS Scale seems a bit too immature right now. Perhaps in 2-3 years it will be boring and stable. Share your thoughts!
It appears he intended to get a brazilian supreme court minister arrested, void the election he lost, declare martial law ("intervenção") and extend his first term indefinitely, backed by a military junta.
> dextromethorphan

Wow, seriously? I abused plenty of this to get high back in my day. And I can say that smoking while on it was definitely way easier, I barely coughed at all.
A lot of problems are easy to solve with money and permission! Building trains is similarly straightforward if we can secure the money and land use permits.
There is a simple solution to all these problems. Continue to use fossil fuels as we currently are and build massive solar plants attached to carbon sequestration to hit net zero emissions. And that's only the most obvious one, no one is suggesting we generate 100% of electricity from solar.
How would you/we know what unbiased is?
How does a Dockerfile change things? Your application is packaged into a container. The Fly service runs any application not just web applications or build artifacts. Of course your application is going to get a complete operating system environment to run in.

I don't think the Dockerfile has anything to do with them pulling your container from their registry and running it on their server.
Declaring a function with `lambda` prepends runtime nil checks for each argument to the function body (excluding optional args-- specified with a question mark, eg. `?x`-- and variable arguments, eg. `...`[1]).

This Fennel:

(fn foo [x y ...]
(print x y ...))

(lambda bar [x ?y ...]
(print x ?y ...))

...transpiles to this Lua:

local function foo(x, y, ...)
return print(x, y, ...)
end
local function bar(x, _3fy, ...)
_G.assert((nil ~= x), "Missing argument x on test.fnl:3")
return print(x, _3fy, ...)
end

[1] Fennel's alternative `& xs` vargs format does create a runtime check in functions declared with lambda, but it always evaluates to true because it simply nil-checks the table (here `xs`) that it dumps Lua `...` vargs into.
The master branch 'dev catalog' seems better in that respect: https://hfg-gmuend.github.io/openmoji/

(That is, AIUI, the 'next' version of the emojis, not that the format of the library/catalog itself is due to change.)
Exactly. It's the page people are sent to shortly after purchasing this book: https://www.scottscheper.com/antinet

Which I actually break-even on and even lose money on (even though it took me a year and a half to write). I break-even on the front-end and monetize via the physical monthly newsletter on the backend.
/s?

lol
It's interesting to see a new winner of different nationality beating the multiple previous records by the same guy, and what appears to be another one who beat him 2 years ago; for some (cultural?) reason, there seems to be a historical association between Soviets and advanced data compression technologies in general, possibly starting with Markov's work in the 19th century.
No one is proposing a solar-only future, and this guy's comment isn't arguing against that...

His comment points out valid concerns for a future that appears to be trending in the direction of relying more and more on solar power - these are real concerns even if solar accounts for ~20% of all power generation, not some 100% solar-only future. It's a reminder that solar power is not some silver bullet solution to energy generation.
It's possible to still net lose money by exporting power. So much so that it might even still make sense to not do it even after a catastrophic failure every decade or two. The actual calculation will need to be done by those who have the figures and exact costs handy.
This is getting deep into the weeds of the philosophy of science. It is crucially important to choose good hypotheses to test. For example:

> Hypothesis C says that data looks like what I collected 100% of the time.

What this tells you depends entirely on what hypothesis C actually is. For example, if C is "There is an invisible pink unicorn in the room, but everyone will deny seeing it because it's invisible" then you learn nothing by observing that everyone denies seeing the unicorn despite the fact that this is exactly what the theory predicts.

On the other hand, if C is a tweak to the Standard Model or GR that explains observations currently attributed to dark matter, that would be a very different situation.
also all the icons now being the same shape (like ios) i find myself scanning over and over missing apps i used to find so easily before... such a usability regression (though it does look pretty)
I mean, your basic $50 router beamforms using phased array antennas.

There's also DIY including radar phased array https://hackaday.com/2015/04/07/build-a-phased-array-radar-i...
The idea is that sufficiently powerful compression is indistinguishable from artificial intelligence, which can be used to make even more money.
That's what the speaker notes are for. In PowerPoint, you can go into the print dialog, choose "Notes" mode, and print that to a PDF. Each slide gets its own page, with the slide taking up the top half and the speaker notes taking up the bottom. [1]

I use this all the time to keep my slides sparse for when I'm presenting, but fully detailed when I distribute them as PDFs after the fact.

[1] https://support.microsoft.com/en-us/office/print-speaker-not...
> Pop in the Chinese and Russian dark money and America is poised for more deleterious delusions.

Nah they can't compete with the domestic shit funded by our own rich assholes. Foreign meddling is basically a drop in the bucket of PAC spending.
HN mods sometimes lowercase Nasa by stylistic guidelines, even though I wish they didn’t, so that would be PFAS and Epa.

But a better headline would be, “Berkey sues EPA over classifying silver-containing water filters are a pesticide”. The PFAS thing is marketing irrelevance to the lawsuit in question, which is over the silver content of the filter.

In any case, you can email the mods and suggest an altered title, and they may well accept it and update the post.
> the idea that you should instantly short circuit any situation where you receive a phone call (or other message) and someone starts asking for information

It really irritates me that some significant companies openly encourage customers to ignore this advice, teaching then had practise. The most recent case I know of is PayPal calling myself. It was actually thenm new cc account, I thought I'd setup auto payment but it wasn't so I was a child if days late with the first payment) but it so easily could have not been. The person on the other end seemed rather taken aback that I wouldn't discuss my account or confirm any details on a call I'd not started, and all but insisted that I couldn't hang up and call back. In the end I just said I was hanging up and if I couldn't call back than that was a them problem because at that point I had no way of telling if it was really the company or not. At that point she said she'd send a message that is could read via my account online, which did actually happen so it wasn't a scammer. But to encourage customers to perform unsafe behaviour with personal and account details is highly irresponsible.
Spreading sunshine in private equity: Agency costs and finance disintermediation
He probably had ID in his room (or, if in America one can check in without an ID, he could have a credit card with his name), and the staff should have verified it instead of giving a key to a random stranger.
I've been doing this for a long time and all I can say this after reading this multiple times ... "I don't get it".

I mean, I get it, from a technical standpoint. Ok, so you're going to send read-only Sqlite databases to everybody.

Is it missing what the API (that you still need) is updating when you insert or update something and all client DBs are now stale? Is there a central database? How often are you pushing out read-only database replicas across the wire to all clients? Is that really less "chatty"? If so, how much bandwidth is that saving to push an entire database multiplied by the number of clients?

None of this seems logical. Maybe I'm missing the real-world use-case. Are we discussing tiny Sqlite databases that are essentially static? Because in the last 30 years I've not run into a situation where I needed to have clients execute SQL queries on tiny, static databases let alone still need to potentially update them also.
Make sure to get the ones with active circuitry on them to negotiate charging speed, otherwise you will be stuck at 5v and under an amp.

I got some ti chip ones from aliexpress for around 4 bucks each that have worked flawlessly on laptops and phones.
Hourly wages for solar farm construction labor have gone up, but more efficient installation processes and lower cost hardware have compensated for that increase.

The International Renewable Energy Agency says that 191 GW of solar capacity were installed in 2022:

https://www.pv-magazine.com/2023/03/22/new-global-solar-capa...

Wood Mackenzie estimates that 270 GW of solar will be installed this year:

https://electrek.co/2023/08/03/a-record-270-gw-of-solar-is-p...

270/191 = 1.41, or a 41% increase in installed capacity this year.
So a scaffolding tool?
here, take my code: https://github.com/dharmab/homelab-k3s/blob/2f46393aeeb73673...
So what? I want it, and I see no reason not to let me have it. Linux was designed with this main goal in mind: let people take ownership of their computers and do whatever the hell they want with them.

If your Linux doesn't do it -- I don't care. I'll make my Linux do it. Because that's how I want it to work.
My personal use case is most often supplying files and generating unit tests, as well as supplying a section of code with a prompt about that section to evaluate the approach contextually with some other unseen code. Which perhaps is another form of reasoning.
TOTP (Time-based one-time password) need a shared secret (and two synchronized clocks) to work, so yes.

FIDO2/WebAuthn relies on public key technology - so does also have a secret key - but is designed to be kept secret from the service/server one authenticates against.

For use - FIDO2 is more like a multi-use id. Like a driver's license many services accept as id. If you lose it - you don't restore a backup copy from a safe - you use your passport until you get a new one issued.

This makes more sense than with TOTP as the services only need your public key(id) on file.

https://en.wikipedia.org/wiki/Time-based_One-time_Password

https://en.m.wikipedia.org/wiki/WebAuthn
Fundamentally it's true. You buy it because it contains alcohol no? If you're not after the drug inside, you'll just buy juice or soda. Hammered or buzzed, you wouldn't buy it if not for it's mind altering effect.

I know vodka is different than whiskey. They even contain different volatiles, which changes the buzz considerably, and the wood esters and things in whiskey are bad for you and give you hangovers.
It's only a matter of time until models can create that trail of incremental work, though.
USB-C to Lightning Adapter
Good call out. I made the submission and tried to make the headline fit, didn't mean to change things but your point is valid. I just did a new edit that is hopefully better. The character count is limiting.
My favorite take on this sort of issue: "Can we just get the 90% done first?" [1]

The faster we build solar, the better. We can sort out lots of things along the way.

[1] https://twitter.com/JigarShahDC/status/1701228390735602048?t...
They’ve been doing really long trains for a couple of decades now, and they’re not showing any signs of stopping. I’d say that the economics of it probably works out.

Anyway, the economics don’t really matter. The long trains exist and have to be scheduled somehow.
Easy! Write a compression algorithm that works as follows: if you detect the input is the first gb of Wikipedia, return nothing. Else return the compressed artifact of your compression algorithm of choice. To decompress, running the decompression algorithm on an empty input returns the first gb of Wikipedia, if else you use whatever algorithms you used earlier :)

This is inspired by HQ9++: https://www.dangermouse.net/esoteric/hq9plusplus.html
https://petapixel.com/2019/07/13/shooting-high-res-thermal-p...

One of my favorite photoshoots merges IR and visible.
https://www.nlrb.gov/news-outreach/news-story/us-circuit-cou... ("U.S. Circuit Court Directs U.S. Marshals to Take Haven Salon + Spa Corporate Officials into Custody for Refusing to Comply with Board’s and Court’s Orders")
I have the 2020 iPhone SE 2nd gen?

I’m taking a trip to New York soon and I will absolutely want a decent camera so I might spring for an iPhone 15.
My goal is to make some really good games in my 40s - a decade from now. So I might as well learn skills and build up on open source now. That fits that timescale.
Is this spiritually just like using a Redis cache?
I don't understand how it scans to record the spectrum with a point detector? did I miss something?
The question is will the crackdown be successful? Or will the millionaires' lawyers, etc. stymie those new “compliance efforts”?

This is definitely worth watching.
I highly doubt it would 10x the cost though.
Lol, "millionaire" just means "middle class".

"I have a not super desirable 2BR house about two hours outside a metro, which is now worth $600k, plus a 401k worth $300k, and another $100k saved up. Can I retire?"

(No.)

...

In fact, since we're talking about a thousand millionaires, I need to point out: You know what that equals?

One billionaire.
Do You Self Host?

I self host all the things with one exception now. I moved a portion of my domains to a mail provider so that family members would run into less issues with deliverability and so they would not bump into my global anti-spam regex rules.
I'm not forcing anyone to do it. I've done it, and had great results. I've had a few friends and family do it, and all have been impressed.

People think nothing of going on vacation and eating poorly and drinking for 7+ days straight.

But tell people you should try atleast 7 days of vegetable juice only and they start looking at your sideways. Say 30+ days and they'll warn you it's dangerous. Say 90 and they'll think you're going to die.

I promise you more people are dying from pizza and beer than vegetable juice for 90 days.
Game Development Post-Unity
Not everything is in official repositories.
That still sounds like a lot of work. I'm pretty sure I'd be much more inclined to write an article/blog or series thereof on the topic rather than having something tied to the presentation format. Just as a lot of people don't watch 40 minute videos they don't read equivalent text either.

Often, what I present is interrelated with what I write but they don't tend to be 1:1.
oh n/m it has a lead screw and moves it across the focal plane of the spectrometer..
Weird analogy to murder, but I guess so
Or, worse, what we have destroyed
Oh Man I haven't heard of this framework in years!

There was this amazing fan game made to mimic an episode of this tv show called Community. The show is about a group of community college students getting into all sorts of hijinks and one episode had all of them go into this video 8 bit video game world....so LÖVE was used to recreate the game exactly as you see in the show.

Unfortunately it is running on a very old version at this point and I hear due to how the framework has changed upgrading is not straightforward. It interesting to see how software changes and grows over time. Fortunately the last version released still seems to work fine on modern machines. (at least it runs on my M1 Mac)

[1]: https://www.youtube.com/watch?v=PzhuvOqfmC4

[2]: http://projecthawkthorne.com/

[3]: gameplay footage: https://www.youtube.com/watch?v=Imv6J8dqLyE

What blew me away 10 years ago was the complexity of the game that you could produce in LÖVE. its astounding!
The world does, booze is booze. Sure, it's different, but all the lore is just marketing.
They mention one partial "solution" to this: have your clients query a view, instead of tables directly.

When you need to change the schema, also update the view accordingly.

Of course, there are still limitations. For one: you can't "massage" data with a view as you could in the backend with a full featured programming language.

PS: I don't think this is a good solution, just mentioning it.
'Impossible' Port Master Randy Linden Talks Jurassic Park, BOTW, and His Ports
Oh hell no, give the story to a director who can actually create a movie with good dialog and character development.
Yep. Enjoy your Big Mac.
Imagine you're building a SaaS which allows your users to do create a website, hotel booking platform and channel manaager.

User can open the application, get the database, the frontend does all the offline updates the user want to perform. The user can update their website, add bookings they received on the phone, check what prices they set. This is all blazingly fast with no loading time, no matter your internet connection, because no further communication with the server is needed.

At some point they press a magic Publish button and the database gets synced with upstream and uploaded. The upstream service can take the data and publish a website for its users, update availabilities, update prices, etc.

It would be a better user experience than 99% of the SaaS out there.
Isn't the "feeling-based approach to what-is-right" the whole intent of the jury system?
"You've split atoms, reached the moon, and yet the very force that keeps your feet on the ground remains a riddle? Perhaps society's attention is too often pulled away from the fundamental questions by trivial distractions."
Won a Mini in a work giveaway a while back. Have to say I do like using it for reading (and not just tech books, which I don't read a lot of).
> Why don't you use the printed recovery tokens?

I currently see 53 2fa tokens in my private bitwarden.

You expect me to print, keep safe and manually reset them all when I buy a new phone?
Why bats carry viruses that are particularly fatal for humans
The Spartans got to throw their babies into a chasm.

I find it unfair that I’m not allowed to commit infanticide just because I’m late to the party.
SEEKING WORK | REMOTE ONLY | Freelancer/Contractor | Software Developer - Location: Brazil (UTC-3)

- Hourly rate: 40 USD / hour
- Availability: up to 40 hours/week
- Programming languages: Haskell, PureScript and Nix

walkerleite490@gmail.com
Pardon me, but can we clarify what you mean by saying that "masks aren't helping much"? Do you mean that masks are not effective in stopping the spread of COVID on an individual basis? Or do you simply mean that as a matter of policy, mask mandates have failed to stop the spread of the virus throughout the population in general?
It's not necessarily about the pricing. It's how the pricing is determined. 5% of revenue is concrete. You can make a business plan and plan for the future based on that. With Unity's new pricing structure, it's impossible.