“Just suck it up” coming from a person who doesn’t have to deal with the consequences has to be the least convincing take on the situation I’ve heard by far. So congrats on that.
To offer a perspective from someone in the field: I built my career as a craftsman. Not just my livelihood, but my family’s livelihood depended on this craft. And within a few short months, my value has plummeted. I’ve tried to adapt, but I will never be as good with the newer tools as I was with the old, just like most carriage makers didn’t become mechanics, to use your analogy. At the same time, the value of the work is just less. Weavers could work in fabric mills, but their pay would be less. Now, just like back then, I, my wife, and my two young children face a financial reforming just beyond the horizon. It will be painful for many. There is no amount of adaptation that is within grasp of all those affected.
I think the general problem with your argument is that you assume that, because there was a transition from horses to cars, many people successfully transitioned from one profession to the other. The reality is that they didn’t. Many suffered in anonymity.
Yeah, you and me both. Look at it on the long scale of history, change is a constant. Everything is impermanent. It’s not our choice to have this forced upon us, but it’s our choice as to how we adapt. Or not.
Personally, I’m choosing to be mentally flexible. I don’t want to embrace fear, fear is the mind killer.
You can probably do a whole lot of things to make money. I’ve only ever made software, so this is a real kick in the arse, but so be it. Time to pay attention and see where this story goes.
Yeah but horses to cars is insignificant compared to an AI that is going to swallow us all. We don't even have time to make new career choices because AI will catch up faster than we can think.
that's a reductio ad absurdum, the opposite of which would be adjusting our clocks by some seconds every day so the sun would always rise at 6:00:00 AM. both extremes are equally neat in some way and painfully inconvenient in many others.
While a thread-per-connection seems like an improvement, do you have any plans to allow query multiplexing over a single connection? That would be a huge improvement IMO.
Can you elaborate on the use case for query multiplexing? Is it so your client would only need to establish one connection with Postgres and then could run as many queries as it wanted?
Microsoft SQL Server has had a similar feature for a while -- Multiple Active Result Sets aka MARS. I don't have a good read on whether it actually helps any workloads. I've seen adapters that don't support it because of the extra complication.
Multiplexing would have a number of benefits. As you say, each client would only need a single connection regardless of the number of queries being sent. Resulting in:
On the client side, there is usually a local connection pool. When a burst of traffic comes in, the client needs to either wait for the pool to free up or establish a new connection, which adds latency. This latency hit wouldn’t occur with multiplexing.
With multiplexing, systems like pgbouncer would be unnecessary.
Also, even with a thread-per-connection, you can still quickly exhaust the servers resources when you have lots of connections because threads have a lot of overhead. Reducing the number of connections needed would greatly increase the number of clients that a database can serve.
> You may have heard that if you have an MTHFR variant, you should avoid folic acid and should take other types of folate, such as 5-MTHF. However, this is not true. People with an MTHFR gene variant can process all types of folate, including folic acid. Folic acid is the only type of folate shown to help prevent neural tube defects (NTDs).
Linking to a huge list of supplement guidelines, most of which cover labeling of nutrient content is not helpful. I did try to dig in, however, and found this:
> A qualified health claim is supported by less scientific evidence than an authorized health claim. FDA requires that qualified claims be accompanied by a disclaimer that explains the level of the scientific evidence supporting the relationship.
> Unlike authorized health claims, FDA does not issue regulations for qualified health claims.
That does seem to indicate supplement manufacturers have broad latitude to make claims provided they are disclosed as such.
To offer a perspective from someone in the field: I built my career as a craftsman. Not just my livelihood, but my family’s livelihood depended on this craft. And within a few short months, my value has plummeted. I’ve tried to adapt, but I will never be as good with the newer tools as I was with the old, just like most carriage makers didn’t become mechanics, to use your analogy. At the same time, the value of the work is just less. Weavers could work in fabric mills, but their pay would be less. Now, just like back then, I, my wife, and my two young children face a financial reforming just beyond the horizon. It will be painful for many. There is no amount of adaptation that is within grasp of all those affected.
I think the general problem with your argument is that you assume that, because there was a transition from horses to cars, many people successfully transitioned from one profession to the other. The reality is that they didn’t. Many suffered in anonymity.
reply