skysight-inc/HackerNews huggingface dataset:
> Can you recommend any documentation on doing transactional DDL in production

MS SQL fellow here, rather than postgres, but the concepts should be the same. No docs I can immediately point you at, but some feeling for how I [don't] do things:

I still wouldn't perform most schema updates in live production, I'd wait for a maintenance window.

The key benefit from my PoV is that the changes are transactional so either all work or they rollback and you are back where you started instead of some mysterious mid-way point. Adding indexes is fine, as long as you have spare IO capacity for the process to chew if performed on a large table, and many index alterations can be done online too, and adding/modifying procs, views, and similar objects can be similarly undisruptive if properly wrapped in transactions (so active sessions never see a half updated set of parts), but I'd not make actual table changes “properly live” in production.

> I would expect major caveats in such a feature, like long lived table locks

In DBs with transactional DDL some table operations are practically lock-free or just happen so fast that they might as well be, such as (usually) adding a NULLable column or making an existing one NULLable, and some other operations are, despite being long-winded, sometimes possible to perform online (the new structure is added, then a final sync done for changes made while that happened, then switched over to, and the old parts cleaned up now the new are in use), but I'd never risk it unless I really really had to make the change ASAP and absolutely couldn't arrange a maintenance break in good time.

> For example concurrent index creation is harmless on its own, but combined with another fast but locking schema change

There should only ever be your process making schema changes, as the application and other users shouldn't be at all, so in theory you don't need to worry about two changes competing for locks or causing lock escalation like that. Several concurrent online index creations/modifications are fine, as long as you can afford the extra IO load that will impose, particularly if the objects being touched are on different storage (or otherwise have separate IO quotas) so the two index changes won't compete with each other for IO, but not table changes and similar: keep them to one at once, while nothing else is happening.
The maximum value in a postgres timestamp is `294276-12-31 23:59:59.999999`. Overflow means that `created_at + interval '90 days'` exceeds this value. This causes an error.
I'm not krastanov and everything is possible, but many publishers do not have such rules: https://en.wikipedia.org/wiki/List_of_academic_publishers_by...
limit 4 per address. I wonder if you put different unit numbers on the addresses (like 'apartment a" 'apartment b') it would let you order more. I'm not saying anyone should try that, but I'm curious if that would work.
On this topic, maybe someone can share the status of Galileo and the Russian and Chinese systems?
The welfare and employment insurance system in parts of Canada (ie: those parts with little or seasonal employment) are effectively UBI.
I find the most satisfying version of compatibilism one where an agent is mostly determined by 'state' (genes/experiences etc), but the subjective experience of expending mental effort (e.g. when overcoming an addiction) is the agent nudging the wave function collapse this way or that. Add in the ability to influence future 'states' and one has a model much more consistent with the subjective experience of making difficult choices.
"Acceptable" for whom? After AdBlock made their acceptable ads deal with Google, they whitelisted stuff like sexy girls and misinfo videos in the Recommended Videos side-list on YouTube. Fake Ublock is probably the same way.
Well, we're the opposite then: If I want to be over and done with google, it's super easy. And if I don't think they delivered value for what I pay, I can have the payment reverted by my CC. And try as they might, google will have trouble putting me in jail or killing me :)

So yes, I really love that they have no obligation for me.

And if Google/Microsoft/Facebook can do ID, there will certainly also be a Linux solution, and I'll use it :)
Not a surprise. The only surprise is that it didn't happen sooner. The mass realization is setting in that: most jobs suck and are not worth the pay. People can hustle, find ways to make money or living arrangements that does not require a traditional job, such as gig work or living with friends or family.
> What I find particularly remarkable is how...

...Bartosz always manages to over-deliver despite very high expectations.

Amazing!

Maybe we should give him an impossible task, like explaining different types of neural networks ;-)
In my state forming an LLC is an online filing that takes 5 minutes and costs almost nothing. Getting an IRS EIN is similar.

Now, to structure it properly with all the proper recordkeeping and documentation to ensure you really get the protection of an LLC when it matters, is another matter.
> I also suspect that game pass will make them focus on GAS games (service games) with microtransactions, optimised for profit instead of fun.

If they want to go that route, charging by the month isn't the way to do it. There's a reason exploitative mobile games are free at point of sale. I predict that MS stays the course of putting decent first and third party titles on Game Pass and chooses to raise prices rather than mandate that Game Pass games be more exploitative.
Can everyone put their half baked papers on arxiv? I see people on irc discussing about finding sponsors for their paper and what not and how this part not being trivial at all. I don't know the details about how the sponsoring works for arxiv but seems like it doesn't let everyone post their half papers, at the very least.
I’m Crypto Mining with Norton 360. How Bad CoUlD IT Be?
To be fair, we're using Aurora Serverless, so I'll have to dig deeper if we can use these kinds of hints. But thanks for the tip, this could be really useful!
Amazon avoids taxes with lobbyists.
Does the NAS fix bitflips?
Perhaps Not Everything Is Eugenics
Found the r/antiwork subreddit recently and it was quite illuminating to see the story from the actual workers' POV. People are sick, and their employers are asking them to come in anyway; the CDC move to 5-day quarantine is much less based in science than in "business needs".
This isn't quite true; the USPS was formed in 1971, out of the United States Post Office Department.[1] It didn't '[scale] from nothing'.

The USPS also enjoys a monopoly on mailbox deliveries, as well as price protections, in the form of a floor imposed on potential competitors. This doesn't seem particularly admirable.

[1] https://en.wikipedia.org/wiki/Postal_Reorganization_Act
"Blockchains are too complex for virtually everyone to understand, and so most people can't agree that they're a fair way to decide on things"

Almost nobody understands any of the complex systems in their life (e.g. banking, software) but it doesn't stop people trusting them. People have trust in these systems because they reliably produce the desired output not because they understand how they work.
somewhat related but for those outside the US, the governments candor with the postal service is nothing short of schizophrenia.

for the past 40 some years theyve worked to basically bankrupt the entire service under some misplaced neoliberal economic imperative that somehow private industry will delight in delivering an ikea catalogue to the furthest foetid reaches of alaskan frozen tundra, and that somehow the postal service as it exists currently is wrong and bad for not turning a 15% profit year over year, every year, until the end of years.

the last US president famously worked to remove and destroy postal sorting machines and even outright blocked funding entirely for the organization which singlehandedly created a crisis that still endures in 2022.

now somehow the governments forgotten its holy crusade against grandmas crypto puzzles and uncle ed's mail order cigars and decided screw it, they provide not only the worst service in the history of government services but surprise, now they provide a critical lynchpin of healthcare designed to detect and identify a global pandemic thats killed millions.

the irony is that somehow im sure a bureaucrat will champion this as an innovation, when for the past forever most americans have ordered cheap prescription drugs through the post from Canada and Mexico to treat a cornucopia of other diseases their healthcare system cant seem to without bankrupting them.
Most of them have been in power for decades, at certain point you have to start blaming the voters who pull the lever for more of the same.
What might also be happening is that people are forced to call sick due to being tested positive or a close contact of one, even though they aren't actually feeling sick.

We're seeing this here in Spain a lot now. A bit higher up in this thread someone mentioned not cancelling a birthday because all the guests had COVID anyway. But work environments are more strict.

I have a feeling this is what they meant by stating it that way, not implying that the workers aren't actually sick. A case of COVID is easily verified anyway.
Quoted from Lam Luu above (in case you don't have quora login):

Let’s do some accounting. A (quasi) modern browser must:

Parse 4 different languages: HTTP, HTML, javascript, and CSS

Encrypt and decrypt SSL (multiple versions of SSL, in fact).

Deal with network.

Act as first and most important defender of user’s security.

Deal with graphics (e.g. win32, Xorg, etc.)

Layout HTML and CSS.

Interpret Javascript.

Deal with local storage.

The above list is just the bare minimum. A regular modern browser also:

Has plug-in systems (more difficult to design than most people think).

Stores history and favorites. Syncs them across different devices, too.

Supports multiple tabs at the same time.
“Incognito” mode.

Stores passwords.

Provides GPS, webcam, and microphone support (HTML5).

Stores and recovers session in case of crashing.

Checks for upgrade and installs itself as needed.

Do all of the above fast fast fast.

I mean, any of the above items (in both list) would require at least tens of thousands of line of code to do right. Yes, even network programming. Effective and fault-tolerant handling of network is very very hard.

And this is just the bird-eye level of looking. Each item can be split into smaller items, each of which is major in their own right. For example, HTTP has multiple versions, and a web browser has to deal with as many as possible. Javascript is, well, no comment. HTML is a *** mess, to put it mildly. SSL has multiple versions, each of which has its own bugs to contend with.
And people in US make 50k-80k a month, too. But I'm not focusing on the top percentiles.
Many people can't just stay home from work unless they have an actual positive test.

For a lot of workplaces a home test isn't enough, you need a PCR test, but this can ideally help you know if you need to go to the trouble.
I'm so happy this is a real thing, but I'm also laughing that we only get this because people made fun of Jen Psaki.
NO WHERE TO HIDE: From the press... thought you were safe organising that lock down busting party at no. 10 over WhatsApp? Think again, journalists can intercept the plain text of your messages where you laugh at the deaths of proles and ask your old school mate Rupert to bring 10 bottles of bolly.

Not sure if they've thought this through.
Thanks for quoting this part of the paper. It's probably the most interesting part.

To add to what you said, though, I don't think of these phenomena in terms of random mutations. In other words, I don't think of these people as anomalies that do anomalous things; moreso, I think of it as following our growth imperative (i.e. the expected reward gradient), which, if we follow it long and hard enough, can lead to behaviors that appear anomalous.

One commenter below (kortex) really hit on what is at least my interpretation when he said "we are basically seeing an implementation detail come to light."
The annual steam sales still feel pretty deep.
Like someone below posted. Nice polite Republicans or republicans with a focus on diversity and inclusion.
The whole "double the power of AMD" meme is an oversimplification at best. It's all based on a 12900K running a heavy multi-core load with an increased power limit. This is the ultimate "I don't care about power efficiency" setup so it's kind of silly to knock it for drawing lots of power.

If you care about power efficiency you can drop the power limit and still be very competitive with AMD. The only reason you don't see Ryzen CPUs drawing the same power as a maxed out 12900K is because if you pumped that much power into a Ryzen CPU it would explode (at least without LN2 being involved).
In my experience, the usual trick is to do a few iterations of "linearize and solve the new convex problem". Sometimes, you can get super clever and use LM: https://sites.cs.ucsb.edu/~yfwang/courses/cs290i_mvg/pdf/LMA...

Look there in equation 6: That's the FIM being left multiplied when solving these types of problems. (under standard gauss-newton step, which is also common)

Another tidbit: If you apply matrix inversion lemma to eq 6, you can get the (Extended)Kalman Filter update steps. Somewhat related: https://robotics.stackexchange.com/questions/1180/informatio...
Safari and iOS users: Your browsing activity is being leaked in real time
yeah I meant healthcare.gov 1.0 round 2
Replace it with.. a Pixel.

https://grapheneos.org/releases

https://calyxos.org/install/
And if people believe that politicians are more about self-interest than representative interest and that it doesn't generally matter who is elected?
personally, I'm glad they won't be wasting time catering to two lowest-common-denominator systems. as someone who's only ever owned a PC, I've always lamented my high end (or, after a few years, low-grade (but still better than console)) hardware going to waste on games which haven't figured out how to make proper use of it. we've had affordable SSDs for nearly a fricken whole decade and essentially zero attempts to optimize their use until now, now that consoles have them. and there still aren't any directstorage games out. it's ridiculous the frontiers we've lost, the games we've gimped, due to low end hardware restraints. someday i hope they ditch the idea of the "xbox" as well, and consoles are lost to the sands of time. but for now, at least they're only wasting their time optimizing for one piece of trash, and at least that trash uses the same OS.
unpaywalled: https://archive.fo/fi6OX
IANAL (and in the EU) - I believe you're not allowed to republish/redistribute the modified copy of the book. That said, your software is still legal for an end user to use on any book they own.

Same thing here, if the modifications were happening on the server side and then sent to your browser that's probably not legal
On a statistical level, the vaccines don't have to be 100% effective, and they aren't. For every person you hear about being sick after 3 doses, there are probably 10 people that would have gotten it, but didn't. If there was 10x less healthcare capacity, you can see why that would be a larger problem.

That said, the vaccines do seem pretty focused on the 2019 variant of COVID-19. It's 2022 now, and that variant is dead. So we're definitely getting imperfect protection. (I got my 3rd dose anyway, of course. And I'm still treating the pandemic like a pandemic. I skipped holiday travel, I don't go out unless absolutely necessary, etc.)
This is about two years too late. If you are sick, you have Covid. Don’t go to the hospital or stand in line for test unless you are very sick.

Common sense goes a long a way.
And it's really nice that they're actually using the physical address for this instead of the given email address. Especially since some imbecile put my email address in when ordering her tests. I was concerned that I would not be able to order my own since my email was already used. But no, I was able to.

USPS gets points for practicality and execution, but is yet another service that performs zero email address verification and ends up with idiots that don't know their own email sending me their info.
Well yes but maybe it's not so expensive if I think about it as a small desktop (and with a touch screen!) that can fit in a pocket and can be carried over between places where I have everything I need to use it. Maybe it's not even so big anymore ("160.8 x 76.6 x 11.1 mm") and so heavy ("Approx. 215 g"). Those data are from the very bottom of https://www.pine64.org/pinephonepro/

If I think about it as a phone it's heavy like a stone (hopefully everybody agrees), too large (probably I'm almost alone on this one) and too expensive.
The company's willingness to tackle tooling to multiply the effectiveness of their employees was a key factor in their success:

This incredible growth rate could not be achieved by hiring an exponentially-growing number of design engineers. It was fulfilled by adopting new design methodologies and by introducing innovative design automation software at every processor generation. These methodologies and tools always applied principles of raising design abstraction, becoming increasingly precise in terms of circuit and parasitic modeling while simultaneously using ever-increasing levels of hierarchy, regularity, and automatic synthesis.

As a rule, whenever a task became too painful to perform using the old methods, a new method and associated tool were conceived for solving the problem. This way, tools and design practices were evolving, always addressing the most labor-intensive task at hand. Naturally, the evolution of tools occurred bottom-up, from layout tools to circuit, logic, and architecture. Typically, at each abstraction level the verification problem was most painful, hence it was addressed first. The synthesis problem at that level was addressed much later.
these query issues are most of the times not SQL Server problem, they are rather symptom of poor data model architecture, table design.

A lot of times I see in operational DB hot data gets mixed with warm and cold data, and your hot path query with ton of JOINs/subqueries will get rekt.

Proper redesign and rearchitecture helps to provide large buffer against these problems.

Also not everything should be inside SQL server, if you run large query every 5 seconds or something - probably consider using in-memory cache or denormalized model
I'd still rather own my games than rent it out, especially since I know that there's also a constant stream of games leaving Game Pass.

This month, Game Pass subscribers will lose access to Cyber Shadow (launched January 2021), Nowhere Prophet (launched July 2020), Prison Architect (launched January 2021) and Xeno Crisis (launched August 2020).

I'm also having trouble believing that Game Pass will remain $10 for long. At some point Microsoft will want to start recouping its investments and it's gonna start hiking prices. I personally got pretty tired of the constant Netflix price updates and I'd rather not do the same to my video game collection. I didn't actually have a gaming PC between January 2014 and March 2021, and it was actually pretty nice to install Steam and see all of the games that I bought between 2006 and 2014 still waiting for me in my library.
A lot of people love to dogpile on the USPS, but they're AWESOME and I'd happily give them a bigger slice of the funding pie to continue to improve.

I occasionally schedule package pickups for the next business day via the USPS website. No issues - package gets picked up by my mail carrier every single time. I occasionally go on vacation and pause my mail. No problem - all done online and delivered together when I get home. I've changed my address three times in the last decade - all done online and executed flawlessly. My day's mail gets scanned and sent to me digitally so I can decide if I need to go to the mailbox that day. It all just works pretty darn well.
Misdirection. There's plenty of information available about the situation in Xinjiang independent of the US DoS.
Where did the $800B Paycheck Protection Program money go?
USPS, despite seemingly negative public perception, has some very cool tech features. My favorite is informed delivery.
From what my pharmacist told me a fair bit of the kits can't detect omnicron reliably. The ones that do seem to have about a 7-10% failure rate. He suggested doing two or even 3 kits at once or space them out over a couple of hours to decrease the chance of a false negative.
It implies that companies are being denied their rightful labor
Zelle is supposed to be only a pay-your-friend system as it lacks chargeback capability and the like. Thus it's quite reasonable for it not to be involved in reporting business income--it's not supposed to be handling business income.
previous employer had a hush-hush-don't-talk-about-it deal with ABP. $1mi per month to allow a subset of our ads all over the internet. ...which all the tracking cookies included.

It was a great deal for everyone, but people who installed ABP.
Um. None?

I suppose you could argue that the Amiga equivalent of a batch file was a Rexx script?

But on PC-DOS 7, 7.01 or 7.1 you get a Rexx interpreter thrown in. :-)

https://liam-on-linux.livejournal.com/59703.html
Reading this, I had the uneasy feeling that we might be seeing a company chase a past that cannot be its future.
Ask HN: Why the $200 Overhead on Dell XPS Laptops with Linux?
I'm not complaining, I'm just genuinely curious. When speccing out an XPS 13 Developer Edition, switching the OS from Windows to Linux bumps the price up by $200. Is it subsidizing whatever work had to go into validating that the OS works as expected on that model?
I use an Apple TV signed into YouTube
AOL bought TW not the other way around.
Snoopers Charter - Very public toilet

https://www.youtube.com/watch?v=_-RSravgi_Y
Both sides are guilty of this.
Nyxt is using existing web engines, so it's not really a solution
The things you list need to be available for (at the longest) a month or two following my untimely demise.

The OP is talking about generational foolproof storage for photos which is both totally different and a slightly more convenient version of saddling your heirs with a closet full of photo albums and slide carousels.
One of the parties has been branded as the “Lockdown party” during covid. So long as there is a collective with the view that closing people’s businesses at any given time, indefinitely, without recourse, is acceptable - we can expect an endless stream of voters rushing to the other side of the aisle.
Speak to right wingers and you’ll find that many will tell you they weren’t convinced by some right wing youTuber. It’s often the policy or rhetoric of the left that drove them away.
A specific example in 2021, lockdown policies of the left may have had a far more profound impact on pushing people away than any random guest on Joe Rogan.
rather - you could sell a pair of glasses with yellow-tinted glass that transforms how any book looks. that's perfectly fine.
You've never heard of somebody calling out sick when they aren't actually sick?

The connotation of the headline is absolutely that workers are faking sick, even if the content of the article doesn't say that.
If you search for PCR tests for travel, you can probably find same day tests.

The place I use in Austin is $85 for a same day PCR test.
Since html supports gps, I wonder if there are any web based turn by turn nav apps? I did a quick search and didn't turn up anything current, but a deeper dive might yield something.