skysight-inc/HackerNews huggingface dataset:
> You have two tables then CUSTOMER and ORDER and you JOIN them. Why not just put the orders inside of CUSTOMER? Because now you can't query it, because you don't know how many columns will come out and you can't have disparate columns across rows.

Why wouldn't you be able to query it? You can query JSON fields that contain lists. Why not SQL fields with strongly typed lists?

> Sure, it's a different way of thinking. But its faster, its MUCH safer, the invariants are actually properly specified.

Why would it be safer?

An embedded list has pretty clear and obvious semantics. And as ekimekim said in another comment, postgres already has partial support. Apparently this works today:

CREATE TABLE example (
height number_with_unit, -- our composite type, eg. (6, 'ft') or (180, 'cm')
known_aliases TEXT[], -- list of string
active_times TSRANGE, -- time range, ie. (start, end) timestamp pair
);

An embedded list also sounds much faster to me - because you don't have to JOIN. Embedding a list promises to the database "I'll always fetch this content in the context of the containing record". Instead of (fetch row) -> (fetch referencing key) -> (fetch rows in child table), the database can simply fetch the associated field directly.

> But I wouldn't dare touch a mongo instance without going through the application, because all the constraints are willy-nilly implicitly applied in the application.

Yes, I hate mongodb as much as you do. I want explicit types and explicit invariants. But right now mongodb has useful features that are missing / unloved in SQL. How embarrassing. SQL databases should just add support for this approach to data modelling. Its nice to see that postgres is trying exactly that.

In programming, I don't have to choose between javascript and assembly. I have nice languages like rust with good type systems and good performance. We can have nice things.
prompt: "spork", model: "NovelAI v3" (aka finetuned SDXL)

https://ibb.co/nLMZfjY
It’s not clear to me in 2008 that anyone committed fraud to the level required.

My understanding was more that things were disclosed deep in the fine print, and nobody really verified anything and didn’t have a legal obligation to do so.

Who allegedly lied to the point of it being fraud in 2008?
...and a lot of solo developers and academics besides. (I say that as a corporately unaffiliated PyPA member)
Yeah the scam itself is not meaningfully distinguishable from eg the good old Nigerian Prince emails.

But the distinctive characteristic of the new model is to operate at large scale with human trafficking.
Google's AI search gives sites dire choice: share data or die
Seems weather websites actually have great reporting on this.

Angela Barcares, Mike Lynch’s wife, survived. Speaking to the Italian daily La Repubblica while sitting in a wheelchair in a Sicilian hospital, Bacares said she was woken at 4 a.m. local time as the boat tilted.

She said she and her husband were initially not concerned, but became worried when the windows of the yacht shattered.

The yacht sank after a small waterspout – a type of tornado – spun over the Mediterranean island, likely capsizing the boat, which was anchored about a half a mile from the port of Porticello. Eyewitnesses described furious gales and hurricane winds that left a mountain of debris near the pier.

One witness, the owner of a villa looking out to where the Bayesian was anchored, said that after news of the sinking yacht emerged, he watched back his CCTV footage, where the boat could be seen sinking.

“In just 60 seconds, you can see the ship disappear,” he told Italian outlet ANSA. “You can see clearly what’s happening. There was nothing that could be done for the vessel. It disappeared in a very short time.”

...

“Looking at the extreme weather, if it was a water spout, which it appears to be, it’s what I would class as a black swan event,” he said, referring to a rare, unpredictable occurence. “Even outside of the maritime industry, all industries struggle with the black swan events,” he added.

https://www.accuweather.com/en/weather-news/four-bodies-foun...

Pretty horrific and bizarre especially considering his daughter was among the victims. As others have mentioned the 75-meter mast and position of the keel could have been factors but the investigation has to run it's course.
What sort of fraud in 2008 would be similar to just wiring millions of dollars out of the bank to a personal investment/scam?

The most egregious stuff in 2008 was mispricing MBSs. Incorrectly pricing risk is pretty far from stealing money from investors/depositors.
AI Render for Blender 4.2
Hi all! I built addon for blender to upscale, enhance, and reimagine your renders with a single prompt using the Clarity-Upscaler model by replicate. Plan is to make it works with different models. Appreciate your try and feedback!
HP was going through their "who the hell are we?" disaster phase then and hired a useless CEO who got kicked out of SAP.
And if you want to go full circle, you can use rss2email[0] to manage your RSS feeds in your favorite email client. Yes, even gmail.

rss2email was originally written by Aaron Swartz.

[0] https://github.com/rss2email/rss2email
one possible approach: linux multi-boot usb drive: http://github.com/adi1090x/uGRUB
If you've passed a car before, it feels pretty clear that minimizing your time spent in the same lane as oncoming traffic is a much bigger priority than minimizing how much you go over the speed limit.
That isn't entirely fair.

1) The risk of evacuations happening is tiny and I'm not even convinced it is still a factor. We've not yet seen a messy meltdown of any plant designed and built after Chernobyl in 1986 and designs have changed a lot since then.

2) We don't know what a large-scale solar disaster looks like yet, but they might happen. For example I recall the Wikipedia page for the Year Without Summer [0] - we know that sometimes nature puts things in the atmosphere that might hamper solar in a way that nuclear can be designed around. IE, we might find we now have a risk of our power stations just deciding to produce less one year because of a usually unrelated disaster. Or maybe even stop if there is enough volcanic ash.

Plus renewable projects have had a more noticeable association with grid failures and mishaps than nuclear projects. We really don't have much experience with what mass solar failures (if they do exist, but they probably do) look like or how common they are.

[0] https://en.wikipedia.org/wiki/Year_Without_a_Summer
You misunderstand the costs involved. The cable is cheap per km, the cost is largely HVDC equipment at either end.

This is why they aren’t breaking things up into several shorter hops to various islands on the way.
Normally I’d agree with you, but they’re talking about the built in tooling. That isn’t going away anytime soon. If it’s good enough for their purposes they should continue using it, especially with no clear consensus on a “better way”.
> They definitely* ramped up their absurdist side some time in the 2010s.

Huh? Naah. Or, maybe -- perhaps they ramped it back up in the '10s, if they'd ramped it down a lot in the '00s. Because they were wildly satirical in the '90s.
Open to everyone, but requires a computer. Has the definition of everyone changed?
You weaken your own position by arguing from emotion, using charged language, and insisting your interpretation of the evidence is the correct one.
I was hoping this would be a human system simulation for drug and disease research, instead of entertainment. Pretty cool, though!
I'm currently reading Kyle Chayka's Filterworld: How Algorithms Flattened Culture, and even though "algorithm" means something slightly different in the two ("actual algorithm" vs "algorithm-meaning-AI"), it almost feels like Naomi Kritzer's short story is the optimistic (but fictional) version of the more capitalist-driven, bland, and less human- and culture-focused reality described by Kyle Chayka.
yeah I'm with you there. Pig butchering scam [1] is just a simple con, not sure why they're attributing any importance to the name of it

[1] https://en.wikipedia.org/wiki/Pig_butchering_scam
He just did not want to keep his boss waiting longer than a week without a "solution" so he forced something to wash his hands of it.
There are many small things you can do right now — avoid buying food or drink that is in plastic, avoid storing leftovers in plastic, avoid plastic cutlery and plates. Never heat up food in the aforementioned plastic.

But the 80% number may be hard to reach, depending on what your current intake is. And since there’s no real way to measure what your intake is, and how low you get, it’ll be much harder.

Moving to a farm won’t necessarily help. You still need to buy things to run a farm, many of which are packaged in plastic. You still need clothes. There will always be some element of risk involved.
The use of Z-axiz cement extrusion is, to me, pedestrian in vision.

Id much rather have a 6-degrees nozzle that can do organic shapes in the landscape, and especially sub-terraniean tunnel dwelling: Carve tunnels/cave outs powderize what you carve out, mix it into slurry cement augmented with various fortifying elements, grwo a mycelium very porous - loofah like spongy wall membrane and spray into it the slurry of aerogel-particle-insulating filler materials for fire, radiation, weight reasons and the robot has multiple nozzles on arms that have spray heads like mini cropduster apparatus to spray the foam in.

But you use soft robots to expand the foundations and run fiber and other wiring/cabeling/ventellation tubes through the loofah then spray around it. where the spray head is on a steerable flexible sof robot, and the slurry is pumped through one of the many tubes of the Mars HydraPed.

https://www.youtube.com/watch?v=eLVAMG_3fLg
evocative imagery gets clicks
Such professionalism and high quality care like this are why American doctors deserve their huge salaries, massive houses and vacation properties, boats and sports cars, and of course are entitled to our thanks and adoration. Truly, a saintly class of people who all got into this line of work to help people.
Not necessarily. Some people do vendor their packages in the repo for consistency (though admittedly it’s rarer).
I've passed plenty of cars. Usually, in this scenario, I can exceed their speed by 15+ without even crossing the speed limit. If I had to go 10+ over the overall speed limit to pass them, I almost certainly just setup a situation where I'm either speeding in general to stay ahead of them, or I moved a single car's distance in the line that I was in. Which... seems silly to argue for.
...which might still be socioeconomically correlated. People who make half a million a year can afford lawyers. People who make $50K/year generally cannot.

The interesting point here is about how so many institutions become so much sloppier when the legal system becomes unaffordable for a majority of residents. Unsurprising, but it has pretty far-flung consequences if you're trying to root-cause why so much of America seems like a 3rd-world country today.
This is really neat. Hoping your plans to make it work with other models also includes local models
> The difference between running a scam and running a failing business is just a matter of intent

Perhaps in some cases but "running a failing business" becomes fraud when you start lying, even if your intentions are "good".
Summarizing from the article, this link [1] shows that there were more sources of generation that ERCOT didn't ask to come online. Specifically, all the capacity that could come online with 5 minutes was online except for a tiny 130 MW of generation.

[1] https://blog.gridstatus.io/content/images/2024/08/ERCOT-Reca...

Instead of calling for something that needed more than 5 minutes, ERCOT relied on all the batteries on the grid. I don't know what this quote means:

> 2,000 MW of extra capacity released from ECRS.

But I do know what this means:

> battery discharge peaked 20% higher than the previous record, which was set only the day before.

It's referencing this graph: [2]

[2] https://blog.gridstatus.io/content/images/2024/08/ERCOT-Reca...

The graph has units of Megawatts. In other words, the thing that was record setting about the batteries was not the Megawatt-hours, or total storage in battery systems.

What set the record was the instantaneous power usage, and apparently the batteries in Texas were at their hottest ever. (No idea if anything caught on fire though!)

Here are some more assumptions I am reading into this:

* The 130 MW that didn't come online may have been rotated around. Maybe all the generation jumped in at different times, guided by supply and demand, but ERCOT regulations likely played a role in keeping the existing systems from exceeding the demand or blowing up transmission lines, etc.

* The article says "Solar and Demand Were High Throughout the Day" but I assume that simply means that over time, more and more solar will be installed and more businesses and cities are becoming aware of https://www.ercot.com/services/programs/load (Demand Response). It means they can get cheaper electricity at night for instance, so they run their power-hungry machines when the prices are low.

* Never underestimate the power of Nature. Probably the daytime temps in Texas right now drove the high solar production and high demand. High temps usually mean clear, sunny days and everyone huddling near an air con.
It's still unclear to me that we should expect continuous reinfection with additive impact (eg, continuously losing olfactory function after each infection, as you say). That sounds fairly speculative.
The footer has a 2021 copyright.
Americans are doing less DIY. It's another worrying sign for the economy
All of what you say may well be true, and yet: everyone else on the internet manages to make it work.

Password managers don't have to be cloud services. The user gets to choose.

Some of us like to use a different email address for each account on purpose.
There is also many places where there are extremely few posted speed signs. The A9 in Scotland from Perth to Inverness is a notoriously dangerous road (it has large sections of single carriageway [60mph] with occasional dual carriage [70mph]). It has many junctions where cars can cross lanes to leave on minor roads. So bad, it has a large system of average speed cameras to hopefully control the traffic.

Driving slowly (40-50) on this long road will cause cars, buses and trucks to try and overtake even on the single carriageway sections which is risky for everybody.

But very few actual speed signs, so you end confused and wondering exactly what is the correct value for that section and anxious about the next average speed camera. And that’s for experienced uk drivers, I hate to think how stressed the tourists are ?
AI Uncensored: a fine tune of Llama 405B to remove political bias
Austin Energy? There aren't many providers that I am aware of in Texas that have variable rates.
Wtf is happening here what are the inputs and outputs? Hard to tell what this program does for me
I've had a lot of similar experiences the last few years. I've had moments where I thought it was over and all better but it slips back away again.

You're not alone. And health care sucks.
The workers in those pics have no hearing protection, no eye protection; no helmets.

Yeah, must be the 50s.

My 75 years old carpenter is half deaf, his grandfather fell from a roof and died.

He himself fell off a roof in 1981 but was lucky and survived.

Just some thoughts seeing those men working in those conditions.
Only when valued in US Dollars. When valued in AUD the price of gold has dropped.

the main drivers of recent gold gains have been the weaker U.S. dollar and ...
It's funny seeing this after the arguments in the mpv thread a few days ago[1] where over if VLC's extra bloat (and lack of features like stepping back a frame) is justified by it coping with diverse formats. This file doesn't play correctly for me in mpv[2], but does fine in VLC.

[1] https://news.ycombinator.com/item?id=41277014
[2] https://imgur.com/TeL4sfq
I know the argument about its historical usage which isn't a great one if you're also going to argue that language changes. In any case, I'd prefer that it change for the better. An optimist might even hope that it is discussions such as this one which influence how it changes.

Are you suggesting that we dispense with he/his/she/her in all cases? Like in this one to refer to a male or female dog?
This was the line that got me also. Did he not realize how stupid the words coming out of his mouth sounded?

I've heard that scam victims often double down and put on blinders, because the alternative would mean they were being scammed and they don't want to accept that. But man, those are a huge pair of blinders.
Friendly reminder that the "U.S. Chamber of Commerce" is not a government organization, but a privately funded corporate lobby group.
The fact that the error happens _at run time_ is exactly the point. Whether the error is handled or not has nothing to do with the point of the post.
No no no, give yourself more of a challenge.

You need BSD desktop. https://www.ghostbsd.org/

That's where it gets really fun.
I'd wager that adding "I am aware that XYZ has done some shady stuff in the past" when praising any XYZ is starting to become a common defensive hygiene in internet forums generally, just to preempt that inevitable somebody who is "absolutely outraged" and wants to ruin your day because you could ever like XYZ.
> granted, he'll probably fuck up his first two or three pretty good without haynes or chilton

Given the assumptions, inaccuracies, and mistakes I've seen in some Haynes and Chilton manuals they'll probably fuck up with them. Factory manuals are usually worth the price (Honda's are, KTM's not so much).
> It’s interesting that this one guy gets 24 years over 47 million dollars. Yet, not a single executive, board member, VP or SVP got arrested for the fraud that lead to the 2008 crash. We are talking orders of magnitude more than this and they declined to prosecute even though the evidence was absolutely abundant as we now know.

Can you show the abundant evidence that is available, and who committed the crimes you think they did and which specific crimes you think these individuals committed?
Well, it's the gravity that alters the spacecraft's trajectory. If the Earth was massless then the craft would just sail by.

Here's a nice short-ish web page from NASA with nice details [1].

Yeah, "back" seems a little wonky. Maybe somebody got confused by earlier plans? Your second link, to the ESA video, is from 2017 and evidently isn't what they wound up with. According to that video the Vensus flyby was supposed to have been last October, and next encounter would be Mars. Or maybe they're thinking "back down to Venus's orbit."

[1] https://science.nasa.gov/learn/basics-of-space-flight/primer...
Prior Drift
In short, if you want to appear like a corporation who acts in bad faith, aims to abuse their contributors and only cares about FOSS for the free labor they get from the people who are gullible enough to contribute, a CLA is a great choice for your product!
So I've got a new Ford does this, and it can operate in one of three modes selectable by the driver:

1. An advisory mode, where it dings at you if you bust the speed limit.

2. Speed limiting mode, where it won't accelerate past the limit unless you override the limiter by flooring the accelerator.

3. Adaptive cruise control, where the cruise control will speed up and slow down to suit what it thinks the speed limit is

The system uses a combination of speed sign recognition and and its satnav database. The speed sign recognition could be best described as "ok".

What it really struggles with is construction and other temporary speed limits such as school zones, particularly on side roads.

There is a spot near me on a 100km/h arterial road where if I'm using adaptive cruise, the car will detect the 40km/h construction limit on a side road and then brake hard to slow from 100 to 40 for no proper reason. This is very dangerous, tantamount to brake checking, which is a traffic offence that I otherwise could properly be fined for.
the term "pig butchering" originates in Chinese (杀猪盘), where this particular style of scam is often targeted at overseas people via WhatsApp. So "pig butchering" refers specifically to these scams run from China (or elsewhere in the region by Chinese operations), and it's what the scammers themselves call it. One of the distinguishing features is that they're often run by fairly large, organized operations with paid, trafficked, or otherwise long-term staff manning the WhatsApp personas. Similar to Indian call center scams.

Much like how "419" or "Nigerian prince" refers to scams coming out of a specific region.
Dave Bull Carves Hokusai's Picture Book of Everything
Have you seen the itemized bills for giving birth in an American hospital? They'll even try to mutilate an infant boy and charge you for it unless you emphatically opt out.
I believe he sent it to be converted into crypto, which he sent to a random cryptocurrency address.
There can be multiple most fundamental duties: https://proofwiki.org/wiki/Maximal_Element_need_not_be_Uniqu...
In Go, a runtime panic indicates a programmer error. This means you should not have written that line of code. The solution is to fix the line of code.
To force someone out who was guaranteed wouldn't be; to withhold documented caretaker/relative phone numbers from them when they have no other help; then to force them from the premises with no resources.

I want this to be a lie, but I don't treat HN comments that way. This is horrible, absolutely appalling.
So the day peaked at 85 GW of load, and they got down to only 130 MW of spare capacity. Just 0.15% from running out.

And they never asked for conservation?

Is it normal to go that close to the edge without trying to cut load?
I get annoyed when someone ignores my feedback and requests a review from someone else who is known to approve anything. I think doing this is fairly disrespectful and circumvents the point of code review.
The article makes it sound like it was wired directly to a crypto wallet in Hong Kong

Bank or not, good luck tracing anything through China. Odds are good this could have even been a nation state level scam run by North Korea. They get a lot of funding this way.
Interrupt-driven engineering: Working on what matters at Aha
Author here - this kinda feels like a controversial take, because so much productivity advice seems to focus on blocking out distractions. I'm not sure that it is though? Every high-performer I've spoken to on our team and outside seems to work on similar principles. I think the key is balance - as with most things. Would love to hear your thoughts.
Driving significantly below the pasted speed Without good reason will get you failed in the UK driving test for not making adequate progress.
As my office colleague found out recently.
I meant they replaced google for me and lots of people I know and interact with daily
For me, simply because I was tired of the shortcomings of Linux. I wanted something closer to a gaming console vs spending a week to get Ethernet over Thunderbolt working.
…which isn't a great explainer if you're not familiar with that Java tool.

Seems like it's an alternative to tk/tkinter.
IIRC 'blyat' means 'fuck' (or similar) in Russian. :)
GPT-4o mini and prompt caching, a turning point in debugging?