skysight-inc/HackerNews huggingface dataset:
I have occasionally thought that someone should make a "death app". An app that would have all kind of stuff you should do because you die one day. Not just a check list (which would be a good start), but you actually would be able to write your will, make organ donation contracts (or whatever they are), store information for the chosen ones after you die etc. Could also remind you that it's so long since you donated blood that might be time again.

Feel free to steal this startup idea. I'm afraid there might be some hurdles marketing this - and also localization can be a challenge.
"Every outrage is a tantrum, not a protest" is a strong statement.

Do you have any source on half of the protesting users being back? Losing the volunteer moderators is a big problem for quality, are those back or the others?
Does this need a [NSFW] tag?
Surely a human can detect the gaze of another human when they see that human looking at them.
Gods, I tried to do some reflection stuff in a Node TS project I got put on about 18-24 months ago, and it was a total shit show. It was really disappointing to see how lacking the actual runtime capabilities of TS are.
You should pay attention to pwn2own every year where it is common for competitors to find a browser rce and VM escape exploit.
Update Google Cloud Domains likely impacted: https://twitter.com/GergelyOrosz/status/1669726481130434563
The fashions in the last 30 years have been remarkably static, the only real way of telling the year was the hair.
Why do many hate "new" Reddit in the first place?
Every time I have used an ORM I end up supplementing or replacing it with a "query DSL" like jOOQ, Linq, Arel, Ecto, diesel, etc. I seem to have the opposite problem of OP: I don't often find myself wanting to hydrate some complex object graph, what I really want is some small fraction of what constitutes "an object": "get me the distinct values of this column, sorted by another column", or "get me a list of user IDs and e-mails that are subscribed to this topic", etc. Trivial to do in SQL, and much faster to do that sort of thing _in the database_, where the data is already _memory/cache resident._

ORMs, by design, bring unnecessary data over the wire for the sake of inflating parts of an object graph you don't care about 90% of the time. Most of that data will either be unused, or you are going to transform and then discard anyways. If you go out of your way to actually optimize out unused fields: now you're passing around objects with nulled-out references around your application, which is just a disaster waiting to happen.

Having a query DSL that actually maps result sets to your language's type system is the only way I've found to actually write robust, performant, maintainable code. My result sets being "too big cartesian disasters" is just not a problem I have, because I don't think in objects. I ask the database for what I want to get the job done.
I do something similar to the CD trick: I'll set a timer and tell myself I have to do focused work for that amount of time. I pause the timer for any interruption (including bathroom breaks).

I'll often just do an hour. At the end of the hour I can check Slack messages, look at Twitter, etc. I'll only do this once or twice a day. Otherwise, I just work "normally".

For me, it's less about hardcore grinding and more about making sure I'm holding myself to a reasonable standard. It's an hour - is that too much to ask?

I've found 3 big benefits:
1. Personally, I focus better with the timer. I don't know why. But I'm less distractible. I'm an order of magnitude more productive in that hour.

2. I'm the type of person that feels guilty when I'm not productive. I find that, because I've met a productivity goal (and have been genuinely productive), I don't feel that guilt. I'm both more productive and less burnt out.

3. You'd be shocked at how long it takes to get through that hour sometimes. That's probably the biggest benefit: it teaches you how you're managing your focus time. Everyone thinks they're good at time (and focus) management but nobody measures it.
I like the article, but I wish there had been an "Abstract" or "Executive Summary" at the top so that I'd be spared having to read the entire article to find out the results. I'd like to have seen something along the lines of the following:

"We found Hetzner's ARM64 offering, specifically the CAX21 with 4 cores, 8GB at $8.40/month, to be a performant and cost-effective alternative to x86_64-based solutions."
> there may be no limit to your liability.

You can put the house into a limited liability company, which theory should limit the liability to the value of the house.

Depending on whether director negligence was involved etcetera.
Sibling comments have provided good explanations of why modern economies need finance: risk management, capital allocation, enabling ventures, and so forth.

At the same time, it’s worth asking the question of why the financial sector just keeps growing and whether that’s desirable. Shouldn’t improved efficiency with digital systems make this intermediation layer thinner, less labor-intensive, more competitive? Instead it seems to be capturing an ever larger share of the economy’s output to itself.

In my opinion regulators should try deploying some blunt tools like transaction taxes and hard salary caps, and see if we’d be any worse off with a smaller and poorer financial sector.
This exactly the comment I was going to leave. If I get past one sub query, I will refactor to CTE.
Yesterday I had water in DC. A five hour drive with no stops later, I relieved my self.

I changed the tilt of the Earth.

Are our instruments sensitive to measure this? No.

Are our insanely accurate instruments able to measure other human activity? Yes.

Is the tilt change significant? Not at all.

Is ground water exploitation a problem? It is a massive problem, and one that doesn't need FUD distractions.
> you can't use 'negigibly' worse as a defence

Absolutely you can when the increase in something (bandwidth) in a system with surplus supply with the trade-off of optimizing a more constrained supply (CPU or memory).

> made a crazy SQL select instead of a normal one, which is harder to maintain.

Purely subjective. Myself nor the people I've hired would have a problem maintaining a more complex SQL query using CTE's and JSON serialization than not.

> it's worse performance

I cannot imagine that's the case in the context we've been discussing. An RDBMS duplicating JSON output of tuples multiple times in a single transaction is not particularly expensive compared to the alternative.
Secondhand account of internal e-mail: https://twitter.com/GergelyOrosz/status/1669726481130434563
astroturfing

> the deceptive practice of presenting an orchestrated marketing or public relations campaign in the guise of unsolicited comments from members of the public.
Very true and Carmack very much was working on his own startup on a passion project
I understood it as it's an arbitrage because it enables the creation of a new system that reward arbitrageurs less (but still enough that they would perform the arbitrage).

Though this is only true in a system where you don't face tons of hurdles to deploy these new systems, which is not the case in the current financial system.
From a Bayesian point of view, promulgating the false rape accusation idea is just irrational. When someone is raped (men and women are raped) they have a prior probability in mind about whether their accusation will be taken seriously. People they report to also have a prior as to whether the rape accusation is credible. In a world where most rapes are unreported there is almost no reason to adjust those priors towards "this is a false rape accusation."

Our legal system sucks and I think its bad that a person's life can be ruined or seriously damaged by a false accusation. But it is worse to be sexually assaulted and not have it taken seriously. I think if you balance it all out, focusing on the false accusation narrative is bad.
Yes, but how will lemmy cope with abuse, I am waiting for like a year to see where it gets.
The mentioned PDF document (31 pages) from his Instagram channel[1]: https://drive.google.com/file/d/1kwgP7hqT3RBi4q5wOi4FizKwcz_...

[1] https://www.instagram.com/feurigerilias/
I don't get it. If you pay per use, i.e. pay the same if you listen to the same song 5 times vs 5 different songs, why should it inhibit exploration?
> An experienced person won't do that.

I’m very experienced and do that kind of thing all the time.

Also, your “SELECT 1” technique seems like practically the same thing, except I guess you discover column names from autocomplete tooling rather than query output. (To my mind the difference is inconsequential.)
Stockholm subway had a nice font. Digital version is called esseltube. https://sv.m.wikipedia.org/wiki/Esseltub
Depends on which country, city, telco, etc. If your area has low population then the back-haul could quickly be the limiting factor. Telcos generally under-provision to maximize their return on capex.

AFAIK 5G is only tower to phone connection. The rest of the infrastructure determines your end-to-end speed and latency.
Illicit Wine Used for Masses
That would require Reddit to voluntarily go out of business, and most companies do not do that.
Did you just use HN comments as a terminal?
> None of them are using GenAI to write their articles.

Too bad, that would probably be an improvement
We built a datascience tool to quickly build data apps which can be extended from the frontend, including data wrangling and datascience functions.

The hardest but most exciting part was using the PostgreSQL and SQL to process, clean and enhance data and write extensions and bring it all together.

We opensourced alpha version yesterday, more documentation to come.

https://github.com/rebataur/rapidiam
I'm not certain how the GDPR applies to these things (i don't think anyone are) - but the GDPR is enacted as law, and "but all my friends break the law" or "your law is stupid" or "it's easier for me to break the law than to comply" - aren't really legal arguments.
>> app that costs $1/month/person. Then try to sell it to companies that have a couple hundred employees

I would not recommend doing this. Any company with several hundred employees is into contract & procurement management territory, and likely to have a staff lawyer, privacy & protection person and person/team dedicated to (slowly) evaluating purchase & adoption of Saas products. This, plus all the people involved in any sort of roll-out across the entire company (of anything) will destroy the economics of a few hundred per month deal. You probably need a VP to approve this not because of the cost but the impact, and as a manager an incremental value deal that I see every month will be the first thing I cut, not because it's expensive but because it's an easy one.

Every low-cost per <whatever> deal I've seen in an enterprise of this size has a sizeable upfront cost and then a a tiered or unlimited per seat component that's correlated but not necessarily directly tied to a variable component. This reflects the sales process that involves more effort upfront. For a pure, low-cost per user/month model you need a completely self-serve adoption path.
Literally can't see anything without logging in.

The readme is very "lightweight" on details, screenshots, features, etc..
Readme could link to or explain what clickhouse is, for those of us who might not know.
Why does the SSN has to be secret? Is that a legacy thing ?
Or maybe a product of not everyone having id ?
Would the combo name + DOB + county of birth be equivalent as unique identifier ?

Just trying to get context, I also lived in place where SSN are not a big deal because they are not used to prouve anything
Understanding Encoder and Decoder LLMs
15” MacBook Air Teardown
Show HN: Yass.ai (Yet Another Streaming Summarizer)
Note: The live demo site http://yass.ai can't handle simultaneous users, so if you want to try YASS, you are best off running it locally. If you know how to fix the simultaneous user issue (session handling) then please make a PR and help us improve YASS! Code was written in a weekend for a hackathon, so go easy.
Not all of them are unusable. Fairphone and shiftphone are more expensive, but perfectly usable.

-- sent from my Fairphone 4
I did a similar transition a few years ago. Used to work with higher-level system integration and web, now got a job as an embedded engineer at a company that makes lab equipment. They had a single embedded developer for the last 10 years who did everything himself, from scratch. We are now stuck with a gigantic monolithic code base where you need deep understanding in the details of the entire system, which makes it very hard to change or fix something.

The problem I struggle the most with is that this industry is 20 years behind compared to modern software development. Since embedded is tied to hardware, and these products have a long life cycle, innovation moves very slowly and there is little motivation to change something that works. I am used to automated pipelines, tests, modern debugging tools etc, and I feel extremely limited going back to a very manual workflow. The use of OSS is almost frowned upon.

I would advise to research what tech stack they are using at any possible new position. Make sure there is a team of embedded developers that work together (not individually on different products). I would look into embedded Linux and Zephyr.
They aren’t exactly things you carry around in your pocket.

http://www.n2ltd.com/intermec-introduces-latest-rugged-mobil...
To answer your question directly, there are active markets where insurance policies are effectively "traded" like this (reinsurance and retrocession and the Lloyds market). A single policy with sufficient limits absolutely does get syndicated out and bought like this. For smaller policies they get bundled up. But they're professional markets where participants must be regulated because insurance regulation is how we mitigate counterparty credit risk on insurance policies.

But "like insurance" I think was meant as a broader term. Traditional insurance contracts look a bit like options. But forward purchases or sales are also often used as "insurance". The big gain is that purely cash settled contracts (or contracts where cash settlement is possible as a result of sufficient market liquidity existing to allow closing a position before physical settlement) can be used for risk mitigation in other ways which offer much better liquidity and better cost-efficiency in the right markets.

A good real world example is oil price hedging. An airline might want to mitigate the risk that their future cost of jet A-1 goes up. On the other hand, an oil producer might want to mitigate the risk that their future sale price of a particular blend of their crude goes down. Instead of using insurance or entering into bilateral forward contracts, both can trade futures or options on a standardised crude (which neither of them is ever planning to physically deliver or take delivery of[0]). The contract they are trading will not be a perfect hedge for either of them, but it will mitigate their risk significantly. In fact if they are both large enough, bilaterally the liquidity available to them would likely be insufficient to mitigate the same amount of risk.

Having a "single", transparent price also brings some other benefits beyond simple liquidity. For example, it enables several ways to manage counterparty credit risk which would otherwise be unavailable (daily margining, use of central counterparties or clearing, etc).

[0] although the contract might enable an oil producer to make physical delivery of their own blend with a price adjustment
You could probably use window functions

Ex:

min(sum(size)) over(partition by group) min,
max(sum(size)) over(partition by group) max
You didn't see that video of the girl who worked at Twitter but didn't seem to do anything other then drink coffee and go to yoga class? I think if the company is not making a reliable profit then maybe there's some costs that could be cut.
"Only break one law at a time"
They do. But AWS does provide support and tends to be reasonable at it. Route 53 is dug deep enough into AWS that it doesn't really attract casual users who tend to be disproportionately more expensive to service.

I'm sure GCP could do a similar thing by spinning up a registrar solely for GCP users.
Sadly, the actually-plausible generational risks don't get anywhere near this care.

A breached nuclear cask in the very specific case that civilisation has collapsed and lost all knowledge of nuclear material and signage is a limited local event. Low impact on a societal level (admittedly high on the guy with the hand tools cutting into it) and low probability.

Climate change is a probability-1 event that affects everyone. So is plastic pollution. For that matter, indeed, lack of affordable housing probably will end up with worse consequences projected into the far future than a hypothetical deep-time grave-robbing mishap.

While doing a good job of handling nuclear waste is obviously extremely important, handwringing over the effect on a contrived far-future devolved society to the extent that we inhibited the one power source that could have avoided the latter 70 years of the fossil fuel boom in the first place, a boom which actually has plausible civilisation-scale effects, seems backwards.

Admittedly it's now getting to the point where non-nuclear non-fossil energy may be the cheaper and scalable option (pending a mind-boggling but physically-possible amount of storage) so maybe the moment for a nuclear-based energy system has passed. I don't really buy it and still think only nuclear is likely to deliver the energy needed over the next 100 years, including decarbonisation of heating, industry, transport and also possibly environmental remediation. In any case, assuming human civilisation retains knowledge of the 20th and 21st centuries, they're going to be wondering what the hell we were thinking between the 1950s and the 2050s when we had nuclear energy in our hands and nearly destroyed the biosphere anyway by choice (and that "nearly" is only there because this assumes enough of it survives for someone to be looking back in the first place).
Generated columns (i.e. some_json->>'id') can have constraints just fine, maintaining whatever integrity you want
The Madonna video Ray of light is filmed in one of the few stations that still have the old font
> Evidence from some wrongful-conviction cases suggests that suspects can be questioned in ways that lead them to falsely believe in and confess to committing crimes they didn’t actually commit.

It's been known for like dozens of years at least. What happened in soviet Russia and in China during the cultural revolution was all about making people convinced that they had committed crimes and that they deserved their punishment, and it worked very well.
Also add, based on tests arm performed 8% worse than amd64, but this is offset by the 14% savings.
If you need pre-fetching and 2-phase-commits, a database designed for queues can easily work 3x better than a genetic SQL database.

That's being said, Kafka is not one of them.
Update: people have learned from leaked internal emails GCP Cloud Domains is going to be shut down too. I might have to Degoogleify at this point.
Ask HN: Google search type changing order all the time?
I've noticed that the type of search you want to conduct on google (Search, Images, Shopping, News, etc) keeps changing order, but over the past weeks it has been dramatic.

This has been going on for years, but since the new redesign the last month, I've had to witness this monstrosity[0], where I just wanted an image (Afbeelding), but clicked on Sign in (Inloggen)
on accident. Not sure what Sign in has to do with that search anyway.

Has anyone else been noticing this and if so, does anyone find this remotely useful?

[0] https://i.imgur.com/IoNO5jd.png
At least two links don't work because they contain a closing parentheses.
I can’t even imagine how anyone could do business like that.

Oh wait. That’s exactly how every small business in the world outside the US does it.

And small businesses in Europe are thriving far more than chain shop laden America.

And when those business owners come to the US they nearly gag at the ridiculous arbitrary pricing they see here.
reddit is deadit
This was published 8 years ago. Makes me wonder if it's replicated yet or if anyone has tried.

I certainly am no fan of the reliability of human memory. It surprises me that more people aren't skeptical just from their own experiences. So many times I've told stories of things I did or remember from when I was young, especially to my wife, only to eventually visit my parents and find out I'm wrong and that never happened.

And, of course, among my earlier memories are from kindergarten. I remember seeing the Challenger explosion happen in class and I remember missing half the year because of pneumonia. They can't possibly both be true because they'd have happened at the same time, but I remember both nonetheless. Is my memory of watching the OJ verdict live in high school history class also false? I have no idea, but I wouldn't be the least bit surprised. I have no idea how much of my remembered life actually happened without independent corroboration.

It leads to such conflicted feelings when the subject comes up of people remembering childhood abuse they'd "suppressed." No doubt many more children are abused than remember and many, if not most, abusers never come to justice. But also no doubt many of these memories, like the entirety of the Satanic Panic, never happened, and many people are in prison or registered for life unable to get a regular job, who never did anything.

It's worth remembering this as we see the development in real time of LLMs and other somewhat intelligent tools that are able to just make shit up and seem totally confident about it. They're not the only ones that hallucinate. All prediction and recall systems that are inherently probabilistic but need to tell only one story are likely to be susceptible to this kind of thing, including any and every AI we will ever develop, including ourselves. Claims need to have evidence and be independently verifiable or you shouldn't trust them. Even your own claims.
It’s part of the Louisiana suite of online service.
There is Also “HIreIT” for unemployment and some similar catchy names for housing.

They are all peculiar system with weird UX.
> and importantly be sure to leave a list of who your enemies are, to give the detectives a starting point.

This advice seems to apply only to a minority of people that have enemies that might consider killing them and have the resources to do it without leaving much evidence behind. I don't think this would apply to the average person.
Honestly this feels like a good reason for them to open source it. You trust the local model and may try using it instead of one of their competitors like OpenAI. If they took LLAMA in the state they released it in and hosted inference, nobody would use it due to the lower quality and data privacy issues.
if you're deficient in any of the vitamins or minerals you will develop clinical symptoms. seems pretty believable to me.
I've searched for Geekbench result: https://browser.geekbench.com/v6/cpu/1584694, it says DO-Premium-Intel 1 Processor, 1 Core, so I'm assuming it's the 7USD/mo plan from https://www.digitalocean.com/pricing/droplets#basic-droplets.

The score on Geekbench is Single-Core: 838,Multi-Core: 842.

While in our tests the cheapest ARM64 plan on Hetzner is CAX11 2Core, 4G RAM, about 5USD/mo, the Geekbench result is Single-Core: 1072,Multi-Core: 1921, so assuming it about 20% faster than DigitalOcean.

We've done the same test on Rpi4B too:

Processor : Cortex-A72

CPU cores : 4 @ 1500.0000 MHz

Score is Single-Core: 247,Multi-Core: 387

For your reference.
That's exactly what I do too. 'SELECT * FROM', then write the rest of the query, then double back and replace the * at the end.

Is it ideal? No. But it's muscle memory now, so...

¯\_(ツ)_/¯