skysight-inc/HackerNews huggingface dataset:
Driving that further - I don’t want to have to edit my query for minutes when I am in the shell. I don’t believe that the shell is conducive to complex SQL queries. You could write simpler SQL queries, but then you’re in a space where there are less verbose tools for those simpler tasks.

DuckDB seems stronger for someone who needs to create a scripting library - which also has lots of options and competition - or someone who has a very specific workflow of working with JSON dumps for a huge percentage of their time.
Some notes why I posted this: I was surprised to read in some HN discussions recently that TLS certificate pinning is discouraged and CT log monitoring is promoted as an alternative.

Key pinning has a lot of risks and problems, but I didn't see how CT log monitoring could be a viable alternative: Log monitoring may give you reliable alerts (within 24h granularity and with lots of false positives though) that someone may try to impersonate your domain, but it always seemed pretty nebulous to me what you're then supposed to do with that information - if you're happen to not be Google and can't just push a global update to Chrome to put the certificate and CA on the ban list. (In contrast to key pinning, where you have the means to prevent impersonation, even if those means come with a lot of footguns to be aware of)

I just found out that deprecating key pinning in favour of CT monitoring is indeed Cloudflare's official policy. So I was curious what their reccommended course of action is when a domain owner is notified of a malicious certificate. Turns out, it's "improvise".

So I'd like to know what your best practices would be to deal with such a situation.
Fitness is specific to an activity, but yeah, the Barkley Marathon is probably the hardest form of ultra running.
Proof of work was the first of the consensus algorithms to be used with blockchains because Satoshi (imo, probably Hal Finney) likely didn't know about Proof of Stake at the time. By the time it was being discussed, Satoshi was already becoming less active in the community.

The claim PoS is not the best store of value is asinine. PoW in BTC has consolidated around a cabal of a handful of miners and the power usage is of course a well-known sounding bell for PoW apologists everywhere.

The truth is PoW was the best they had at the dawn of blockchain, then technology improved. It's really this simple and I'm baffled when people get religious about consensus algorithms. It's as if people would say we need to keep using bubblesort instead of quicksort because bubblesort was discovered first.
You can get tested for this if you have ASD by getting a copeptin test.
> From what I recall, the economy was in the toilet at the time too, there were rolling blackouts, general strikes and all manner of things just falling apart.

That's right, except the bit about "general strikes". There were flying pickets: workers would travel across the country to support strikes by workers in other industries, rather like football fans. But to the best of my knowledge, the only General Strike in the UK happened in 1926.
In the US the share has grown from 12% in 2012 to 23% in 2022. You might still have issues with the speed of transformation but your facts are not right.
https://www.weforum.org/agenda/2023/03/us-electricity-energy...
Tiny tesla valves would be super interesting, potentially in the context of cell sorting, perhaps?
yeah, I already pushed a fix for this. Thanks!

https://github.com/semanser/codel/issues/1
So currently the service is only an MVP. Right now you're only able to see all the nearby spaces available, though I'm extremely interested to hear what you'd like to see from a tool such as this! Will be more than happy to integrate suggestions.
Understanding artificial intelligence ethics and safety
> "Modern slavery system" is hilarious

Admittedly, their modern system is a huge improvement over v1
Good news, especially after this report seems to hint at underestimated levels of CO2 emissions on ICE and hybrids https://climate.ec.europa.eu/news-your-voice/news/first-comm...
An iconoclastic recent book: The Dawn of Everything: A New History of Humanity

https://www.amazon.com/gp/product/1250858801/ref=ppx_yo_dt_b...
That is a somewhat silly statement; obviously it only makes sense to build nuclear plants if the resulting energy is cheaper than the alternatives. And nuclear power is as the most environmentally friendly source of energy we know of.

The argument, as it has been for about 40 years now, is that the people saying it is not cost competitive tend to have high overlap with people who are changing regulations to ... make it very expensive. If the regulatory framework was sane, it'd be quite cost competitive.

The problem nuclear has is the economic learning curve has been inverted. That can only be caused by overregulation.
The tools (mostly) all start out simple, as you described. Then they start to get traction and users. More users equals more diverse use cases and feature requests. Each individual request makes sense, for that group of users, and is implemented. Slowly the software grows in complexity, until you have Hugo etc... Then people say it's too complex and start over - and it all happens again.

This applies to all software - and most other things that humans make that have large numbers of users, like governments, countries, or other systems.
Would you rather prefer to have a directory of spaces to pick from and/or the ability to add new ones to a specific list?
My iPad 3 with its high res retina display is still very usable for watching videos, but is stuck on iOS 9.3.6.
You're right I guess. The price of gold is manipulated heavily by the banks so it is not a perfect measuring device. There is literally a Federal Reserve memo on Wikileaks describing how the government would create FUD about gold through the futures market. But the supply of it is nevertheless fairly constant compared to just about anything. People have remarked that an ounce of gold today buys about the same as it did thousands of years ago. I think they are right. The price of oil is clearly less stable than the price of gold. You could do better if you compared many goods in a basket, perhaps, but you just can't trust the government to do it right.

>perhaps. Seems fairly tangential, unless you're implying that governments generally tend to severely underreport inflation most of the time.

Yes that is exactly what I'm implying (or stating directly). I am mainly talking about the US government because I don't know how other governments calculate their rates, but it is probably about the same everywhere. I think in recent times you could do well by doubling their number.

The US government also misrepresents unemployment. For example, if an unemployed engineer gets a job at Starbucks one day a week while applying for a new gig, he is not counted as unemployed anymore. He is also not counted if he is unemployed for any longer than 6 months. Perhaps we need to report them all as unemployed along with the median time to get a job, and/or have a separate number for skilled workers that does not exclude them if they are forced to take an inadequate job.
I really expected a 3rd party company to be producing 3-pronged versions of that adapter.
In the UK the ground pin is a requirement as sockets will not fully open up the other two before the ground pin is inserted, and Apple's UK adapter has a metal ground pin, BUT still it's not connected to the 3rd internal prong of the charger.
The extension cables that you can still buy separately, and that used to come free in 2012-2015 MacBooks have the 3rd prong, hence are grounded.
WHY, APPLE?
I understand it would be super interesting to find biological processes similar to earth like life similar to our light, water & dioxide cycle (im sure there's a name for it)

But sometimes it sound like many people think that's the only way life can start, yet we have no idea how it really works. Also on earth there are organisms in the deep sea that have completely different biology. We might find life, even sentient one, in places we haven't thought to look.
Very "Welcome to Nite Vale"
https://www.welcometonightvale.com/
DVD Format/Logo Licensing Program will be terminated at the end of 2024
What exactly do you mean by scale?

As long as you are doing OLTP using an RDBMS, I believe the proper way to "denormalize" is to just use materialized views and therefore sacrifice a bit of write performance in order to gain read performance. For the OLAP scenario you are ingesting data from the OLTP which is normalized therefore it's materialized views with extra steps.

If you are forced to use a document database you have to denormalise because joining is hard.

So if by scale you mean using a document database, sure, but otherwise, especially on SSDs, RDBMSs usually benefit from normalization, by having less data to read, especially if old features (by today's standards) like join elimination are implemented. Normalization also enables vertical partitioning.

There was an argument to be had about RDBMSs on HDDs because HDDs heavily favour sequential reads rather than random reads. But that was really the consequence of the RDBMS being a leaky abstraction over the hardware.

Document databases have a better scalability story but not because of denormalization. Instead it's usually because of sacrificing ACID guarantees, choosing Availability and Lower Latency over Consistency from the CAP (PACELC) theorem.
https://archive.ph/NfmNa
Your reading habits, tv show preferences etc already reveal your politic beliefs and they have already been categorised by advertisers like Google/Facebook/Apple/Microsoft and sold to countless data brokers and government agencies already.
“Thanks to Apple”?

The original iPad was a 32 bit A8 single core CPU that topped out as 1Ghz and with 256MB Ram and used the ARMv7 instruction set.

How do you expect a modern day OS with requirements to deal with real world sensors, and user requirements that didn’t exist back then, to run against that?

The latest iPads have 2GB Ram, are 64 bit, run multiple cores and have embedded motion coprocessors and neural capabilities running a much later instruction set.

Let’s be reasonable here - that device is now about to be 14 years old.

And, if “the hardware works beautifully” how is it “pretty much a brick”?

iPads are not the same as laptops or desktops. Sure, you can still run some Linux distros on older 32 bit hardware, but everyone who does knows of the limitations of doing so and realize that they lack the horsepower of modern day computers and use them accordingly.
Google engineer claims Bengaluru Uber driver abused him
Maybe it is not the planner. On difference between those other databases and PostgreSQL is that their plan do not depend on how freshly the table was vacuumed. The cost of your "correct index" may becomes worse when the rows are updated until they are vacuumed.
Whose/what facts? I’m not talking about the US and neither is the OP or GP.
I hope you see the irony in using “you’re holding it wrong” here?

If real world use of a library tends to push towards a certain outcome that I dislike, I’m going to tend to dislike that library.

You’re also never going to convince me that creating an interface for a single implementation is the best way to facilitate unit testing.

Mox is nothing more than a kludge to get around the limitations of the language and I think there are much less invasive kludges available. To be honest when I’m working with devs who are new to elixir I’m embarrassed when I have to explain how Mox works.

>but in practice it's better to hardcode things rather than trying to make it generic and swappable the first time around. Junior devs have a tendency to over-engineer code "because we might need to change it later." My motto is "copy and paste it three times before adding a layer of abstraction"

This I agree with 100%
it's as if the interests of the financial sector and the common man are not in alignment...

but that would be impossible, right?
Superhot Rock Geothermal May 'Unlock Vast Amounts of Clean Energy'
Want more data? Create an mobile app to cartograph new rental appartments. I know in other countries you often rent with furniture in it. We in germany for example take everything with us and have to check if/how the furniture fits.

With a system like the one in the video you walk through the old place, and walk through the new place, and output for example 2 Sweet Home 3d plan's.

No need to have 3d glasses for that.
Well done! Where does this get data from? I remember thinking about something similar, but deciding not to go forward because of legal issues.
As with all such tools the issue is the automatic layout algorithm.

I find that almost all layout algorithms for database diagrams are rather poor.
The "Renamed To" was bothering me (like some other posters mentioned), and then it hit me why:

Forks of large projects happen when something bad is going with the source (why fork something huge when things are going ok?), and marks the source as poisoned.

Renamed means... It just changed name, everything is already, nothing to see here...

Sure there is the mindshare on the name but people in IT for long knows what means when a fork of this size means.
I have a soft spot for these management cybernetics schemes. Functionally these are cults. I don’t mean that in a negative way but there is interesting baggage. We can look at the evolution of cults to glean information about the hyper-parameters of their incentive structures. As usual everything is nice as long as things are going well.

It is fun to think about but in the end, if we met an advanced civilisation with a system of fully automatic morals we would only give them our cold disinterest. This is logos, but we also need ethos and pathos.
This one, from a couple of days ago, might address that issue as well:

https://arxiv.org/abs/2403.13187
Not exactly the same thing but I've been thinking quite a bit about concepts around the idea of "RSS as an alternative to social media". Interestingly just yesterday I started sharing the Beta of something I've been working on around this idea: https://app.recessfeed.com/

Wrote some thoughts about it here: https://github.com/yakkomajuri/recess/blob/main/manifesto-is...
The miners also went on strike a year before the Yom Kippur War, blaming competition from cheap oil imports.

https://en.wikipedia.org/wiki/1972_United_Kingdom_miners%27_...
> In a practical way, crypto is super useful for extortion schemes, blackmail, money laundering, tax evasion, etc. It is way easier to use than gold.

All of this existed before crypto and will not disappear when crypto is banned.

> At the same time, there are very few use cases where crypto is useful for law-abiding citizens. Using a commercial service like wise.com is way safer than using crypto for almost anybody.

It's funny that you mentioned wise. They just kicked me out for no reason. I know they kick you out if you buy crypto through them, but I didn't do that.

So there is absolutely an usecase for a cash like currency for the internet. It's my money and I should be able to spent it however I want, without a private payment processor enforcing their beliefs on me. If I want to donate to WikiLeaks or buy crypto I should be able to do so since it is not illegal.
Apple should be forced to fully open up TSS for a device when they move them into "vintage" or "obsolete" status
This is more relevant than a financial expert’s input.

https://en.wikipedia.org/wiki/List_of_cognitive_biases

Also,

>financial markets are doing well

(presumably this means equity prices for shares of publicly listed businesses increasing at a sufficient rate)

and

>depression, people complaining, news

are unrelated things (assuming you mean emotional depression, not economic depression).
MH370 – A New Hope
Cranking up the batch size kills convergence.
The fonts here are superb, I found the page to be highly readable and absolutely cute without being over the top. Delightful :)
I'd think that all of them would be solved by time. I'm just saying they are nothing to be concerned with until they are (and we are still far way from that point in time). They are just fancy demos to make a company look attractive to investors.
> it wasn't as simple as it says

mind elaborating? we built loki for some pretty massive scale but I've always tried to make it work at super small scale to. what went wrong?
Neither FTL travel nor unitary interstellar civilizations are necessary for the Fermi argument to bite.
That reminded me of The Gashlycrumb Tinies:

https://en.m.wikipedia.org/wiki/The_Gashlycrumb_Tinies

... I feel like some cultural element, at least during a certain era, is coming into focus for me.
That's rich coming from someone who definitely doesn't lean left.
Finally found it:

Article:
https://effectiviology.com/shirky-principle/

HN discussion:
https://news.ycombinator.com/item?id=39491863
Circular Economy in the Mining: Possible Solutions for Water Recovery
This is not true. There are several websites not reachable from either the US or Europe.

South Front and Strategic Culture are two such examples.

Russia Today etc are not reachable from most EU countries.
Look beyond the averages and you will see that it's not so much financial markets overall as a narrow slice of them doing well.

https://russellinvestments.com/us/blog/market-concentration-...

https://www.reuters.com/markets/us/peak-us-stock-concentrati...

Late stage bull markets tend to look like this: still going up, but mostly due to a shrinking number of stocks which benefit from mass reallocation out of everything else.
I agree with your point, but my comment was about the situation here in Norway (which I should have made more clear). The overwhelming majority of electricity generated is from hydro power. We have not had the problem of having to little electricity, except for extremely dry years, but then we import electricity from Sweden and the rest of Europe.

What we see now is that the data center industry lays claim to a lot of power generated in many regions, increasing the demand for electricity at an alarming pace. The same seems to be happening other places in Europe. We keep needing and using more electricity, without really moving away from fossil sources. And the renewable energy sources are far from clean to produce, wind and batteries require a lot of minerals and extractive processes that is highly polluting and Co2 expensive in other parts of the world.

I do not know enough (yet) to be categorical in my claims, but I have started looking into the numbers, and from what I have seen so far, I'm only getting more worried about the path we are heading down.
Meltdown – Interface for Llama.cpp and ChatGPT
The past survival of livable conditions on Earth is no guarantee they will persist for very long in the future. There's observer selection bias to consider. For example, the O2 level in the atmosphere could drop below that needed to sustain higher life. As I understand it, there's been no feedback mechanism identified that stabilizes O2 at current levels, so the persistence of adequate oxygen over the last 500 million years could just be an unlikely accident.

In the absence of burial of photosynthesized materials atmospheric O2 will disappear in a few million years as reduced materials are exposed by geological processes and then oxidized. So, the time constant for O2 fluctuations is rather short.

If and when we spread into the galaxy, we may find many planets where livable conditions were snuffed out before intelligence could arise. In our own solar system, both Mars and Venus may have been more habitable than Earth earlier in the history of the solar system, but now are forever ruined.
Some people have only experienced ZIRP. This is the post-ZIRP transition process.
Ah ok, so TikTok has voluntarily disabled across to Indian users due to a government order which is not a ban. Interesting.
Selection bias of the pictures they decided to show, I guess.

By the way, there is another one with them ridding horses.
That is the equivalent of saying that the direct expression of a musician‘s work are the sounds they produce and therefore they should be heard in isolation.
But as much as an orchestra produces symphonies as a group, development teams produce software as a group. This output matters and should be looked at, the individual code contributions to that output matter less and looking at them in isolation doesn’t provide insights that looking at the team‘s output in terms of working software, bugs, incidents and more wouldn’t.

A manager looking at the individual LOC contributions is looking into the wrong direction.
Explore LVGL on NuttX RTOS – Rotary Encode Demo
Not GP. Clinico-laboratory detected cancer will never resolve without treatment and will lead to death, fast or slow. I do not understand the second point. Anticancer treatment is very stressful and damaging in many ways (middle ages' level of technology...) but care is taken that its side effects are less than the desired ones
Very valuable contribution!
Historically, a recession follows shortly AFTER the fed starts cutting rates. See also: https://fred.stlouisfed.org/series/T10Y2Y/
The grey areas are recessions.
Dropbase looks neat. Couple questions based on my read of the site/github/docs:

- is the architecture exclusively hybrid SaaS? Looks like I host a worker node but a cloud connection is still required.

- how can I monitor the data flow between the local worker and hosted orchestrator? I assume it’s straightforward to turn on verbose logs on the worker’s requests out.

- is the IDE hosted locally or remotely?

- authentication to local services appears to be done primarily through credentials hardcoded in the ENV file. How can I use SSO and pass user authentication to the upstream data sources?
Lack of agency is right. No ability to request medical aid even when suffering crippling pain from a burst appendix.
> I'm definitely in favor of breaking up the *capitalists*. I don't see why we should let a small group of people hold the whole economy hostage just to enrich themselves.

See what I did there?

The hostility to unions on this forum comes near exclusively from American posters, who coincidentally, have very poor workers rights compared to anywhere in the UK/EU/EEA.

Unions provide a balance of power to employers. The made our work places safer, gave us holidays and fair pay.
Does this page use HDR effects to highlight on hover?
> … just creepy and not age-appropriate.

Probably not unrelated to the Yewtree types being untouchable in that period.
Yes.

You're right. Absolutely, completely correct. There's almost certainly other ways life can start. Other processes that can result in intelligence. Other paths of technological development.

The issue, as I understand is, is that all of those are completely unknown. We have absolutely no useful idea of how to look for wildly different life in places we haven't thought to look.

What we do know with certainty is that Earth's chemistry can result in life. We do know that it can result in intelligence. We do know what paths our technological development took. We even have some idea what these things might look like from afar. All together, we have exactly one data point that lets us search for similar data points.

Are there other, different world, with different life? Very possibly. We humans are well aware of this. We just don't have a way of knowing if we've found anything. So as a matter of managing limited resources, there's a tendency to stick to what we know can work.
It's been said for fifty years but bears repeating: "The stock market is not the economy".

They say so themselves!

https://www.nasdaq.com/articles/the-stock-market-is-not-the-...