skysight-inc/HackerNews huggingface dataset:
scalability is about things like "how many transactions per second you can handle", efficiency (in this context) is more about e.g. "how much is the cost of electricity used (and other such costs), divided by how many transactions".

You cannot increase number of transactions by just increasing the amount of electricity; it doesn't work that way.

If an intervention reduces the amount of electricity used without changing the amount of transactions that can happen, that increases the efficiency, but this does not thereby increase scalability.

So, something which reduces electricity use and hardware use, but doesn't substantially influence the amount of transactions that can go through, improves efficiency, but doesn't improve scalability.
The connection story is the primary reason that PHP + MySQL was a big thing. The PHP model of spinning up on every request depended on fast and lightweight connections to the DB. This was the one area that MySQL really excelled IMO.
> Yes Postgres can be slower out of the box

Is it though? I read this post earlier this year and it mirrors some similar tests I did back in 2020 when I was just checking basic perf between PostgreSQL / SQL Server / MySQL on my laptop.

https://itnext.io/benchmark-databases-in-docker-mysql-postgr...

> A simple conclusion: Postgres engine family is about twice as fast as MySQL engine family, except MariaDB.

Also:

> Postgres has worse connection handling

Is this addressed in PG14? Or is it still to come in PG15? I haven't kept up with the latest Postgres stuff but I thought they were fixing the connection stuff.
Let's not forget that they also use(d) actual tax avoidance schemes via Ireland, Luxembourg, etc. It's not just that they invested all their money back into their business.
This is some top tier hacking and reverse engineering, incredible stuff.
"A decentralised, trustless future perhaps?"

I think we need a DNS-like service that simply hold small encrypted blobs, just big enough to contain an IPv6 address.

When you "add" someone to your list of contacts, you are giving them the key to decrypt the blob that you update with your IP.(Complications ahoy here but this is the basic idea.)

That way, people can message your phone/computer-of-choice direct with whatever E2E protocol you want. No middleman.

Then you need an app layer built on that to manage messaging, video calls, group chats etc. But that app layer could be open and free. People often like some XML based protocol from the 2000s, but as long as it is secure - whatever.
git commit --amend --date="Wed Feb 16 14:00 2011 +0100" --no-edit

Certain proponents of Fossil and Mercurial will tell you that this is an advantage of those systems - They're fooling themselves, because you can make those edits, there's just not nice tooling for them.
"Former Covid-Zero proponents remain lower ranked in November, with Australia 33th (sic), New Zealand at No. 36 and Singapore 37th as they slowly reopen once shuttered borders but still lag the rest of the world on reigniting travel."

It is fascinating to see such a bias throughout the media towards international travel as such a highly-valued marker for people's welfare, when for most people their income does not allow for frequent international travel anyway.

Rich people's skiing trips are not worth more than poor people's grandparents.

Australia is now (at last) getting up to very high rates of vaccination and has had incredibly low total rates of Covid infection compared to the rest of the world. It's bizarre that it's not considered a success story in comparison to the countries with hundreds of thousands of deaths. Maybe my interpretation of "resilience" differs significantly from the authors'.
These companies are banned for refusing to share the data they collect with the government. Essentially the Chinese government is a competitor when comes to harvesting user data, not a privacy guard.
hopefully if enough people are unhappy about it && sees future in alternative (i.e. critical mass), we can collectively have a "phase transition".
> Ukraine actively developing its own independent history and claiming Kievan Rus for itself

I mean, it is not like all "real" Rus people packed their bags and left for Moscow at some moment in time and then some "unrelated" people set shop in Kyiv bringing funny not-a-true-language with them. Obviously, Ukrainians are direct descendants of people who inhabited that part of Rus.

> Where is the north/east dukedoms have existed without interruption, growing and expanding and ultimately getting unified into Moscow dukedom

The norther part of Rus escaped the Mongol devastation because if was unimportant backwater. There was nothing there to "interrupt".

> The Russian aristocrats direct descendants of the one of the early Kievan Rus Viking ruler - Rurik (whose descendants ruled the Rus and later the Moscow dukedom for centuries) - are still around.

Rurik is a legendary figure. Who are these people who are "still around" claiming to be Rurik bloodline? Sound funny as hell.
China modified the weather to create clear skies – study
I'll be honest... the words dont look convincing XD
Ah refactoring and rewrites. Always seem like such a great idea. And can destroy massive companies and projects. Was it Marc Andreessen who wrote that awesome post on how the rewrite of Netscape 6 seemed like a great idea but failed to consider all the little wisdoms built into the current version? It’s impossible to find now with all the noise around him.

Production software more than a few versions old is a living breathing thing that has had the hell beaten out of it by QA team and users and survived repeatedly by having passionate devs make it stronger. What it needs is love, not pedants.

Some of the most used and popular software in the world is fugly beyond belief but it works, is maintained and loved and continues to defy newcomers.
When I integrate third-party dependencies I often port the build system to the build system I'm using. For projects made with autotools, that means ignoring the configure script, hand-writing a "correct" version of config.h.in, and reading Makefile.am. I'm sure this practice would offend some people. In my experience, this practice is quite common in industry.

I've done this enough times that using Bison on Windows was no problem at all. In my case, I wasn't really interested in Bison itself, but I was using a different third-party dependency which itself depended on Bison.
Yup, and if you look at Quake 3 Arena as a good example, the game is free software but the assets or not, and as a result of that you wind up with games lime Open Arena and the dozens of other arena style games built from quake. It can still be that way.
typesetting? huh? edit : oh, they also procedurally produce typeset text in the original syntax from the code in coq
Honestly, the post feels a bit bitter.

> ...let me point out something that I've been saying both internally and externally for the last five years...

Life is short, don't get stuck in a job/relationship/situation/etc. you hate for half a decade. IMO the irony is that he's moving to the Chrome team, which has been an absolute shitshow. Woohoo, now you're going to work on fantastic ways of screwing up the web, inserting ads where we don't want them, tracking users against their will, and banning extensions on the Chrome store. Interesting technical challenges, indeed.
where do you get tor usage data? The only time I heard of it being used was when someone used tor on some university's wifi network to send a bomb threat. In that case it would be fairly easy to get the data, but if it's just a random guy using his home internet connection, can you get their ISP to cooperate? do they even keep such data around?
Open-source shield convert RaspberryPI to Brain-computer interface
https://github.com/Ildaron/EEGwithRaspberryPI
This project is the result of several years of work on the development of BCI. We believe that the easiest way to get started with biosignals is to use a shield. We will try to reveal the process of reading EEG signals as fully and clearly as possible.
This appears to be SmartOS[0] with lots of automation around it[1]. I for one think it's exciting. The screenshots on the main page and the architecture overview diagram[2] were helpful to get an idea of what this really is. Going through the user guide, I see some exciting features that add to the SmartOS platform. Most of the documentation references using the legacy illumos KVM port for the VMs, but there is actually a section of the documentation devoted to converting these to bhyve[3] - that's pretty cool.

[0] https://www.joyent.com/smartos

[1] https://danubecloud.org/

[2] https://docs.danubecloud.org/user-guide/esdc/overview.html

[3] https://docs.danubecloud.org/user-guide/howto/convert-kvm-to...
Yeah, it's like those new age loud devs on twitter. Slighting a serious software project with generic statements without any nuance is not cool.
Well he could answer with whatever his reasoning is that may or may not align with the things you suggest. People take that seriously, including me.

Or he could be rude and all I hear is "because I'm a hypocrite and not a great guy."

You can answer to justify your decisions without being a jerk. Even if it's a jerk trying to get a rise out of you who does it. If you're the honored guest speaker with everyone competing to kiss your wealthy, famous backside your jerkdom isn't really equivalent to a student asking what appears to be a stunningly obvious question that we don't even know how it was phrased.

But maybe I'm so naieve to have seen people respond in a reasonable way to aggressive questions from the floor often enough makes me think it's the right way to go.
I've always had a hard time reasoning about this.

On one-hand, it's a waste-stream, which means that finding a purpose for it means that the resources gone into the animals from which leather is made become more efficient.

On the other, if you believe that meat production at its current scale is bad for the environment, you're making it cheaper and subsidising it.

Then there's the impact of all the chemicals involved in leather tanning, which are not inconsequential.

I don't know what to think about leather in all honesty.
I created a syntax highlighting API earlier this year with some of the same features: https://torchlight.dev.

I've got a handful of paying users and a few hundred free. I'm happy to see syntax highlighting being pushed forward!

I'll definitely be following along, it's beautiful stuff.
Bob Dole and Jack Kemp (1996)
I think it’s ok to say one database is pretty good and another is not very good.
I work in Manhattan and commute to my office every day by subway. The story exaggerates a bit. In general it is and feels pretty safe during the day and during normal commuting hours. And banks tend to be VERY risk averse when it comes to safety and security.

However, the city just doesn't feel as safe as it did a few years ago. Part of this is that there are fewer people out and about than there used to be (because of Covid). But the trend predates the pandemic and I know a number of women, colleagues and otherwise, who have been followed or don't feel safe walking around alone at night anymore. There is definitely a problem, though I'm hopeful the new mayor will improve things.
I'm hyped about rivian and its ilk, but is the expectation that each company figures this out on their own, or is someone going to come over the top and make something universal all these EVs can ingest. Is swapping batteries the only thing to look forward to?
So who here has compile times going into days, ie whats the longest you have to wait for your code to compile?
Inconsolata is my programming font.

Also! This game was mentioned recently here to help the undecided or those looking for something new: https://www.codingfont.com/
You can probably achieve the same effect with the telegram API and an afternoon of coding.
Changing Company Culture Requires a Movement, Not a Mandate
I agree w/ you, but I'll also add that the premise that the evidence on diet is equivocal is pretty offbase. The evidence for EEN is pretty robust and held up over a couple dozen studies - see my other comment https://news.ycombinator.com/item?id=29453808#29456208
Most of that time is spent executing poorly crafted Oracle SQL queries drawing millions of rows into the analytical run-time for, sorting, aggregation, discarding, merging, and spliting tasks.

Depending on what goes on in between the lines of all that "sorting, aggregation, discarding, merging, and splitting" -- the core guts of what you're doing might quite easily done within Postgres.

And 81 million rows? That will fit on your laptop, easy (especially if many are discarded in the early stages of processing).

Or it perhaps might not fit so easily. But the basic point I'm trying to make here is: don't be afraid of simplicity. All other unknowns being equal, it's as good a starting point as any.
Naive question (I only use PostgreSQL and SQLite): is there any point using MySQL over MariaDB nowadays?
Software Engineer – Integrations (Remote)
Fried food and gambling chocolate coins
5 years ago, I built the same SMS gateway without using the AT command "Explicitly" [0], but by letting Kannel handle that for me. Thus, I had an endpoint generally usable. Kannel is still used by Mobile Network Operators in Africa.

[0]: https://hackernoon.com/build-an-sms-center-with-python-kanne...
I agree it reflects poorly on the organization, but the previous story on HN [1] mentioned that the malicious insider had scared the CEO into giving access by manufacturing some sort of security incident. Had this not happened, he would not have been able to pull it off IIRC.

That would also point to the CEO being too powerful when it comes to security, which is also a knock against the organization, but in a different way.

[1] https://news.ycombinator.com/item?id=29411775
To some extent, Postgres just follows the path that Oracle did to optimize performance. To see what Postgres needs to do next, just look at what Oracle had to do.

Postgres forks a listener process for each connection, which is relatively heavyweight. Oracle used to do that, but implemented a separate multi-threaded listener process for performance reasons. MySQL is multi-threaded from the beginning.
Speedrunners don't do that, for one. They don't generally go searching for diamonds, only grabbing them if it's in an easy location like a chest.
At least one VPN provider did just that

https://torrentfreak.com/private-internet-access-no-logging-...
Is there a good reason for that to not be the default when using a VPN? At the very least it should be easy to configure. I remember when I tried using a VPN on Ubuntu a bunch of years ago, I had to set up iptables rules even though the VPN connection could be configured through the network manager GUI.
Sure, and C++ isn't part of POSIX. So if you must stick to strictly POSIX utilities, you cannot use C++.
If Steinar is responsible for removing query_cache in 8.0 I'm glad he's leaving the MySQL team. Sure, MySQL is not the perfect database heck I'm willing to even say it's not good or efficient, but it is extremely well supported across toolchains and programming languages. It just works and it works pretty darn well for most applications. I've built several startups on top of it some even exited.
Leather itself is a driver of deforestation and not just a secondary byproduct.

https://www.stand.earth/publication/forest-conservation/amaz...
I dunno. I think the author makes some compelling points. Chief of which is the bad code quality. At least the bit about being unable to do full outer joins without a full rewrite. If the code base got so unwieldy that it made adding features tough all these years after it was started that’s a knock on both Oracle leadership and the project itself which I think is grounds to leave.
Spolsky wrote about Netscape, or at least that was how I originally encountered the story. https://www.joelonsoftware.com/2000/04/06/things-you-should-...
Plot twist: MySQL runs most of the web.
Wolfram Alpha feeds into Siri.
PragmataPro it is paid but it has been great.

https://fsd.it/shop/fonts/pragmatapro/
Archived: https://archive.ph/6jRfb
us-east-1 is made up from several availability zones, it is extremely unlikely to go offline for months. If a catastrophe of a scale to do that happened, some datacenters being offline wouldn't be the headline news.
His site would be loading waaay much faster if he was using MySQL even with HN traffic!

Joking aside - I see MySQL as an entry level database. There’s time and place for it - just like PHP.

Using pq or whatever is better doesn’t automatically make your product a success.
I don't think typed pipelines in a shell is a virtue. I think dumb bytes are ideal. Text manipulation can be laborious but it's always straightforward.
It's very awesome and provides educational value. Thanks for sharing.
It's not completely inconceivable that we will one day have therapeutic approaches in that line of reasoning, but it's also not quite that simple.

There is a critical period during infancy and early childhood when the immune system goes through a number of critical maturation processes. Afaik, once that's done there's no going back to a perfectly fresh slate.

After puberty, for example, your thymus (an important site for T cell maturation) begins shrinking and eventually all that remains of the organ is basically non-functional traces of scar tissue. That is not to say that T cell maturation doesn't occur afterwards, but it is a particularly striking example of the irreversible age-related change we can be talking about.

Another less-obvious example is that children born by cesarian have a different skin and gut flora through the rest of their lives than children who are born through the vaginal canal: the initial colonization of the skin with a different set of bacteria has some degree of permanence, though it is also somewhat plastic. Yet another example, children who are breastfed tend to have fewer food allergies or auto-immune diseases (atopy, generally) than children who are fed formula. Early conferral of passive immunity through maternal antibodies secreted in breast milk selects for different populations of gut microbes, and again there is some degree of permanence to this. In both cases, the differences are measurable throughout adulthood!
Cool, so this is a bit like MS-DOS?

With the splitting of applications into microservices all running in separate containers this does make a lot of sense again. Why have a full multiuser os running for each process. Will look into this more.
The author talks as if this isn't documented... https://www.google.com/intl/en/chrome/privacy/whitepaper.htm...

> Additionally, a subset of low entropy variations are included in network requests sent to Google. The combined state of these variations is non-identifying, since it is based on a 13-bit low entropy value (see above).
An end-to-end machine learning system should compress all the web into a good search engine soon.
Pretty surprised about the substantial difference between MariaDB and MySQL.
That’s correct, pictures of human remains are allowed. I was referring to the museum situation. Many religious Kohanim would avoid going to a mummy exhibit.
It was ultimately Bezos' API mandate that made this (and the cloud as we know it) happen:

> 1. All teams will henceforth expose their data and functionality through service interfaces.

>...

>5. All service interfaces, without exception, must be designed from the ground up to be externalizable. That is to say, the team must plan and design to be able to expose the interface to developers in the outside world. No exceptions.

>6. Anyone who doesn’t do this will be fired.

>7. Thank you; have a nice day!
Sharing a new copy isn't always easy though. That is why lens are a thing. Unfortunately lens are (last I checked) still not quite easy to grow.

The point is neither copying the whole structure nor diffs are as easy as mutex + inner mutation.
I think what you read out of the post and what he posted are different things.
Whats the price difference here? Doesn't seem worth the effort of hitting up a dealer unless you're picking up a couple other party platters.
That jq expression is surely more difficult to summon than a line-based grep pattern.
So the psychosomatic school is about to wake up again.
If we replace GNU coreutils[1] with this, could we finally call it "Linux" instead of "GNU/Linux"?

[1] And gcc with clang when bootstrapping
Office Code Pro
Recycled rubber and plastics aren't inherently safe.
They can contain lots of toxins.

I'd prefer just the shrooms, sans the crud.

https://www.theguardian.com/us-news/2019/jun/25/lawmakers-co...
As long as it isn't critical that your carrier's gateway is operating normally.

I have a customer that routinely emails through various carier's SMS gateways, and has reports several times a month that their messages aren't getting through and ask us to verify everything was handed off correctly. It always was handed off good, but their gateway is backlogged or broken for that half day or day.

This echos my direct experience years ago (before I made my own solution similar to this setup).
Why, as a user, would I want a page to begin playing a video as a result of scrolling?
This will probably sound completely insane, not least of all to people who prefer non-GNU coreutils, but I kinda hope that as uutils matures, some shells will offer an option to compile in the uutils rewrites as builtins. Especially for newer shells and shells that want to target Windows in a first-class way, that could be a real portability win.
The post office is increasingly losing business to low cost shippers and high margin business to same-day delivery tech startups. Not only that, their trucks are older than some drivers and the contract to replace them was filled with government pork.

You're never going to get innovation from people who are just trying to work a job for a wage and pension. That's why Amazon is disrupting everyone with their logistics network.
Is getting rid of GNU that important?
dict((key.strip(), val.strip()) for key, _, val in line.strip().partition(‘:’) for line in text.split(‘\n’) if line and line.strip())

Also who says we can’t have a universal parser for this format just like we have for JSON? Not everyone needs to write the one liner like above, just use the libtextformat.parse(text) or whatever we would call it.
I disagree; I'd say US jelly is much closer to UK jam than UK jelly. US jelly is basically just jam that's had the fruit solids strained out before setting.

Generally no artificial flavors or colors are used (I checked a cheap jar of grape jelly in my fridge before writing this). Also because it's made like jam, it uses pectin as its thickener. The reason grape jam doesn't exist across the pond is because it's made with Concord grapes, which were bred in the US and have large seeds that essentially require straining - hence jelly.

UK jelly (US Jello), on the other hand, is basically water with artificial flavor/color, sugar, and gelatin added and allowed to set. Quite different IMO.
Ask HN: What should know in 2022 an intelligent person?
Well you can already do whatever proprietary stuff you want with your own kernels if you're not putting them on devices that you sell to people. In practice, this means that Amazon, Google, etc likely have pretty fancy, totally unshared scheduler changes that are worth a significant amount of money. [0]

As for the risk of selling something with proprietary scheduler bits, the upshot is that this is well handled, because most of the interfaces are GPL-only. IANAL, but this [1] is probably an interesting read.

[0] btw, more often than not the reason that these things don't go upstream is because upstream says "no." Even if such changes are worth a lot of money to the business, it's not enough that the competitive advantage outweighs the maintenance cost of a forked scheduler

[1] https://lore.kernel.org/netdev/20210916032104.35822-1-alexei...
This shroom leather is so 2000 late. Call me when you've got E. coli and Lactobacillus leather ready.