skysight-inc/HackerNews huggingface dataset:
Postgres is enough as long as you have a good multi-tenant setup e.g. a separate database per customer.

Ran a single postgres instance with multi-tenant SaaS product that crossed 4B records in a few tables, even with partitions and all the optimization in the world, it still hurts to have one massive database.

We still got bought tho, so I will agree its enough
FWIW I tracked down the company, it's ExodusPoint Capital Management. I think the story is true given by what I found with some basic googling.
> He explained that he’d spent Thursday evening with Zac at Riverwalk, along with Dave Sharma, a fifty-five-year-old friend who lived in the apartment. Sharma’s daughter, Dominique Sharma Clarke, who was in her early twenties, was also there.

For Dave Sharma's daughter to be named Dominique Sharma Clarke, it sounds like she was married...?

> I spoke to Ismailova recently, and she told me that she’d known Zac by yet another fictitious name, Thaimas, and that she’d believed him to be a young Kazakh who lived by himself.

A white Londoner is not capable of passing for a Kazakh.
Obligatory "depends". I'm aware of more than one company that uses postgres for huge datasets serving workflows with high throughput and importance.

It's truly a workhorse, it's comparatively a pleasure to work with, and its extensibility makes it useful in places some other DBs aren't suitable for.

But a relational DB isn't right for every workload.
In moments of crisis, immediate measures like physical tagging can be crucial. Yet, a broader challenge looms: our dependency on air conditioning. In Toronto's winter, the missed opportunity to design buildings that work with the climate, rather than defaulting to a universal AC solution, underscores the need for thoughtful asset management tailored to specific environments.
If the purpose is to do database specific things then pg cron can be useful for e.g. periodic vacuums. However for running application logic, maybe less so.
I don't understand the downvotes.
Exactly, with renewables the marginal cost is zero (once the system is installed producing a kWh is free, no fuel to pay for).

And when marginal cost is zero price goes to zero as well (unless there is scarcity or artificial scarcity thanks to a sort of monopoly or cartel)

This easy to understand: imagine that A and B have invested in capacity production. If A sells at x dollars, B will sells at x-0.1 dollars stealing the market to A. Etc... there is no bottom since the marginal cost is zero.
The Anti-Test Lunatics Have Been Proven Wrong
> Soon enough Facebook just becomes robots talking to robots..

Hasn't it been that for a while already?
There is a mathematical structure in the harmonics of a piano note. There is a different one in the harmonics of a sax note. Yes, it's not 100% structure, there is noise too.

This is why the "timbre" of a piano is different from the timbre of a sax, and why the same C note might fit in a song if it's played by a piano, but not in the same song if it's played by a sax.

If you take a higher level view, the mathematical structure of the notes (the chords, ...) needs to fit the mathematical structure of the harmonics of the instruments (the timbres) to get a pleasing sound. Put another way, the timbres of some pairings of instruments might clash on a particular sequence of notes, so you need to search for a different instrument pairing which is harmonious on that sequence.

And then you have synthesizers, which are very mathematical in the way the timbre is generated (oscillators, filters, ...), but this allows you to exactly fine tune the timbre so it "fits"
You don't get top pay & top job stability, that's life.

Job stability implies staying somewhere for a long period of time, and that's generally not how you maximize compensation.

Compensation maximizing career management usually involves moving every ~5 years or so, depending on industry.

But I'd rather make more money AND have more opportunities/experiences than to rely on the continued benevolence of my single long term employer.

When they start sorting spreadsheets by compensation for layoff purposes, you are already in the wrong place at the wrong time. Being paid less for years and years so that you are lower down the spreadsheet isn't a career strategy.
> This makes it sound like "some people will trade decency for items that they see as nicer". That is plain sinister.

I don't see how it's sinister at all to say that. I hate Windows, but I use it because I no longer have access to macOS, and nothing works on Linux. Am I sinister for "voting" for Windows even though it lacks decency? It is currently the least bad option for me, that is all. The value in having a working computer is greater than the value in perpetually stressing myself out over whether things are free and libre or not.

Ensuring the absolute purity of my personal supply chain is too much of a pathetic chore for me to want to care about. I really, really do not care if that nice Tesla I may buy in 10 years tracks my every move, receives random OTA updates, makes me pay a subscription fee to use the hardware that's already installed in the vehicle, and so on. What if I just wanted a nice EV and nobody else does it right?? What am I going to do, buy a Rivian instead?
Is anyone talking about being obstructionist for the sake of being obstructionist? This seems like a straw man.

The article raises concerns and calls for more studies.
Great work! Only feedback would be to make the drop-down search aware of the abbreviations for various countries. For example, St. Lucia rather than Saint Lucia, DPRK for North Korea, or even CAR rather than Central African Republic.
Prosthetic limbs need not look like real ones
Thanks - appreciate this
Maybe compared to C++ or even Go (yes, Go is very rudimentary with examples expecting you to synchronize goroutines by hand), but unlikely compared to C#. While both parallelism and concurrency are not as central to it as to Erlang, it is a much more approachable language and achieving either or both is trivial:

// Concurrency
using var http = new HttpClient();

var req1 = http.GetStringAsync("https://example.org/");
var req2 = http.GetStringAsync("https://news.ycombinator.com/");

Console.WriteLine(string.Join('\n', await req1, await req2));

// Parallelism
var user = Environment.GetFolderPath(
Environment.SpecialFolder.UserProfile);

var hashes = Directory
.EnumerateFiles(Path.Combine(user, "Downloads"))
.AsParallel()
.Select(path =>
{
using var file = File.OpenRead(path);
return Convert.ToHexString(SHA256.HashData(file));
})
.ToArray();

Console.WriteLine(string.Join('\n', hashes));

For distributed computing, there are Orleans and Akka.net frameworks which allow to achieve it at scale and garden variety of other, simpler frameworks for job scheduling.
Thank you for this post. I've been looking high and low for weeks trying to find a way to connect Looker to a GraphQL API unsuccessfully and apparently "PostgreSQL emulators" are called FDWs as I learned from this link. I had searched every term I could think of for how to simulate or proxy a SQL database into an API but calling it a foreign data wrapper would have never occurred to me.
Yeah humans are not too good at gracefully paradigm shifting. That is why in academia people usually wait for the old ones to die off before something truly new can be introduced. I'm not singling out academia, this is pretty much all over the the place.

This Star Trek just to show no matter how technologically advanced we are, we are still don't like go out side of our world view. Kind makes one thing should we all be focusing on technological advances, or how we can more gracefully shifting our paradigm, instead of waiting for old guys to die off.
Fixing iOS code-block font-size rendering quirk
I'm speaking way outside my area of expertise here, but I think a longer cook time wouldn't have significant impacts.

Longer cook times let connective tissue break down and is really helpful for fatty meats with lots of connective tissue.

Older chickens don't meat this criteria, they're not any more fatty than they're younger versions, and according to google, they get tough because the muscle fibers themselves get tougher, not any more numerous.
What Is Fractional Work?
> just over two lines of "9"s on a 1920px display

I love this unit of measurement.
I think the point is that systems that aren’t replaced easily shouldn’t be managed like they are, not … whatever it is you’re getting at here.
+/1 2 3 4 5

meaning

plus over 1 2 3 4 5

meaning

the plus reduction of 1 2 3 4 5

meaning

1+2+3+4+5

meaning

15

"over" (/) is a higher order function that takes the function "+" and applies it to "1 2 3 4 5"

over can also be used with *

*/1 2 3 4 5

meaning

the product reduction of 1 2 3 4 5

meaning

120

"/" as "over" comes from a mathematical notation by Ken Iverson: APL (A Programming Language) [0][1] which Ken names "reduction" (h/t mlochbaum)

> An operation (such as summation) which is applied to all components of a vector to produce a result of a simpler structure is called a reduction.

"/" is known as "insert" in J [2] and "over" in k dialects (like Goal)[3].

[0] https://en.wikipedia.org/wiki/APL_(programming_language)#Mat...

[1] https://www.softwarepreservation.org/projects/apl/Books/APRO...

[2] https://code.jsoftware.com/wiki/Vocabulary/slash

[3] https://k.miraheze.org/wiki/Primitives
Hmm, maybe this is what is cauing this problem with north pole? https://www.newsweek.com/earth-magnetic-north-pole-follows-u...
Cause, Effect, and the Structure of the Social World
It means 5 times the number of failures as you intentionally put in an extra unit so that one can be taken offline at any time for maintenance (which itself will keep the whole system more reliable), and if one fails the whole keeps up. The cost is only slightly more to do this when there are 5 smaller units. Those smaller units could be standard off the shelf units as well, so it could be cheaper than a large unit that isn't mad in as large a quantity - this is a consideration that needs to be made case by case)

Even if you cheap out and only install 4 units, odds are your failure doesn't happen on the hottest day of the year and so 3 can keep up just fine. It is only when you are unlikely that you need to shut anything down.
Nothing's perfect, but an email to the prof should alleviate some of that problem.
> It is a common argument that the cold war would have developed into a hot war otherwise, but we don't know that.

We can take a pretty good guess after WW1 and WW2. Especially considering what the USA and the Soviets thought of each other.
> Author writes and thinks in labels

Author engages in identity politics [1] which can be described as an exercise in labelling everything, attaching value statements - positive and negative - to those labels and thereby reducing every possible question to a simple calculation.

[1] a utopian socialist variant of 'scientific socialism' in which economic values have been replaced by social ones. Like its counterpart any attempt at implementing these ideas in the real world end up in failure since the inhabitants of the real world do not behave according to how the models predict they should - neither Homo Sovieticus nor Homo Arcopluvius exist in the real world.
For the 'stans, I remember TUTK (west to east), and that Turkmenistan is closest to Turkey.
> ALL advanced driver assistance systems available today require the human driver to be in control and fully engaged at all times

Maybe this is that he doesn't count anything where the driver does not have to be fully engaged and in control to be driver assistance? Because you can get a Mercedes Benz E-class with Drive Pilot today, which is rated at level three. Under some pretty restrictive conditions [1], you can legally read a book or play games.

[1] on the highway, below 40mph, only on specific roads in California and Nevada, daytime, good weather, etc: https://www.mbusa.com/en/owners/manuals/drive-pilot
It's not Mozilla's anymore
A bunch of people like to say it is fine they use the phone number because you can use your other methods as a backup if you use it. Yet I've read plenty of stories like this about google demanding everything they have on you.
That is specifically about AWS/RDS and relates to EBS/IOPS moreso than PostgreSQL. In fact their solution was to run the db but not as an RDS instance.

> The Solution: Roll your own: For us the solution was fairly simple: don’t use a managed database services and roll our own infrastructure on EC2.

I've done the same running PostgreSQL on EC2 instances with NVMe local raid storage. It's very fast, but then you're responsible for its uptime, updates, backups, etc. That setup was used for performance sensitive but less critical data.
Did you read the article? It’s about how expensive RDS is, not about how Postgres didn’t work.
Show HN: Move your PC windows with your neck
I liked it. Maybe you could add some facts about each country as a tip or after the answer was checked.

And the tiny countries such as the Vatican or the Pacific Island states could be zoomed in.
Maybe, but costs are not linear and the nonlinear goes different ways for different parts of the install. The costs of the smaller systems installed could be cheaper than just the large system not installed if the smaller systems are standard parts.
Using eBPF and XDP to Share Default DNS Port Between Multiple Resolvers
Learn how the NetBird team overcame the challenges of configuring DNS on Linux with eBPF and XDP to simplify DNS management in private WireGuard® networks.
We have computers and computer science because we can represent things mathematically. This is not insightful nor does it mean some software can automagially engooden things.
Wine requires no more installation than Electron. There are lots of "pirated" releases for macOS/Linux with a bundled copy of Wine (sometimes with third party patches or some libraries swapped out).
> In a recent press release, Shamji was identified as the chief executive of yet another company, DarkByte, which bills itself—in language so laden with jargon that it cannot be explicated—as having something to do with A.I. (Marc Sinden, whom the Shamjis hired at the Mermaid Theatre back in 1993, summarized Akbar’s modus operandi for me as “Big announcement, and then fuck all.”)

Incredibly, a quick search suggests that that very same company DarkByte has entered into a collaboration with Hewlett Packard Enterprise - https://www.prnewswire.com/news-releases/ai-meets-renewable-...

Give that a read.

> "We are delighted to collaborate with HPE to elevate this AI Cloud Service offering, further capitalizing on the growth of AI applications and building our next-generation digital infrastructure," says Akbar Shamji, CEO of DarkByte
In New Jersey they can’t kick you out for card counting.
> The rich person just saved $25 million that would have otherwise been taxed.

In this example, wouldn't it have cost this person $50 million dollars though?
>>The IT department decided they were done with their pets, moved everything to a big vSphere cluster, and backed it by a giant RAID-5 array. There was a disk failure, but that’s ok, RAID-5 can handle that.

Precisely why, when I was charged with setting up a 100 TB array for a law firm client at previous job, I went for RAID-6, even though it came with a tremendous write speed hit. It was mostly archived data that needed retention for a long period of time, so it wasn't bad for daily usage, and read speeds were great. Had the budget been greater, RAID 10 would've been my choice. (requisite reminder: RAID is not backup)

Not related, but they were hit with a million dollar ransomware attack (as in: the hacker group requested a million dollar payment), so that write speed limitation was not the bottleneck considering internet speed when restoring. Ahhh.... what a shitshow, the FBI got involved, and never worked for them again. I did warn them though: zero updates (disabled) and also disabled firewall on the host data server (windows) was a recipe for disaster. Within 3 days they got hit, and the boss had the temerity to imply I had something to do with it. Glad I'm not there anymore, but what a screwy opsec situation I thankfully no longer have to support.
Not really. Mars doesn't have an active magnetic core.

https://en.wikipedia.org/wiki/Magnetic_field_of_Mars
The issue here is not much the hardware, but the services that run on top of them.

I guess that many companies that use "current practices" have plenty of services that they don't even know about running on their clusters.

The main difference is that instead of the kind of issues that the link talks about, you have those services running year after year, using resources, for the joy of the cloud companies.

This happens even at Google [1]:

"There are several remarkable aspects to this story. One is that running a Bigtable was so inconsequential to Google’s scale that it took 2 years before anyone even noticed it, and even then, only because the version was old. "

[1] https://steve-yegge.medium.com/dear-google-cloud-your-deprec...
Also, AI may now be able to master your song, but if you don't make the guitar loud enough in the mixing stage, it will still sound strange...
People don't have independent mobility now. The majority of cars are not designed for off road and therefore can only go where there are streets. If public transportation provides the same access, then there is no loss of mobility.
You can watch some of the scam baiter channels on YT. The scammers are not targeting the very rich (though they would not mind getting in on that). Usually they target retired people who have lost some of their faculties.
"In court, Mann has argued he lost funding and research opportunities"

Seems like there is a strong potential for a chilling effect on scientific enquiry if publishing scientific papers leads to this kind of political vilification.
SpaceX Accused of Sexual Harassment as Fight with Ex-Employees Intensifies
> The California-based workers, who were fired in 2022 after circulating an open letter critical of Musk’s behavior, argue that the aerospace company’s actions violated the state’s Fair Employment and Housing Act. The law bans sex-based discrimination and retaliation against employees who raise concerns in the workplace. Their claims were detailed in filings with the California Civil Rights Department that were sent to SpaceX last month.
https://www.helminthictherapywiki.org/wiki/Main_Page
too many gotchas with LGPL to become a universal solutions. I wish that gtk was more stable across all platforms. I have a few on macos and some are less than ... stable... compared to on linux.
Telegram manages just fine, and looks the same on all platforms. I even ran it on FreeBSD for a few weeks with no issues. Their desktop client is developed pretty much by one person in C++ with Qt. It's really feature rich these days and actually works, unlike some of the things you've listed.
> To me, having two things that do something distinct is simpler

I completely agree. Inside the DB, it's hard to argue about performance benefits in a lot of situations. That said, debugging, testing, and developing are so much harder. I love to have a well written bit of code that I can integration test as well as mock up and use for unit tests with other components of my application. It's much trickier to do that in the DB. Sometimes it is a lot more performant, and that's a situation you may want to consider moving towards, but I would try to stay away from it for as long as the performance gain isn't huge.
Cloud environments have an elegant solution in the form of "spot" or "pre-emptible" instances: if your workload can tolerate interruptions because it's not time sensitive or not terribly important, you can get a pretty steep discount.
>The rich person donates the work to a museum, a non-profit. The donation gives them a $75 million tax write off. The rich person just saved $25 million that would have otherwise been taxed.

So you're asserting that rich people and appraisers and insurance companies and museums are all conspiring to commit tax fraud?
I read a meme yesterday about how you can just interject "it's all about finding that balance" into any meeting and people will just agree with you. I'm gonna say it here.

Sometimes a flexible tool fits the bill well. Sometimes a specialized tool does. It's all about finding that balance.

Thank you for coming to my TED talk.
I haven't had a chance to play with this, but it looks really cool (and is actively developed).
>They were up to no good and as a result two innocent people are dead.

What? The one was just stealing stuff from cars. Do you think anybody who did some minor crime deserves to be heavily punished for something unrelated a friend of them did?

Why would cops even engage in a dangerous car chase for a petty theft?
They should be held accountable, not the friend of a guy who killed a cyclist while fleeing from police.
I'm sure this has been asked and answered a zillion times but, in the tradition of Larry Wall, I'm lazy. Is the current differentiating factor of Google Fiber their willingness to go into an urban area and actually dig? The reason I ask is because I'm finding that, at least outside of the concrete downtowns, fiber to the premises from both incumbent and independent carriers is becoming very common, even in rural areas.
If they can accomplish the same things with more efficient public transportation, then that seems like it would be progress.
I know, that's why I wrote that the code looked like it was written by someone who wanted to write in C (as opposed to someone who wanted to write in C++, a different language).
The first monetization strategy was a SaaS 'Weave Cloud' providing monitoring and GitOps tools.

Then commercial versions of some OSS projects.

Probably consultancy was the biggest revenue source overall.
Also, making a backup copy of something you own is usually piracy[1]. In what universe is that theft?

[1] The act of making a backup is not in and of itself (as it's considered a fair use/exception in most [not all!] jurisdictions, even outside of US), but it often involves circumventing DRM, and that part is piracy.
For more about the flow algebra, see the companion paper:

https://dl.acm.org/doi/pdf/10.1145/322154.322167 (PDF)
Just some well meaning feedback.

Opening with the line "Umm where have you been the last decade?" feels like throwing insults, and not conducive to a positive enviroment to learn from one another. You probably didnt mean it that way but though Id point out this style.

Regarding the last decade,, the pertinent part of the comment you responded to is "do bulk video calls to parents/grandparent pretending to be the kids" - more referring to when these existing scams hit a higher level.
Could you write an OS based on PostgreSQL?:)
You're getting downvoted but this gave me a chuckle
The right answer is turn them all off - anything important is in a redundant data center. But odds are they don't have that.

If a redundant data center isn't an option, then you should put more into ensuring the system is resilient - fireproof room (if a server catches on fire it can't spread to the next - there are a lot of considerations here that I don't know about that you need to figure out), plenty of backup power, redundant HVAC, redundant connections to the internet - and you should brainstorm other things that I didn't think of.
Reminds me of when a customer complained a DB-heavy processing step took about 10x as long as expected, ie 10 minutes instead of 1.

We used on-prem DB server and fat clients. After a long debugging session I hadn't found anything. Gradping at straws I asked what kind of network they ran.

Turned out the clients all ran on laptops connected through Wi-Fi... so yeah 10x latency turned into 10x longer job.
China claims new speed record with vacuum-tube maglev train
We bought a 108-drive DAS some years ago, for a backup storage.

I needed to actively object the idea of a 108-wide RAID5 on that.

File systems get borked, RAID arrays can have multiple failures, admins can issue rm -rf in the wrong place.