skysight-inc/HackerNews huggingface dataset:
Partitioning has been supported for quite a while

https://www.postgresql.org/docs/current/ddl-partitioning.htm...

Logical replication...

https://www.postgresql.org/docs/current/logical-replication....

https://github.com/2ndQuadrant/pglogical?tab=readme-ov-file#...

https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatab...

In 'recent years' (in database support terms), PostgreSQL has gained autovacuum support.

https://www.enterprisedb.com/blog/postgresql-vacuum-and-anal...

This stack overflow question was insightful, in that most of the slowness many experience may be related to foreign key check lookups on unindexed columns that point to external keys. https://dba.stackexchange.com/questions/328884/why-is-the-de... Partitioned data and batches to spread out updates also appear to be current best practices https://www.dragonflydb.io/faq/postgres-delete-performance
Isn't that scarier, knowing that you're using a state-sanctioned exit node?
Dunno, seems wild to compare positive-but-still-unlikely ev things with straight up negative ev things like gambling.
...and the main reason people don't like comments is because they clutter up the code that gives them the truth of the matter. But yes, if they aren't in your face forcing you to look at them rather than the code, then they are slightly more likely to not be ignored when the code is changed.

It would be nice if they could be like footnotes, or boxed out-takes, that could be pushed to side notes. We have had the typography, even if it was just markdown with a rendered code reading mode.
You can broadcast FM radio over short distances by doing PWM over GPIO pins, so that does not suprise me!

I used this for switching radio controlled power outlets which had 433mhz receivers. [2]

[1] https://github.com/markondej/fm_transmitter?tab=readme-ov-fi...

[2] https://github.com/F5OEO/rpitx
MaxDB is already developed by SAP, weirdly enough, No relation tho

https://en.m.wikipedia.org/wiki/MaxDB
scoop generally installs to your local data, so most programs don't require admin access.
I just wrote a two line bash script to process some large csv files that Python/Pandas were taking far too long to process [0].

A lot of people (myself included) tend to underestimate the power of the heavily optimized GNU utilities and the ability to manipulate them with bash.

[0] It was two lines for readability. It could have easily been a single line.
That's exactly what Gerrit can do. When you push an x-b-c-d-e chain, these show up stacked in the UI, but you can easily cherry-pick b onto main (see that the CI passes, and the usual review), and rebase everything on top of that. If it is x, the bottom one, you can directly submit it and continue with the others.
Get an itinerant frequency -- $300, requires no coordination, and you can encrypt your comms.

One of the (ham) radio clubs that I'm a member of does this as a benefit for the group, and it's something that's nice to have: I can give my wife a radio and not worry about what she may or may not say if we have to take two separate cars when we road trip.

I've been meaning to do the process myself, but, I haven't had the time (and honestly, I'd want someone else to do the paperwork for me so I'm more likely to pay someone else to do it) recently, but, this might be the thing that prompts me to go and do it.

73 de K4IMW/WQZQ315
Or that hacker culture grew up and tries to weigh risks, since they lived through some shit.
Powershell on Windows is great because there’s a module for everything. I’d rather parse structured data.

Powershell on Linux isn’t worth is because I end up having to parse everything as text anyway, completely negating any benefit I can come up with. It doesn’t feel as natural as the *nix tools to me.
postgres have table partitions now, mariadb can however partition a table over multiple servers or shards using the engines like spider and connect, or proxies like maxscale and proxsql.
Local or remote, read your database manual about the fun and caveats that come from partitions.
Yes, the 80 series I drive (and am working on a EPA-illegal turbo 1HZ conversion for) was rated for 3500kg (7700lbs) everywhere except the US where it was only rated for 5000lbs (2260kg). And they make you (or the dealer back in the day) install an aftermarket tow bar instead of using the factory crossmember. Totally arbitrary nonsense, nothing to do with safety or mechanical capabilities.

The only saving grace here is (a) the EPA doesn't actually enforce rules against diesel swaps, and most states tolerate it--some will even give you a new VIN! (b) nobody (law enforcement) cares about GVWR unless you're operating commercially or doing something obviously unhinged.
Perhaps I misunderstand you but what if I'm working on a long series of changes across multiple days, and halfway through it the code doesn't build yet? The code won't pass CI because I'm not finished, but I want to commit my progress so I don't lose it if something goes wrong, and I can roll back if make mistakes.
That link isn't particularly convincing. As far as I can see, the only Postgres test performed on the hardware that the top MariaDB entries had was on a positively ancient Postgres version (9.2.1).
If proving this weren’t the issue the whole thing could have been wrapped up in a day. Good summary though.
Thanks for the comments. I’m well aware as I’m also a practicing radiologist! Some hospitals in Australia where I work do a good job of enforcing that radiology orders are sent with the appropriate metadata but I agree that is not the case around the world. Integration, as always, remains the hardest step.

PS genuinely appreciate the engagement and don’t see it as undermining.
There's also the comments that tell you why the code does something obviously stupid but needs to continue replicating this stupid behavior because something else depends on it behaving this way.
> WooCommerce should be filling the role of viable self host alternative to Shopify, but it falls short.

WooCommerce itself is mostly fine as a backend, but the themes for it (including the built-in/free ones) are mostly awful. Ugly layouts, huge bloated payloads, and checkouts that look so unprofessional most people will think they're fraudulent.

There are good themes out there but you'll be paying decent money for them.
Sure, but why link to the "D" page?
Can't edit any longer but just to clarify: That was on DuckDuckGo on Android, which is my one and only browser on mobile. So if something doesn't work with it, I disengage. Given this is HN, benefit of the doubt :)

Meaning now trying it on Desktop with Firefox and DuckDuckGo as an extension it works just fine.

On both, the FPS display is basically pegged at 60 FPS. So I think this is probably technologically awesome work for the performance side and just isn't compatible with some specific setup(s).
This is a textbook bad faith comment / attacking the person but not the subject of the argument. I’m just asking about others’ assessment of the benefits and risks. What do you think? Or do you think it’s just not worth considering?
If anything, that looks like solid evidence of the resiliency of GPL.
Probably means someone who thinks there's a moral obligation to follow a union-requested boycott.
You were due for a big win.
It "is" (that's how the creator originally thought about it) but it also isn't really prescribed as the only interpretation https://www.youtube.com/watch?v=Jib2AmRb_rk&t=50s

Though I'll also note the "lite" crowd often interpret the "L" as double duty/shared (like the "m" in "dramedy" isn't necessarily interpreted as solely part of "drama" or "comedy").
I noticed that when you select pick random numbers, it only picks it once. Can we run the simulation where it picks new numbers every time? I would love to see if that would make an impact on the odds.
I keep saying this over and over but, Gerrit basically does that. :) You can see the relationships between any two patches on Gerrit, and more importantly, Gerrit shows you each patch individually. So you can see in a series A -> B -> C that yeah, B is small, let's go ahead and get that in.

Part of this is that UX has some really smart ideas like the "Attention Set". The attention set is basically "Which people need to take the next step?" Like a turn-based game. So, if you just did a review, you're not in the attention set for that patch anymore -- the author is.

That means Gerrit puts it down at the bottom of your queue in the UX. And what's at the top of the queue? Things where you are in the attention set! So it naturally groups things this way.

I didn't get into all the other really annoying papercuts with GitHub's UX, but even the pull request listing is worse than the alternatives. How do you know what state anything is in? You don't, you have to go read the whole thing.
Are you pretty sure about that?

Linux 0.99 was released to the world with TCP/IP stack back in Sept 1992 whereas at the time Windows NT was still in the development since 3.1 version with the adopted Spider TCP/IP stack was only released in July 1993 [1],[2].

There's a time window (pun intended) between the public released of the Linux kernel with working TCP/IP and the official public released of Windows NT. If Microsoft wanted to adopt Linux TCP/IP (I doubt they wanted to do that since it's still at the time pre stable 1.0) theoretically they can because it will be just copy paste exercise as they most probably did with Spider TCP/IP stack. But what I am saying is that even if they wanted to it will be illegal because by the stroke of Linus' genius Linux kernel was relicensed to GPL in the exact same year 0.99 kernel was released.

[1] Linux kernel version history:

https://en.wikipedia.org/wiki/Linux_kernel_version_history

[2] Windows NT:

https://en.wikipedia.org/wiki/Windows_NT
There is one thing I miss on Gerrit when you push a stack of commits: A central place to talk about the whole of the stack, not just individual commits. This "big picture", but still technical stuff, too often happens in the issue tracker. But where to place it, I have no idea. This stack is just too ephemeral and and can be completely different on the next push.
See also: https://news.ycombinator.com/item?id=32139827

This is really just publication spam.
> I suppose my issue stems from my perception of the seemingly lack of serious investigation on their law enforcement side.

That's my experience too from actually having my house raided. I had two kids in bed at the time, and the police didn't even know to expect kids in the house (both kids were over 11 years old, had birth certificates, had lived in that house all their lives and attend local schools and are darn fine students).

They didn't know. It's mind boggling to me that they could get a raid warrant without having done even the most basic (below even basic) investigation.

My opinion of police investigative competence took a 99% hit as a result.

It's a lesson my kids won't forget either.
A big part of why Clinton won in the media while her rivals didn't is because she was the least left-leaning Democrat president candidate since, well, Clinton. Clinton's' vast corporate support is because she would lean to the right of the average American on most economic issues and was business as usual, in vast opposition to her rival.

Compare for example media treatment of Sanders or even Warren when he opposed her and you can see that it's not her leftist tendencies that made her win in the media.
He's in a union and pays attention to this stuff. That's all it meant.
The long term is, until proven otherwise, not a talking point.

A "niche audience" is inflating the point.
Correct.

This said, if the incentives are tailored a bit too much (i.e. there is clearly only one company that satisfies the prerequisites), it could be challenged as state aid. You still need someone to start the challenge though - either a competing company or a Commissioner.
You'd have to work at the RIAA to think that piracy and bioweapons are comparable.

I don't know how much releasing this model is a delta on safety, but we certainly need to do a better job of vetting who can order viruses; my understanding is there's very little restrictions right now. This will become more important as models get more capable.
Didn't you get an offer letter? I assume it stated the terms of your employment like the work expected, the consideration (compensation) to be provided, and, most likely, the at-will nature of the agreement.

In this case "secure a contract" means terms that are somehow perceived as more favorable than employment-at-will.
Your argument would benefit from some examples of amazing research. Most of what I see is better implementations of the status quo. While I am excited about CHERI and similar efforts, they're hardly revolutionary.
Rust has unsafe, too, because the implementers know that they need to work in a messy world. S3 has options for globally blocking public access, there are warnings and tools which continuously audit for things like cross-account access, etc. but they have a lot of customers who legitimately need things like that so there has to be a way to do it, just as Rust allows you to say “I know what I’m doing, call libc!”
Did the US have any magazines that could compete with Canada's "The Transactor"?
See: https://en.wikipedia.org/wiki/The_Transactor
> These are high paid tech workers in a high paid industry. How are they being exploited

Nail on the head. I'd be grateful to do their job for half of what they make (and I could probably do it just as well). There are thousands of highly qualified tech workers currently working as Starbucks baristas who feel the same way. I don't know exactly what the legal options NYT has to handle this are, but I imagine the union isn't in a strong place to negotiate beyond "it would be the most inconvenient time to replace us right now."
> Processing power

What are you doing with your apple watch that requires additional processing power?

> screen size and quality

Many watches have larger screens, Apple screen quality is among the best - true.

> active monitoring quality

I mean... garmin beats apple hands down, so do other brands.

> AOD

Almost every modern smart watch has this?

> Lower battery life literally doesn't matter if you can charge it in the time it takes you to get ready in the morning.

'Having lower RAM literally doesn't matter if you can just use less.'

> It has zero impact on usability.

Cool story bro.
> depending on which side of the Israel/Palestine conflict you are on

Here's the thing: I am not on either side of that conflict, or likely any other conflict you could use as an example. There are atrocities committed by both sides. There are victims on both sides. You could argue over who committed the worse atrocities or over who is the biggest victim until your face turns blue, it isn't going to end the cycle of violence as long as there are people facilitating that violence.

And no, I am not naive. I know there are people out there who care nothing about causes beyond their own self interest and who care nothing about their victims. I realize that these people are impossible to combat without the innocent coming in harms way. Yet the moment we fail to be ashamed of the harm we cause in the name of the cause, the moment we fail to acknowledge who is being harmed in the name of the cause, is the moment we become no better than them.
Well you got 2 out of 3 of those correct.
...as difficult as discovering new medicines, you mean?

Chemistry and molecular biology are fiendishly complicated fields, far more complex and less predictable than what general (and most of the non-biochem STEM majors) imagine them to be.

How do I know? I thought of one brilliant startup idea that would solve so many of the world's problems if only we used computers to simulate biological systems.

Result: https://xkcd.com/1831/

Reference materials:

https://www.amazon.ca/Molecular-Biology-Cell-Loose-Version/d...

I strongly recommend to treat it as introductory-level text on the same level as "K&R - C Programming Language". Yes, all 1464 pages of it.

https://www.amazon.ca/Fundamentals-Systems-Biology-Synthetic...

On the same level as above text, but with more math.

https://www.amazon.com/Introduction-Computational-Chemistry-...

That or any other book on computational chemistry will give you an understanding why it is difficult to design anything of value in biological systems. ML can only help so much.

Also check out this page for entire field scope:

https://en.wikipedia.org/wiki/Omics
Let’s not forget that the target market for game consoles outside of Nintendo is ~40 year olds.

I think there’s a good reason Sony is themselves shifting toward the PC.
Heed the warning on that first link. The pattern can really hurt your eyes.
That's gonna take time. Contact info and rate in profile.
Code that breaks is much more likely and damaging than comments that are out of date. In my life I've never had a case where the bad outweighed the good for comments.
> Compare for example media treatment of Sanders or even Warren when he opposed her and you can see that it's not her leftist tendencies that made her win in the media.

Respectfully I don’t accept your premise here. You’re saying she was center of left? But still “left”, as it were? And you agree the media crowned her king months before the election?

So the media ordained her the winner. You do agree or you do not?
He already used that! https://en.wikipedia.org/wiki/MaxDB
I have elderly and technically unsophisticated parents and family members. I tell them to assume all emails, messages, phone calls come from scammers unless they initiated the conversation.

If they get a message or call from someone claiming to represent their bank, the IRS, “tech support,” etc. I tell them to hang up, look up the phone number, and call back.

I understand the motivation behind the screening tool you describe, but at this point I think ignoring and blocking all unsolicited communication makes more sense.
Fascinating in that our GE microwave (still actively sold) has an undisclosed feature that if you lift the door, when fully closed, by no more than a few mm, the microwave will start. I noticed this when cleaning the enclosure with a rag and my hand ever so slightly lifted up the door from the bottom. I can see how a consumer could wedge a kitchen utensil or plate accidentally under the microwave causing it to start and continue to run. Zero logic protection.
This is great. Thank you! Ritani is the one I was looking for.
Redox.

Probably worth doing regardless of brouhaha or not. Different design choices, etc!
I'd be quite happy with seeing the three jobs in the article as three separate PRs. Fixing a bug and adding a feature are two jobs that, as I think we all agree, need to be tracked individually - so work on them individually.

> As well, sometimes CI won't pass on one of the stages meaning it can't be a separate PR

Could you give an example of this? Not sure what you mean.
Dropping the ring in the middle of the ocean is new though right
> It certainly makes me question whether or not I want to ever expand into the EU.

Well, you are free to ignore one of the biggest markets on the planet. I'm sure your European competitors will enjoy filling your niche.
I don't mean in the judicial sense, I mean in terms of how they are treated by law enforcement.
Logical replication does exist in pgsql, which is great. What it still lacks however (and I am sure they will very quickly catch up on) is the user facing process of being able to fix or sync a broken node without a rebuild. I'm also pretty sure pgsql logical replication is single threaded?
Things like pg_rewind are layered on fixes that other database users don't have to depend on or learn. Except Oracle (because it's a mess).
There is actually a relation, it used to be called SAP DB and MySQL AB renamed it to MaxDB.
(current Googler)

One of my coworkers got assigned Sanjay on one of her CLs recently and she had no idea who he was. I had the pleasure of working with Sanjay as his intern at SRC the summer before he joined Google, and he taught be a lot of cool tricks related to compiler development. Both Sanjay and Jeff Dean are PhDs with PL focuses.
No, it's a very small piece for what you'd need to make bioweapons.
And just visually, GitHub wastes so much vertical space, so even trying to place what belong to which patchset becomes hard.
Enforcing the laws unequally is unjust, and is the reason why having overbroad, overcomplicated and widely violated but rarely enforced laws is a mechanism of injustice.

But large corporations typically have lawyers and then comply with the law, even while doing something you might not think they ought to be doing. Conniving of a way to get them anyway, instead of changing the law so it does what you intend, is either that same injustice (selective prosecution for a different offense than the thing that made you dislike them) or the overt despotism of making up the rules as you go along. There is really very little daylight between the two of them except that people seem a lot more inclined to go along with the first one when it gets them the outcome they want.
> In the end, this really comes down to whether you value freedom or state protection more

If we're talking about the decision to actually run an exit node, I disagree with this breakdown of the ethics. I can value freedom more than state protection in the abstract while at the same time not feeling that helping support freedom in Russia and China and Iran is worth the cost of simultaneously helping to shield perpetrators of violence closer to home.

In most people's ethical frameworks choosing not to run a Tor node does not make me culpable for the actions of a state suppressing its people, but choosing to run one does make me at least somewhat complicit in shielding the perp of a bomb threat.
We've seen how this ends because mathematicians have been sharing Mathematica notebooks forever. It's not pretty.

Like you I see the appeal, but they're a usability nightmare beyond a few lines. Part of the problem, I think, is that you can't really incrementally improve them. Who wants to refactor a notebook and deal with all the cell dependency breakage?

So they start off okay and then slowly become terrible until they're either irreplaceable or too terrible to work with and a new one is started.
The water is tap water. If it's toxic, then the source of the tap water should be punished for poisoning the civilian population, not the users of the tap water.

The fuel is just natural gas. Again, if it contains toxins such as mercury, then the source of the fuel should be punished because they are certainly delivering it to civilian users for cooking, or to industrial users elsewhere.

Why are we not hearing about those other linked pollution incidents!?

Or, is it that the pollution doesn't exist -- it is merely a sufficiently plausible fiction that is being used as an excuse to halt their progress?

Because from where I sit, it definitely looks like the latter.

Before you respond: Please very specifically explain why it is perfectly logical that there is no uproar about the "poisons" in cooking gas or the town water supply, but SpaceX's use of the same justifies stopping multi-billion dollar projects. But... not in any way investigating where the "poisons" might have come from. Just stopping SpaceX. No other actions. Just that.
That's what I thought too, but how can there be such significant shadows? Wouldn't the shadows of any wavelength they are sending be near nothing?