skysight-inc/HackerNews huggingface dataset:
Have you never been in an IKEA store? They sell a lot of solid wood.

I have IKEA furniture that's lasted for decades. It's value-optimized, but it's usually well designed; if you put it together properly, it will last.
horizontal sharding is such a foundational skillset in working with databases - it's essential to database architecture
What are current saturated markets?
No doubt he expects to be able to talk his way out of that.
They're not revealing anyone's names. Names are anonymous by default until you elect to share yours.
sigh, i never trusted these sites and it never achieved anything for me.
>All quirky fun and games until you realize you can't do high-paying jobs that requires consistent focus.

This is not a good understanding of ADHD. People with ADHD have hyperfocus tendencies, and this in fact can apply to their job while they ignore everything else.

That is to say extremely successful people might be that way BECAUSE of their ADHD, not in spite of it. A programmer who devotes the majority of their life to learning their craft, or an artist who spends all their attention on their next (or first) hit album.

But it's an even worse understanding of what high-paying jobs actually require.
I don't mean anything like artisan or hand-crafted. I mean well-built, out of quality materials. A good quality table, for instance, should last decades.
The "enterprise edition" is more than three times as expensive, while providing less stability than two of the regular products combined.

https://wiki.eth0.nl/index.php/LackRack
"No one" was a figure of speech. Yes there are always some people who want all of these things, but there have been countless polls done in all these states on topics like abortion and there is always a clear majority that is in favor of more sensible laws. One example is for exceptions for rape, incest and mother's health etc., which upwards of 85%+ of Republicans support. Yet the laws they enact don't reflect this, because these same people will not vote for moderates.
This seems to be an architecture Cloudflare is aiming to support with their SQLite service. One database per customer, each database located in the customer’s primary region.
> low-code fallacy

I like it that we have a name for this now. Let's keep calling it the "low-code fallacy", because I'm tired of explaining over and over the same idea that semicolons and for loops are not what makes programming hard.
With something like the RTA label, the site sends the header, so it can't be used to track you. The browser would then, upon seeing that header, call an OS-provided parental controls library which could e.g. do nothing (parental controls not enabled), block the content, or prompt the user to put in an unlock password. It's not a hard problem. TVs and video game consoles already have this kind of system.
In the OP they said they built their own sharding solution because it was risky to move to a different (newsql) solution and they already had sharding expertise with PG.

I think if starting from scratch it makes sense to look at these newsql DBs that are built to horizontally scale from the very beginning.
> because I understand HN folks can sometimes have difficulty with jokes.

if you had written something like "this advice must not be very helpful" rather than "this advice is not helpful" then it could have been more apparent that it was a joke. as it is, it looks like you're making unfounded assertions about mental illnesses that you don't have, which is incredibly disrespectful.
Holy cow. How are people downplaying something so revolutionary. Without those other tests SpaceX wouldn’t have done what it did today and they show progress each step. They are doing what nasa couldn’t (send stuff to space orders of magnitude cheaper) because they aren’t afraid to blow stuff up.
I am a Czech as well, and although I know exactly what you are talking about, I have found my own way towards Švejk lately. I am afraid (all of them awesome artists, but too much pushing the novel in the humour direction) Lada, Hrušínský, and Trnka are guilty a lot for the feeling which is prevalent now. Contrary to that, I was fascinated a lot by listening to M.C.Putna’s discussion of Švejk in https://www.mujrozhlas.cz/putnuv-jihocesky-literarni-mistopi... and by listening to the novel in audio, where he understands basically Švejk as “Kafka by other means”, and there is a lot to it.
My comment above is talking about the First Amendment. When Congress approved the First Amendment in 1789, New Hampshire, Connecticut, Massachusetts, and arguably South Carolina still had established state religions. The First Amendment simply prohibited Congress from messing with established state religions, or creating its own. It didn’t create a “separation of church and state.”

And there is no other amendment that created a “separation of church and state.” You won’t find anything like that phrase in the Constitution or its amendments.
The problem with used IKEA furniture is that it's all DIY-assembled. You don't really know if it was built properly.
in the same category of "Best of the Internet", my favorite are the sites that claim every person on the planet has an "arrest record found" and you can see those records for $49. Or if you're that person, pay us $99 to remove it.
By the publishers and owners of the games, as it is their legal right.

Not by Steam.
Show HN: BigQuery Cost Analyzer
We found it pretty hard to understand what was driving our BigQuery costs. It turns out that BigQuery provides a very granular view of your usage data in your information schema, so we were able to build some useful dashboards on top of that.

This seemed generally useful, so we wrapped the dashboard config into this free tool. It uses Google OAuth under the hood to connect to your BQ project and query your cost data.
I think you confused me with someone else. I'm saying this won't stop highly motivated teenage boys searching for adult material at all.
I think you are comparing apples and oranges here.

An individual contributor is typically given a tangible task (eg: deliver a product that does x in y months for a cost of z). There are several qualified people they could choose from to achieve this task, which drives down the cost. I worked for a company with 10,000 engineers. Oversimplifying for effect, but their skills are not unique.

A leader is given a far more intangible task (eg: gain 30% market share in z years for your division OR deliver 9M of product per day through 202X), and they are taking a huge risk. The team under them may not have the slightest clue how to do this. The interest rates can change. Currency fluctuates. They are paid to calmly chart a path through the chaos and deliver a result. At this level, there were about 60 of us, and the atmosphere gets rarer as you rise further in the ranks. They made absolutely certain we were kept super happy because we could create tangible value orders of magnitude above the average employee, and they REALLY did not want us working for a competitor.
Meta is using two Nvidia GPU clusters to train Llama 3
They've taken off because they have utility in information retrieval systems. They work for getting info into Google (Stanford) Knowledge Panels. I don't think it really goes any further than that. They are most useful to the few orgs that went from dominating NLP research to controlling it outright by convincing everyone scale is the only way forward and owning scale. Alternatives to word embeddings aren't even considered or discussed. They are assumed as a starting point for pretty much all work in NLP today even though they are as uninteresting today as they were when word2vec was published in 2013. They do not and will not work for language.
web-app.pax.com may be relevant to somebody's interests, here!
Is this (finally) a step towards a better way of automated frontend testing?

We're currently testing dom instead of vision.
All the Fallacies in the World
This is a major issue we have found while building https://www.unwraplife.co/.

We only list brands that are A) plastic-free and B) use non-toxic materials.

The list of large-ish brands that fit those specifications can be counted on one hand.

The industry is rife with corner cutting, greenwashing, and lack of disclosure.
Looking at Conservapedia from a 'liberal' standpoint is like looking at Wikipedia from a 'conservative' standpoint. Where a Conservapedia article like the one you mentioned - the Biblical flood being based on a recent 'global' flood event - is hard to take seriously by 'liberals' the same goes for Wikipedia articles like 'Non-binary gender' [1] to 'conservatives'. Both Conservapedia as well as Wikipedia treat highly contentious issues - the 'truth' of Bible stories and the 'truth' of gender ideology - as settled facts where in reality both are very much up for discussion.

[1] https://en.wikipedia.org/wiki/Non-binary_gender
Above your security context, no, but you can definitely WriteProcessMemory any other process that is in your same security context or lower (something similar holds for ptrace, although remember that SUID/SGID binaries are running not at a same security context)
But if you're densifying you're often knocking down those older homes. And so the only way to keep the older homes is to have newer homes being built somewhere - which fights against density.
Personally, I can't remember the last piece of marketing that tried to sell me "broadband" internet. They all say "high speed" internet.

Anyway, the 15/3mbps down/up I get in the Oregon countryside is indeed high speed compared to the 5/1mbps down/up I had smack in the middle of the Los Angeles suburbs.
Oh awesome, didn't see that. Great work :)
Kallax redesign thinned out outer walls of previous Expedite by 1cm so it looks closer to the thickness of the shelves and dividers. Also saves on a lot of material I imagine with the volumes involved. Also soften edges to be kid friendly and more scratch resistent finish. Cheaper, looks more aesthetically balanced IMO, and basically as statically strong holding stuff and doing furniture work. But thinner walls makes difficult/wobbly moving in larger 4x4, 5x5 variations.

I had to cinched a band of webbing around the outside of the shelf during move to prevent it from falling apart. Gluing all the dowels/joints/connection also helps with strength a lot, but who has time for that.
I'm with you -- I've assembled a lot of random stuff recently and I wish everyone had instructions half as good as IKEA's.
Because database, in Postgres terms, doesn’t mean physical node. It’s more akin to a VM than anything else. The term for an installation of Postgres is database cluster, which can contain N databases, each of which can contain M schemas.
I built one of these myself that I keep on my laptop. Never had real need to use it, but glad I have .

I keep meaning to do the same thing with Wikipedia. Although the Wikipedia dumps are so inscrutably named and seemingly undocumented it seems the organization does not want me to pursue the idea.
I assumed that was a mistake as light to medium is above medium to medium heavy etc, but I almost got make their numbers work though both light medium to heavy are off by 0.1.

Light: 46.5 h / week
Light to medium: 46.0 h / week
Medium to medium heavy: 46.6 h / week
Heavy: 48.8 h / week

Going back to table 7

Light 838/day
Light to medium 1063
Medium to medium heavy 1013
Heavy 1585

Light is thus 838 * 7 / 46.5 = 126 calories per hour = 2.10 /min *vs 2.2?*
Light to medium is thus 1063 * 7 / 46.0 = 161 calories per hour = 2.68 /min
Medium to medium heavy is thus 1013 * 7 / 46.6 = 152 calories per hour = 2.536 / min *vs 2.6?*
Heavy 1585 * 7 / 48.8 = 227 calories per hour = 3.79 /min

Though at this point I assume there are other math errors. Still 65 + 2.1 * 60 = 191 calories per hour for light work is more realistic than some of the other numbers you where tossing around. (191 - 120) * 8 = 568 calories per day delta.
Spanners interleaved tables seem like a similar solution, ie you interleave customer data so it all ends up on the same set of hosts for performance, while still having the ability to create transactions across customers.
Are they? Or are they just removed from sale?
> you discover that much of the cheapest stuff has the same flimsy glueboard, peeling laminate, and unstable joinery of the cheap stuff at Wal-mart.

I'm not going to argue too much with this, but I think this is underselling Ikea quite a bit.

Their cheap stuff is definitely made out of cheap materials. But I've found it to be well-engineered compared to walmart with reinforcements in critical places and general overall good quality control (doesn't come pre-scratched).

Walmart-level furniture on the other hand is often designed to look a certain way, with no consideration for how loads will be placed on it or long-term durability.
With how many 9's of availability, and at what latency?

Frontier is advertising 3 nines average network-wide availability for their new fiber network. Three nines is completely unacceptable, but our neighborhood barely got one nine last year.

Based on their current behavior, there's zero chance of them providing the bandwidths they're advertising for the new build out, even when the network is completely up and completely idle. Currently, if we try to sign up, they say we can get <<1 mbps (bits) theoretical. However, the internet coverage maps claim they provide broadband service to our address, so they must be claiming > 25Mbps to the FCC.
Just from the title, this sounds just like the whole "stores are closing because people are stealing too much" lie that the news was pushing just a year or so ago.

There should be laws stating that news corporations should have reasonable belief that the stories they are telling are based on factual data. Otherwise it's not news, it's make-believe and should be clearly identified as such.

For instance, "Cost Billions" and "(Potentially) Cost Billions" are two wildly separate things. I could intentionally "Potentially murder dozens of people" but I will actually only ever intentionally murder 0 people, but if you wanted people to think I was a mad man killing everything in sight, then all you would have to do is put () around Potentially and after the fact say that it was implied.
This article echoes something I've learned since we moved into a larger house this past summer: don't buy new furniture.†

We bought very nice leather couches a few years back (we have dogs, leather is the only option) and paid dearly for them. And they're great. (We looked carefully at the construction details before buying.)

This summer, we had some rooms we cared a lot about and others we just needed to fill in some blanks in, and we camped Facebook Marketplace looking for stuff. Pretty soon, even the living room was getting stuff we found on Facebook, at comparable levels of quality to our old "new" furniture, and at pennies on the dollar. People are simply always getting rid of good stuff, and there isn't a meaningful secondary market for it; they're just thrilled you're getting it out of their house and getting a couple bucks in the process.

I submit that you would end up with a better-furnished room faster, more easily, and at a fraction of the cost of high-end furniture retailers simply with Facebook Marketplace and TaskRabbit (for near-instant delivery).

† Leastways, not if you live in a major North American metro.
I think each test served exactly its purpose and it's incredible to see the rapid progress. Unclear why you believe the first two were not a success at all? Did you expect a novel vehicle like this would just work the first time?
And the evidence that sitting all day is good for you is?
Technical Decision Buy-In Framework
I think this is another case of mistaking a metaphor for actual reality. A company has no "health". This is a metaphor. If the people who constitute a company care whether or not it has customers, market share, "mind share", or about "having a company", then of course they should pursue the things that will make those goals happen. "having a company" is just one of many goals the people who make up the company might or might not have. The "one man shop" of someone close to retirement might be winding down and therefore not care about acquiring new customers. Maybe the people of the company would rather do something else and don't want to be bothered selling it -- fine, close it down and do something else. Serving the company itself is just serving Moloch, in my opinion. Always remind yourself that its just people.
Mr. Aecroid's Tables: Calculations and Customs in the Early Modern Countryside
Court Finds FCC Illegally Ignored 5G Health Risks, Used Outdated 1996 Standards
Takes one to know one!
Not the OP, but my family has a bunch of Danish teak furniture, as does my mom. The sofas are not super heavy. Cushions on a frame. You can see under it. Now, there's no bed inside. My mom's was re-upholstered once. Ours isn't old enough for that yet. We've re-upholstered the dining chairs a couple of times.

As for other pieces of furniture, e.g., cabinets and stuff, we bought them used from a place that combed estate sales in Denmark for furniture and sold it in the US. One attraction is that the old furniture is smaller, so it works in a smaller house.
Exactly why they wouldn’t be sovereign nations except by Canada’s niceness. You can only be sovereign by having some form of strong leverage, either resources, power, or international support.
I'm sure they already know. I see people that I've least expected are using VPN providers all the time. It's a lot easier today than it was when I was a teenager.

In my teenage days, VPN was only used for: corporate site-to-site, illegal activities. It all required a manual fragile setup. Today: download an app, launch that app.
Launching JWST on Starship would still be incredibly expensive because JWST is at the Lagrange point on the other side of the moon and 1 starship needs like 30 other starships to fuel it to get there
Pretty much this. That and I'm suspicious of the claim that the content in online pornography is worse than the selection available 20 years ago. "Online pornography is teaching our boys to be misogynists who are bad in bed. Yes, it's worse than the stuff you watched with your friends as a teen. Source? It's obvious to see (a.k.a. just trust me, bro)."
The difference is, the company can remove the game from the store, but not my games library. I can still continue to play them long after purchase.
I'm on a Zenfone 9 and longing for something smaller.
I'm a male on the conservative side and think this should all be banned-- most female Americans would disagree and call me puritanical for this. It's seen as part of the culture, a necessary sacrifice for freedom. Blaming only men doesn't help when there are women normalizing this stuff too.
"Unceded land" means that because 100+ years ago the British settled as they wanted without asking for permission, the land actually still belongs to indigenous people, and not to Canadians, not to the people who currently live on it.

"Unceded land" isn't exactly a legal concept, it's more of an activist slogan from people who want to see all public land (e.g. >90% of BC) privatized based on race, or want to hold the threat of that over our heads to get more special treatment based on race.

Legally, Canada does have title to the land, BUT that title is also encumbered by "aboriginal title" – a limited set of extra rights of indigenous people. For example, Canada can't prevent indigenous people from hunting, needs to meaningfully consult with them before approving resource extraction projects, etc.

All of this is very poorly defined – in one paragraph of the constitution, and a couple more in ancient royal proclamations – the rest is being interpreted and re-interpreted by the courts as they wish, largely following the general popculture trends.
If you leak any particular detail of personal life onto both Reddit and another web site or possibly email provider, they can be correlated to identify you. One the correlation between identities is made, you're outed.
As someone who runs a medialab at an art school it is fascinating how many people believe because they understood the general principle of a thing, it is therefore simple to just do it.

Many people seem to long for a magical technology that you could just pour over things and they will work out in the ways you wanted, while miraculously sensing the ways you didn't.

Those with the edge on the new tech will always be those who have a good understanding of it's limitations, because once a new thing comes around they immediately see the possibilities.
At altitude 22km superheavy was moving at 4310 kmh (34:18 in linked video) speed then dropped continually, at 34:45 in the video the icons show that 3 engines were lit, altitude was 1km and speed was 1300 kmh. At 34:49 you can see flames, speed continues to drop, then you see the sea rushing up, then it cuts
Nice post!

Yep, my process is similar. It goes...

- decompress (users|posts)
- split into batches of 10,000
- xsltproc the batch into sql statements
- pipe the batches of statements into sqlite in parallel using flocks for coordination

On my M1 Max it takes about 40 minutes for the whole network. Then I compress each database with brotli which takes about 5 hours.
* home owners associations

* an average american, in some states, can expect a tax rate at >50%

* the UK's official church only appoints atheist; it would be impolite to appoint someone who actually believed in god

* the UK hasnt banned porn; and despite some attempts, such extreme levels of intrusion would provoke a massive political backlash
I love IKEA instructions and construction. I honestly get a buzz from the puzzle. If I have to construct more than one of an item then I'll compete with myself on speed and efficiency.
Since this doesn't have documentation yet I piped the code through Claude 3 Opus and asked it to write some.

https://gist.github.com/simonw/9ff9a0ab8ab64e8aa8d160c4294c0...

You don't have a license on the code yet (weirdly Claude hallucinated MIT).

Notes on how I generated this in the comments on that Gist.
Yes:

> If we fail to detect attempts to manipulate our platform, including fraudulent activity within our advertising systems, Redditors and our advertisers could lose confidence in us, thereby damaging our reputation and deterring usage of our products and services.

To my reading, the rest of it describes it as a problem they need to keep solving, not one that's as broken as I understand it to be, as an outsider.
Are you not worried about bedbugs buying furniture off Facebook?
The newly developed housing isn’t meant to be the one that is cheap. What gets cheaper is the old housing people left behind to get into the new housing.

And if a city cannot build as fast as people flowing into the city, then there will never be “housing left behind”.
Given my experience as someone much younger in industry, I wonder if this is less about them struggling to catch up and more about how no one wants to on board new hires these days. It feels like confounding evidence when suggesting that older people struggle to learn but also job training has been on the decline for a decade or so.

I'm sure older people are more outspoken. I have to dance around to mention that documentation is inadequate. Someone with more experience and opportunities may be more blunt about it.
Yeah, I have a couple of Ikea chairs in a room that replaced (cheap) wicker that was falling apart. They haven't been used hard but, to me, they were pretty inexpensive, look good, and are very comfortable.

On the other hand, I bought a dresser with a lot of particle board and, no, it's by no means well made. But it's in a bedroom and it works. I could have spent 4x (or more) for a nicely made hardwood dresser from a good New England brand. But even getting it into the bedroom upstairs might have been a bit of an adventure.