skysight-inc/HackerNews huggingface dataset:
Let's address these one by one based on our experience (the part of the journey that I've been there at least as the implementation of the solution predates me but I live with it).

Migrations

Things slow down past 100 [...] No one wants friction in their deployment process, especially as we’re attempting to deploy daily or more frequently.

We have more than a thousand schemas per database shard. That is why I said you want things to run in parallel for speed, yes. However, we deploy way more than daily and it's not really an issue in that sense. Schema updates are not that frequent but you do of course need to take into account that you will have to make the schema updates as a separate PR, wait and check that it worked and then deploy your actual change making use of the changes in application code. Which honestly isn't much different from ensuring that your BE changes and FE changes are compatible or made in the right order so that you don't get failed requests because an old FE happens to call a new BE node or vice versa :shrug:

Database resources

"Need too large of an instance" r3.4xl

We seem to have m5.large. That has 2 virtual cores. Some r5.larges etc. Their r3.4xl has 16?! So not sure what kind of load pattern they have :shrug:

Client Memory Bloat

Ruby ActiveRecord something

Yeah well, we don't have that, so not sure what to say :shrug: Definitely not a generalized reason to say "can't do, is too complicated for scaling".

Record Identification

One major drawback of schemas as tenants is that your sequence generators will reside independently in each tenant.

I respectfully disagree. This is a great advantage because it means just because you get more and more tenants (some of which churn and you throw away their data anyway) your identifiers don't grow past limits as easily. In fact, in most cases the identifiers never run out of runway at all.

They complain about "what if you need to join this data somewhere else, then you need to also add the tenantId". Yeah, so? We also have a data warehouse we we do just that. Not a problem at all. We also have other services than our main one, which do use different database technologies where we use tenant as part of the key (for loads that actually benefit from being in a NoSQL type DB) and there we do not have sharding other than what the NoSQL database does by itself so to speak by dividing the keyspace.

That's it. End of article. Basically, we have none of these issues. They don't mention their actual scale. The only number they mention is the "hundreds of schemas". We have more than ten times that number per physical shard and have tens of thousands of tenants total. Again :shrug:
> Legally, Canada does have title to the land

is that under Canadian law?

Was this land openly sold | gifted to Canada or staked and claimed despite prior occupation?

I recognise the current state of affairs, etc. but this "Legally Canada owns the land" is at root just a way of saying "might makes right, we took it, it's ours now, and we will shoot or imprison anyone who says otherwise".
For my car (2024 GR Corolla) you can pull a fuse that goes to the telematics computer.

The car has a bad habit of calling the emergency hotline on a race track if you go over rumble strips (those painted red/white strips) because it shakes the car so violently I guess. Popping the fuse will make it stop happening.
> Most of all, it's necessary to apply to yourself.

Sure, that sounds like it could be a great principle. It's not what actually happens, though. The terms are loaded weapons, sticks to beat people over the head with; and discourse online trends weaponised. Cries of "censorship" are used as a battering ram to prise open an online space for invasion. When the only difference between an action that is morally acceptable and one that is not is the internal state of mind of the actor, with the case being tried in the court of public opinion, defense is all but impossible.

You did it yourself: "Censorship is when someone hides something for you, because they don't want you to see it." Someone. /They/. That's not a sentence about personal introspection. That's a statement tying a judgement to someone else's actions. He/she/it censors.
I would not feel that my privacy was any less threatened by a promise to discard my information after use.

The difference between the Internet and the guy at the newsstand is that you know the guy at the newsstand doesn't have a photographic memory, a replicated database in multiple availability zones, SLAs with IDV providers which are vague about retention policies, or marketing partners who have special offers just for you.
Or common areas in offices / apartment buildings.
For example, the building I live in has nice couches that look like they can take a lot of traffic.
I once looked at the brand tag - Ligne Roset. It’s not cheap, but at least does seem high quality.
Thank you for the details! I appreciate it.
Hey there! Looks like you may have missed the Nix/Generic and Nix/NixOS tabs at https://flox.dev/docs/install-flox/? Do those satisfy the side by side use case you’re talking about?

I think the best way to use fish at the moment is `FLOX_SHELL=zsh flox activate -- fish`. That doesn’t support aliases but should mostly work

Are you hoping to actually hack on the source or just trying to understand how to come up with a workaround? We error for any shell other than bash or zsh somewhere around https://github.com/flox/flox/blob/9e18a3ceaa185006bae95a4827...
If you want to take a crack at hacking on it I’d be more than happy to give more background!
running wears out your life support faster, same with jetpacking, that may be why you're running out. sometimes the rng is just not in your favour, though, so you may need to make a new save just to wind up on a different planet, but i've never had to do this more than once, imo it was worse closer to launch when you were dependent on plutonium for launch fuel
They've done that just fine for me by releasing... lame cars across the board. Most of their brands are shells of their former selves (especialllly Cadillac) and I can't remember the last time I saw a Chevy that I actually liked.
Good to see a competition for who can sell out to foreign investors first.

57% of Vancouver are renters, and 98.3% of property is mortgaged... a disaster waiting to happen.... lol =)
Texas sounds more and more like a great place to live in the US. Shame about the guns though.
This wasn’t (as far as I can tell) cheap finger jointed knotty wood. It was some furniture maker who thought “well, this part needs the grain one way and this other part needs the grain the other way, and I have a finger jointing machine, so I’ll finger joint it!” Even if they somehow found a shop that stocked sheets of finger jointed wood with a 90 degree grain rotation across the joint, it would have been an incredibly inefficient way to produce the part in question.

But they didn’t think very hard — see my other comment. I don’t think a single solid piece of hardwood would have performed a whole lot better. Either metal reinforcement or plywood or much more carefully considered joinery was needed.
and are there laws in the USA?
It's worth noting that it's still a religious thing as well. It's just that if you want to claim the governmental benefits that accrue to people the state considers married, well, you'll need the state to say you're married.

And unless you live in a world where words can be owned by an entity, nobody "stole" anything. Many marriages still get both the official paper (civil contract) and the sacrament. They mean a similar thing, and humans being humans means they use the same word.

(It's also not "usually the mayor", btw - that depends on the country. In Germany it's e.g usually the "Standesbeamte". A government official that does the job of a registrar. Mayors can only do the job if they've also been appointed to that role)
> You can't hide, but you can paint an incredibly inaccurate picture.

How do you reasonably do this? You would have to spend an incredible amount of effort creating fake data everywhere, without having any clue if what you're doing is even working. With new AI tools and technologies it's likely that someone with enough resources and motivation would be able to filter out the signal from the noise anyway.

I currently lean towards just minimizing my digital footprint, and carefully choosing the hardware and software I use. It still takes a lot of effort and sacrifice, and I don't expect this method to be foolproof, but at least it's reasonably manageable. At some point you do have to accept that absolute privacy is impossible in the modern world, even if you shun all technology.
Thanks! It sounds like Microsoft has changed a lot, for the better, since the old days. I'm glad to hear that. I might have to dig into this again!
I'm holding on to my coax for a few more years and then getting rid of all of it (electronics recycling, probably). I am so looking forward to never using coax again.
> I have no patience for "bigger than AI" apples to oranges comparisons. Wasm is orthogonal, has it's own features & distinctions. The direct run off comparison shirks both of their value.

Eh, fair. At the time I thought it was actually a fairly reasonably and pithy way to compare an hype-inflated technology that is being mindlessly applied to every possible target (while also, I concede, being thoughtfully, practically, and usefully applied in some cases, too), to an under-hyped and (AFAICT) almost unheard-of technology which seems on-track to provide an unshowy-but-significant optimization to basically any web technology ever, everywhere - but you're right that they are, indeed, trying to do different things, and comparing their impact is somewhat reductive. WASM is certainly not better than AI at the things that AI is trying to do.
Telematics should be disabled, preferably by way of hard cutting the modem chip's V-in. Call me a tinfoil hat lover, but when 23andme gets bought by an insurance company, the similarities with potential insurability issues are numerous when data is available to the other without a big, shining red opt-in.
Yeah. I don't know the exact numbers but having power out for 9 hours a year is not a freak event where I live in semi-rural New England and my impression is that it isn't for my colleagues in North Carolina either. Branches and trees come down on powerlines. I had a big tree come down in a windstorm a few months back. Lucky it didn't hit anything of mine or my neighbor or might have been a couple days.
> Between the no Car Play and Android Auto support in their new EVs.

Wait seriously? That's a wild choice.
Things get put in this group when the trials (generally on animals; you’re not going to get go ahead for trials of possible carcinogens on humans, generally) show inadequate evidence of carcinogenicity. Next group up is where there’s some, but ambiguous evidence on animals. For reference, agaratine is in group 3; red meat is in 2A, _two_ groups up, and most people are okay with eating that.

> warning labels on synthetic foods.

We’re talking about mushrooms here; mushrooms aren’t synthetic.
6000 apartments on 10 acres translates to a population density of 150k/km assuming there's just one person living in each.

With three people per apartment you could pack the city of Lyon into little more than a square kilometre.
The complaint is for:

• Violations of the Fair Credit Reporting Act (FCRA) due to the alleged improper sharing and reporting of plaintiffs' driving data without consent, impacting their ability to secure car insurance and leading to increased rates.

• Violations of the Florida Deceptive and Unfair Trade Practices Act, accusing the defendants of engaging in deceptive practices by sharing personal driving data without the knowledge or consent of the car owners.

• Invasions of privacy under Florida common law, arguing that the defendants' actions of tracking, collecting, and sharing personal driving data without consent intrude upon the plaintiffs' private lives and are offensive.
On coax/cable lines like Charter/Spectrum, the upload speed limit is due to protocol/DOCSIS limitations. Supposedly the new version of DOCSIS fixes this/allows for symmetrical service, and Spectrum has been rolling it out for a while now. Still waiting for it where I'm at...
For some reason YT keeps messing my link. Here is the correct one
https://milayb.notion.site/The-GFlowNet-Tutorial-95434ef0e2d...
"1000 Golden Fortune" or Jolly good luck ... something. I think that's fair enough - translation of idioms is very hard when the languages are so far apart.

There's quite a lot of history involved too so that I suspect there are routine translations between the various Chinese languages eg Cantonese and Mandarin to English which might be a bit behind the times but they still work despite sounding a bit twee nowadays to the relevant ears.

I say: "viva la difference".
> The EFF is politically ineffective and always has been for reasons I don't understand, and no one else seems to care.

Going by the EFF's latest published financials (2022), they took in $23 million vs $16.6 million in expenses. Vs literal billionaires and nation states. Some of the billionaires have more money than the nation states do. David, meet Goliath.

I care. I give them my money. They seem to do a better job at advancing these interests than anyone else. I'm more in awe of their attempts to take on issues of this magnitude given their meager resources than anything else.
The piece in question involved one of the starting wood sections being finger jointed with the grain running along the joint line. It failed where the bases of the fingers were tangent to the grain, which seemed pretty predictable to me just looking at the wood.
Scientists Uncover Unseen Culprit Behind Historical Vitamin D Deficiency
> Anyway cat is out of the bag, they won’t undo this feature they will pay a fine, offer an opt-out to 5% of users who take up the offer and in 10 years time everyone will assume their driving habits are being monitored by their insurance company.

So can't the plaintiffs just request an order compelling GM and others to remove the feature forever as part of the remedies?
I was talking about execution tracing, specifically, not tracing as a general concept. Tracing as a general concept just means a non-sampled time-series event stream and as commonly used these days generally also includes "stacking" to distinguish it from generic event streams or logging.

When you add a additional term like "execution" you are specializing the term to mean a event stream of "execution". In areas I am familiar with, that would normally mean a trace of the complete execution of the program down to the instruction-level so you can trace the precise "execution" of the program through the code.

What is described here would, in the terminology I am familiar with, be more like... a thread status and system event trace just applied to goroutines and the Go runtime, respectively, I guess? It does also include the stack trace at the time of the event, so it does have more data than that, but that is qualitatively different than a instruction execution trace that allows you to trace the exact sequence of execution of your program.
There is a jurisprudential concept called incorporation that SCOTUS largely adheres to borne from the 14th amendment, but for various reasons that’s actually a can of worms I don’t want to debate so instead I encourage you to learn more about it and make up your own mind.

> It didn’t create a “separation of church and state.”

That said, even if we were still under only the original Constitution plus the first 10 amendments, this statement would still be incorrect because State in this case refers to the Federal government which is a state in political philosophy terms which is what this phrase is using, but counterintuitively it’s not a State under US law. The Federal state is the operating one here, because the Constitution plus the first 10 amendments are laws for running the Federal government. On the subject of the States themselves, it says very very little, not nothing, just almost nothing. At least until you get to the doctrine of incorporation I mentioned above.

Most States also have their own form of separation of church and State under their own constitutions. They don’t tend to put it in terms of “separation of church and State” but that is what they do.
This is a great point. This is something already on our roadmap. We call it "prompt caching", but I realize writing this that it's a terrible name. Will update! (https://github.com/Skyvern-AI/Skyvern?tab=readme-ov-file#fea...)

Thank you for this feedback
The average US customer in 2022 averaged 5.5 hours of power disruptions[0]. So somewhere between 3-4 9s.

[0] https://www.eia.gov/todayinenergy/detail.php?id=61303
I mean, (the fictional nation of) Wakanda is depicted as a very isolationist country, and it's reasonable to expect that Christianity wouldn't have taken root if foreign missionaries were expelled throughout its history. Tokugawa-era Japan may be the closest comparison, where its isolationist policies resulted in fairly high retention of indigenous religions even through to modern times. Today less than 2% of Japan's population is Christian, whereas nearly 30% of South Koreans are Christian.
10 Years EDIS Raspberry Pi Colocation (and Chocolate)
I absolutely think your'e right - given permissive small business landscape
Hey, 3 nines ain’t too bad!

In 2023 our availability only had one nine. We had power ~96% of the year. And it wasn’t like it was a lot of hour long outages that added up or something. Longest was 8 days.

I am not in a dense urban area, but I am connected directly to a line connecting a couple of larger towns along a major highway, so we’re generally restored fairly quickly. During the 8 day outage, quite a few people in the major city nearby were actually still without power when mine was restored.

Maybe unsurprisingly, my internet has actually been vastly _more_ reliable.
The Miracle Weight-Loss Drug Is Also a Major Budgetary Threat
Thanks for the notes, I thought it would be a more detailed prompt :) Any reason why you choose Opus instead of other LLMs, was it because of the 200k context window?
Biden administration outlaws gdb

More news at 11
Most people don't need 100mbps. Netflix recommends 5mbps for HD and 25mpbs for UHD. As a country, let's make sure that everyone has the ability to watch netflix in HD on 5 TVs simultaneously in one home. Or to watch UHD on a single TV. But if there's a home out there that currently gets 50mbps but the infrastructure for 100mbps isn't in place, do we really want the government throwing money to solve that (non) problem?
Torricelli's Law for Fat Loss
The World of Crackers Has Lost a Giant (2023)
I guess what you described, though unpleasant sounding, fitted the Czech Republic’s history. Perhaps that’s why hilbert42 liked it.
Also not to mention that he has written many great textbooks on top of his research work. I would recommend anyone in an intro or second mostly-methods-based DE course to read his Ordinary Differential Equations. He doesn't entirely avoid useful methods (as I recall) but the approach was extremely different to what I had seen before, but so natural (pointing at geometry and topology, immediately discussing vector fields and a nice notation for flows in the beginning chapter).
My impression is that it depends what company you use. I don't really trust them but at the same time, there are a lot of other companies. All I can really say is that Optery will give you a free report with very minimal information and on a test they dug up far more information that I provided (the minimum).

Given that these companies, like Incogni and DeleteMe, are now sponsoring big time YouTubers I'd imagine they are soon going to get a much closer look. At minimum, they are making far more people aware of the situation and data out there. Even though many of the VPNs fall far short of the promises, it is setting a strong signal that people care about privacy and entering the public lexicon is the first step. I hope these can be a catalyst towards more state or federal privacy protection.
The commercial internet services with 4 or 5 9 SLAs have multiple redundant lines to the building to guarantee this and they charge handsomely for it. Otherwise a downed telephone pole or something will automatically bring the service down for a day or more.

BTW I run a serious network at home (Proxmox cluster, all enterprise gear, virtualized router with HA, UPS power) and only target 4 nines on the LAN. System updates and things like server crashes making the router failover to another node cause around 30 minutes worth of network downtime a year. If a core or floor switch fails it'll automatically take me over an hour to swap in a spare and configure it. I don't bother trying for that fifth nine and I'm a very demanding user.

Now if one of you have a consistent 5 nine home system I'd be curious to learn more about it. I'm guessing that would practically be a datacenter setup with CARP, dual switches, etc. - or you're just really really lucky.
Same here. I thought they sent that email out to incentivize me not to move to fiber. Turns out that FCC is the reason.
Not AFAIK. In MySQL, the only time “cluster” is used is to refer to NDB Cluster, which is a distributed DB product. Schema means a logical grouping of tables, the same (more or less) as Postgres.

As to schema itself, yes, it’s heavily overloaded, and you just to grok it from context. I can talk about a table’s schema or a DB’s schema, or as you mentioned, JSON schema. Although the latter is helped by simply not using JSON in a relational DB.

You must remember that SQL is an ancient language, and the relational model is even older. There are going to be oddities.
there really is no excuse for google not shutting these down very very quickly.
With all respect, 0-60 times is not the only reason why you buy a Porsche.

A Toyota Corolla probably ticks more boxes for the average person than any Porsche if cars are not your thing.
> Quality ain't cheap, and cheap ain't quality.

The problem here is, that expensive doesn't mean quality.

Buying a cheap ikea piece and replacing it in a few years might still be a better choice than overpaying for an expensive piece, that's the same quality as ikea, but with a different tag on it (both 'brand tag' and 'price tag').
Ah, so one with huge amounts of input from lobbyists.

It is ridiculous that nutrition labels are not forced to standardize on something like x/100 grams (even Freedom units would be acceptable). Plus a x/package. None of this 3/8 serving size nonsense.
For some context I find interesting, Taiwan was the first country in Asia to legalize same sex marriage using a similar method of courts declaring that it was illegal for same sex marriage to not be legal.

https://en.wikipedia.org/wiki/LGBT_rights_in_Taiwan
Siri excels at setting a hot dog done timer with my voice. That’s good, right?
> A PostgreSQL-compatible NewSQL like YugabyteDB should cost ~$15K/mo to match top-of-the-line RDS performance.

"to match" is doing a lot of work here. It's extremely unwise that a "compatible" database will have the same performance characteristics and no performance cliffs.

> So Figma spent ~25x ($400K/$15K)

They nearly got acquired for $20B, I don't think they give a hoot about 400K if it means keeping their stack the same and getting to keep all of the existing organizational knowledge about how to keep the thing online.
yeah they're doin it themselves
author highlight tweet thread: https://twitter.com/chipro/status/1768388213008445837
Despite distancing itself from politics, the topic is dominating Threads' trends
Off topic remark on the story drafting...

Sen̓áḵw

How is anyone supposed to pronounce this if they're not from Vancouver and haven't been exposed to indigenous culture there? You'd think they'd include an English approximation or a link to an audio recording. I don't think the average person has the time or energy to resolve 3 stacked diacriticals and a consonant juxtaposition.
But July 22 isn't for another four months.
Why the Matrix.org Homeserver Exists?