skysight-inc/HackerNews huggingface dataset:
For reference, this is the output:

WITH table_1 AS (
SELECT
customer_id,
total,
total - 0.8 AS _expr_0
FROM
invoices
WHERE
invoice_date >= DATE '1970-01-16'
),
table_0 AS (
SELECT
COALESCE(SUM(_expr_0), 0) AS sum_income,
customer_id
FROM
table_1
WHERE
_expr_0 > 1
GROUP BY
customer_id
ORDER BY
sum_income DESC
LIMIT
10
)
SELECT
c.customer_id,
CONCAT(c.last_name, ', ', c.first_name) AS name,
table_0.sum_income,
version() AS db_version
FROM
table_0
JOIN customers AS c ON table_0.customer_id = c.customer_id
ORDER BY
table_0.sum_income DESC
Yeah but that's just copy paste. This is more fun.
exaequOS is a full system, a kernel with drivers and apps. You can execute several apps in parallel
"Lack of evidence is not evidence of lack."
I've had a therapist before but they unfortunately didn't help as much as I'd hoped. I can often make systems that last a few weeks but single failure days cascade very easily. My hope is that with external accountability I can bootstrap these systems into working for months and become the kind of person that can reliably manage myself
Assuming an efficient market, price strongly correlates to (some measure of) value. Now if I over you something that's worth $5, or alternatively something that's worth $10 but that for a short you can purchase for just $5, which item do you choose?

Of course ideally you would properly evaluate how much the item is worth, in utility, quality, longevity, social status, resale value, ethical production, etc. But that's difficult (often on purpose). The seller knows what the item is worth, you have to guess, or just use price as a weak proxy.

So in a sense, people preferring discounted items is an effect of asymmetric information
They found out that they are idiots.
There is an easier way now!

In the "Files" app, tap the (...) icon in the top right corner and select "Scan Documents".
This is causing more package waste.
How did you get the wad of cash in the first place and what is it?

A wad of cash isn’t money. It is nothing more than a receipt for a deposit held at an institution somewhere - that was created as an advance in the past in response to an equivalent loan.

When you deposit a wad of cash in a bank, the bank takes ownership of the deposit in the institution and creates a new deposit in the bank for you. It’s just another loan creating a deposit.
Libsodium you mean. Has safe cutting edge crypto, and nothing else.
> We have gotten to the point where they admit to the presence of UAPs

They have always "admitted to the existence of" things they can't identify in some videos, blurry photographs, radar tracks, etc. UAP doesn't mean aliens, it just means "I can't tell what this is." Most of these UAPs turn out to be shit like commercial airliners far away on the horizon, and they remain "unidentified" because nobody cares enough to actually figure out what they are.

And you take this to be suggestive of aliens? Please!
He should write hard sci-fi. I would read it. I am fine with any hypothesis but doesn't mean we have tangible evidence.
Her point was to dress pretty and feminine and shock those who would casually assume that would mean something about genes and phenotype (and consider making a pass at her) into possibly realising that their presumptions are just that, and wrong.

The details are called human interest, and there were some interesting unstaged coincidences in there.

Not much was more important to her.
> but the thing to note about Tesla is that their design philosophy is to make the car as simple and evolvable as possible.

Like having a leaver on doors, which in ALL cars open the doors, but in Tesla it might also break the window glass, because some utter genius decided to make this "Emergency release" and normal opening is via button...
I think Bret Devereaux's article on why the Industrial Revolution started in Britain and not elsewhere is quite interesting ([1]). The Industrial Revolution happened not only because of advances in politics and engineering, but also because of Britain's unique geography: Early Britons chopped down many of the British forests, and so later Britons were forced to make use of coal. Trying to extract more coal more cheaply led to the industrial revolution.

This explains why the industrial revolution did not begin in China or the Roman Empire. There are some counterarguments to Devereaux's claims given in [2] and in the HN article.

[1] - https://acoup.blog/2022/08/26/collections-why-no-roman-indus...

[2] - https://rootsofprogress.org/why-no-roman-industrial-revoluti...
The context switching, for me, is made easier by separating the contexts in space and time (NB: No kids yet).

For space, I mean parts of the home or going to an office (I telework occasionally, but have lab work that cannot be moved or done from home). My home office is upstairs, I don't spend much time in that area unless I'm working on a computer. The sitting room (my reading space a lot of the time, future kid play area) is separate from the kitchen and living (TV) room. The home gym (such as it is, yoga mat and rowing machine) is in the basement (living in CO has a perk, nearly every house has a basement which is useful for storage, exercise space, and hobby space).

Even virtual spaces. My home office has, if I brought it home, two computers: My personal PC and my work laptop. They are not the same, I cannot access work stuff from my personal system. The only work app I have on my phone is Duo for MFA. When my telework day ends, I shove that laptop back into its bag and don't open it again until the next day. So if I'm working on a side project or even just gaming, I cannot easily go back to work.

For time, I find intermediating activities to separate contexts if needed (mostly work and home life). The commute is this, but when teleworking I'd go for a walk, do yard work, or exercise (often all three, no kids so that part of my day is still pretty much mine). Once I'm done with the physical activities or commute, I'm in a new context and have cleared my head from work. This works even if they're in the same space. Going back to virtual spaces, switching from work to hobby programming is easier if I've left the office for a bit.
In fact, it is not a thin client since all is executed in the client. it is more a thin server that is just a file server. The idea is to take benefit of the power of the device (more and more powerful)
> There's a good book on Athenian banking:

For a wider net, on the general legal framework(s) of that time, see perhaps Ancient Greek law in the 21st century, Perlman, Paula Jean, editor:

* https://utpress.utexas.edu/9781477315217/

It turns out one of the largest banks in Athens was owned/run by some slaves: finance was not a 'respectable' profession—with farming/agriculture being the most 'noble'—so it was left to the lower classes and other riff-raff. Lots of slaves ran businesses, and the question often came up whether any associated debt belong to the business, the slave, or the slave's master (important when slaves were bought and sold).
> This "medieval warm period" that doesn't look anywhere close to what we're going through

Southern Greenland, England, Russian, and Norway were all growing wine grapes during the medieval warm period. Some people claim the medieval warm period was regional, but this seems to be misstated - 55th parallel north across the world. Wine was being made in England as far north as York, and in the Americas, in Southern Ontario.

This calls into question the "regionalism" of the Medieval Warm Period.

One of the biggest reasons that the MWP is called into question is because the Climate Models don't have a good understanding of why, and we think it may have had a lower CO2 amount than today (although ice core drilling has numerous scientific problems)
no-one commits the price for litre/kg to memory
No. Just, no.

It's really arrogant how you assume you understand GP's situation better than themselves.
"Don't intefere with the enemy when he is in the process of destroying himself".

Those big companies also have mostly their own engines, so the majority of their products are totaly unaffected by this.
First off, SO2 breaks down quickly on geologic timescales. The cooling effect is short-lived. CO2 takes longer to move out of the atmosphere.

Next, modern day volcanic emissions aren't major players in current climatic changes, but that's not the case for the past. Large igneous provinces can dramatically alter global climate. CAMP magmatism was extremely widespread and prolific. You don't see the bulk of it at the surface, but large swaths of the eastern US coast and NW African coast are sitting on top of gigantic piles of basalt.

However, it's not _only_ CO2 for these large magmatic events. You're also dramatically altering ocean basins. Large igneous provinces are most frequently produced as continents break up. When that happens, you get a new ocean basin, change circulation, split things apart, introduce new species, raise/lower global sea level (ocean basin shape changes), and generally do a whole lot to shake things up. Continents can break up without much magmatic activity as well, but when you have mantle plumes involved in continental breakup, you tend to get the double-whammy of changes in ocean shape + lots of volcanic activity over huge areas. The extinction at ~200Ma (end of the Triassic, though the round number is a concidence) is a great example of magmatic activity having a large effect, but don't forget the impact that changing ocean basin shape/volume has as well.

Mass extinctions usually aren't things with single causes. Instead, they're generally the result of a lot of things combining.

Folks focus on the impact as the single cause of the K-T extinction, and while there's not doubt that it's what pushed things over the edge, other changes that had been ongoing for millions of years before had already stressed many different global ecosystems. You had major changes in volcanism (another large igneous province occurring during continental breakup, though it's smaller), reconfiguration of ocean basins, and other things occurring at the same time. The timing makes it clear that the impact was the sudden shock, but things were already heavily shaken up before that.
Funnily I was just thinking about this the other day, and beyond the problems of getting humans to follow any structured protocol (do you think people board in their group as it is? Boarding in stripes would be chaos), the biggest problem with this method is it would require families to split up. If everyone was riding independently then that’s one thing, but asking four year olds and other children to board independently of their parents is a huge non starter. Negotiating all the “yeah but”’s coupled with human inability to follow a process means this process would break down sufficiently to the point it’s likely worse than just random boarding.
A New Age of Magic
A small bottle or can are usually 330mL (though I think 250 also exists?) so technically they do. It’s usually going to be more expensive per unit tho.
Impressive, but it hurts me to see how much risk to loose his fingers he takes.
I am tech advisor to a bunch of startups. One of them doing stock buy/sell came to me with their MongoDB based system. The first thing I told them is that using a document based db for oltp for their use case was going to give them problems.

I saw it first hand 10 years ago, and had to do a migration.

Their justification for using mongo was that their system is very dynamic so their data changes a lot and sql based DBs dont allow that. I told them about DBA migrations and whatnot, but I just haven't been able to convince them.

It's sad seeing how they are digging into the same hole I had to digg out myself from a decade ago.
Interestingly, it seems like there's been a lot of articles published about microtransit lately. They just published one in our local paper about how each $1 ride costs about $40 to provide. It's a bummer, because the service is convenient but doesn't seem sustainable.
Pattern recognition is pretty much at the core of creative work in an engineering context, of which memorizing existing patterns is the first half.
> Fixed schemas are good.

I recall getting into an argument recently (perhaps on HN) wherein the central thesis for why SQL is bad is because the schema is "difficult" to change relative to a document store or other no-SQL abstraction.

If you don't have a clear idea of what the representative SQL schema might be for your problem or business (say, within ~80%+ certainty), one may argue you should not be writing any software until you've further clarified things with business stakeholders.

I strongly believe that virtually all evil which emerges from practical software engineering comes out of this "flexible schema" bullshit. If the business is certain of the shape of their problem, there is almost certainly a fixed schema that can accommodate. There are very few problem domains which cannot be coaxed into a strict SQL schema.
why not just self host at this point? this seems like security theater.
Why would you take the opportunity to associate it to incel culture?

He's a terrible excuse for a human being, let alone a police officer. Let's not distract people with blaming incels.
> Here in the Netherlands government is now trying to ramp down PV subsidies, because PV has been so wildly successful that electricity spot prices are actually negative at peak sun

Which means people should start buying batteries. Pull in power during midday at a profit, and then send it back out in the evening at a profit. I'm curious how long it'd take to pay back the price of a battery.
Try buying a half gallon of ice cream or a proper sized roll of toilet paper. Corporate greed, especially that is intended to cheat the consumer invisibly, always deserves to be called out.
I worked in a company which decided to make employees to come back to the office during the pandemic.

The metrics of performance and delivery were somewhat public and people pointed out that performance had increased due to a lack of distractions and interruptions.

The high leadership said the numbers meant nothing and people should return immediately. I will come back to this point.

Many many people did not comply with basic health requirements like using alcohol frequently nor using face masks.
One specific case was a "tech lead" who was infected with COVID but only used an open face shield without a mask. He went to the office even being sick and he got at least 5 cases that could be directly attributed to him.

One of my team mates complained because to me and as lead for that team I tried to mitigate the problem.

To make the story short, the face shield guy was praised by higher ranks and I was reprehended to stay with my team mate.

I left the company about one year ago but my team mate stayed.

Recently the company used the same numbers to layoff 25% of people due to poor performance.

I am glad to say that one person had a video of the executive saying that the numbers meant nothing and used that to win a legal dispute with the company. All dismissed employees have received 1 year of salary and had all benefits extended for that period.

Not the best solution I assume but better than nothing
In this country, equivalent products on the shelf alternate between listing a price per oz, and a price per lb, to make it more difficult to compare the two.

Its also in tiny 8 point font.
GIMBAL looks just like a jet aircraft on thermal camera.

GOFAST has been conclusively shown to be a slow-moving object at about 13,000 feet. It's simple geometry. We don't know what it is, exactly, but it's probably a balloon.

https://www.youtube.com/watch?v=PLyEO0jNt6M

So GOFAST is probably a 3 or 4, while GIMBAL probably is a 6 or 7 but even more pedestrian.
Where exactly is this extra higher cost you're talking about?
Anyone know what the US market (no pun intended) is like? Similar games, different ones?
That’s 20 minutes you have anyway if you work from home.

You could WFH, get up at the same time, spend 10 minutes meditating, 10 minutes walking and you would have been healthier and saved money.

Does your firm count that 20 minutes as part of your work hours?

If not, then WFH is superior.

How you use that time is a question for you to use your agency to resolve.
It meant something to me; I could certainly say that I felt connected with joyful movement when I test-rode an ebike last week. My partner and I were all smiles afterward.
Doesn't work that way: there is always an infinite list of possibilities without evidence to the contrary if you allow for a wide enough "solution space" (even if you have already an explanation).
Wow, that sounds exhausting!

I've been doing development work professionally since 2000. In that capacity, I've been self-employed and worked for a number of firms providing work-for-hire development services. I worked full time for one mid-sized company (1,000's of employees) and it was not for me. I am now self employed again working on a second startup. At this point, I have enough savings to continue my current lifestyle in perpetuity whether I ever make a penny from my startup or not.

I've never heard the term "leetcode grinding" before but I assume you mean completing programming puzzle type interview questions. These types of questions might be prevalent at certain kinds of companies but I can count on one hand the number of times they were asked to me. I haven't interviewed as a candidate since 2013, though the hiring process I put in place at that company is still being used. There are some easy weeder type questions, but the process is largely practical.

It took me too long to realize this, but my time is my most precious resource. Investing a lot of time to get hired by a certain company is not a great investment of time. Recruiters will happily brief you on a firm's hiring process and share as much with you as possible to help you prepare successful. No need to do it if you're not looking. The more important part is to keep up on the new tech. If you're not getting it where you work, it's time to move on. Move on to the right company, one that provides opportunities for growth and needs and appreciates the skills you bring to the table. Find a place that's not going to expect you to work extra hours all the time. I regret working lots of extra hours when I was in my 20's. It did not help my career in any way.

In your free time, if you want to work on a project - at least pick something that you enjoy! If it could make you some income, that's even better.
Show HN: AWS x-ray dataset slurper and visualizer
Gaddafi wasn't committing genocide, and there was no indication whatsoever that he was going to. I'm supposed to see this fig leaf get trotted out in 2023.
Line everyone up, reverse order, first class has their bags taken on first.
The Aunty Jack Show
Even better: the project would be OBE and I would be on a PIP
A system is what it does.

This system is extremely efficient at transferring wealth from Texans to corporations while killing them.
I’m a big fan of this Substack post.

The UFO craze was created by government nepotism and incompetent journalism

https://www.theintrinsicperspective.com/p/the-ufo-craze-was-...

> To sum up the story as far as I understand its convoluted depths: diehard paranormal believers scored 22 million in Defense spending via what looks like nepotism from Harry Reid by submitting a grant to do bland general “aerospace research” and being the “sole bidder” for the contract. They then reportedly used that grant, according to Lacatski himself, the head of the program, to study a myriad of paranormal phenomenon at Skinwalker Ranch including—you may have guessed it by now—dino-beavers. Viola! That’s how there was a “government-funded program to study UFOs.”
> Crackpots true believers also usually claim to be neutral on the subject and say that they're only interested in transparency. Then when you point out the glaring issues with the conspiracy

Have you considered that when you feel neutral about a subject your arguments will naturally align against both extremes of the discourse?

In HN where the majority of the sentiment is ridicule against the NHI hypothesis you will find me offering arguments in favor of releasing data and investigating the claims made by high-ranking officials.

In other websites when somebody defends that a blurry dot in the sky cannot possibly have mundane explanations you will find me defending a more prosaic interpretation.

My viewpoint is the same in both cases, but in one of them you will label me as a "crackpot" and in the other one you may see me as the voice of reason.

I hope this helps you understand the more nuanced takes on the UAP issue.
It would be in customers interest for organize products by category, but large AAA brands (Unilever, PepsiCo, Proctor Gamble) often bully shops into brand-designated floor space.

Large supermarkets (Carefour, Intermarche, Ahold Delhaize) bully back by designing their house brand products to look exactly like AAA brands. In France this had led to cat and mouse game changes to colour scheme and shape rebranding.

Shrinkflation stickers are yet another (pretty brilliant) move in the chess game. AAA brands spend fortunes in commercials to guide customers to their product in the supermarket only to have them change their mind last moment in favour of the lower priced freeloader copy-cat.
I presume you mean the shrinkflation is causing the package waste, not the supermarket signage of said shrinkinflation?
Bethesda has a game engine?

I thought their games were run by a 1000 year old abacus.
Which higher taxes? Which is higher cost of doing business?

Please be specific, otherwise it's just parroting the fake corporate propaganda of the supermarket chains.
> you have product managers

Ha

Ha ha

Hahahahaha
A "walkable" city has everything you need within walking distance. A "beautiful" city is devoid of modernist architectural monstrosities. A "lively" city is full of people.

I would argue there is no strong correlation here. A city can be walkable and ugly, lively and unwalkable, beautiful and unwalkable, beautiful but not lively...
bupstash supports it, however I didn't try it out

https://github.com/andrewchambers/bupstash/blob/master/doc/g...
To be fair, at least the Freemasons exist. It's mostly just a drinking club for men who want a reprieve from their wives. Claiming to be a Freemason might be a lie, but it's a mundane sort of claim to make.
Kali Yuga began 5,124 years ago and has 426,876 years left as of 2023 CE.[11][12][13] Kali Yuga will end in the year 428,899 CE.[14][b]

Not sure how long humans are supposed to be involved but that’s quite a long time!
Vim and Emacs have advanced navigation modes that can totally make up for lacking mouse support.

On the console, many use cases where you'd need copy&paste can be covered by autocompleters. For example branch names in version control. Someday I'll have to look into how to write my own...

Edit: with !, you can execute a shell command and watch its output without leaving Vim.
Supermarkets seem like an undeserving target for this scrutiny. Profit margins for grocery stores are only 1-3%, so they're hardly engaging in price gouging. The average U.S. household spends less than 10% of its monthly budget on groceries and other food.[0] This number is half of what it was in the middle of the 20th Century, and probably lower than any time in history.[1]

[0] https://www.valuepenguin.com/average-household-budget#food

[1] https://www.ers.usda.gov/amber-waves/2020/november/average-s...