Why is it that grafting a whole other query engine in is working, while attempts at bringing column storage (cstore) in, in a more integrated way, did not?
I think it comes down to every aspect of the DBMS being optimized differently. For instance, UDFs in DuckDB have vectors as input and output, while that would be confusing and unnecessary in PostgreSQL.
Even further back, before the hijacking spree of the 70s, when I was a kid I remember our local airport had no division between ground side and air side. You just got out of your car, walked to the gate, and they checked your boarding pass. This would be in the late 1970s, it was a remote city, so probably the transition to a "secure boarding area" was later than in the big cities.
For any book popular enough to have be put into GPT training data, you can get a summary without uploading it. The idea that these big, corporate models (their "intellectual property" if you will) have been trained on data they downloaded from ebook pirating sites... it's a real head shaker.
If these were scrappy start-ups looking to survive one can sort-of understand why they might bend the rules about copyright to train their models.
But we're talking about behemoth companies here, one of which deigns to make a pitch worth 7 Trillion dollars (10% of global GDP).
So... they're trying to rake in investment at levels that are unheard of in human history. Surpassing Apollo, the Manhattan project, the great pyramids of Egypt, the Great Wall of China, and anything else one might think of.
Testing and development by an actual operational airline, but running into regulation and certification issues. Could be a while even for this relatively narrow use case of seaplane flights of under an hour duration. Interesting update. https://harbourair.com/earth-day-eplane-update/
In terms of battery density, the fact that they have an operational, flyable aircraft, just stuffing batteries and an electric motor into a 60 year old air frame... pretty good and only going to get better!
You got me super interested in this book now. This is a pattern that I've kept seeing in my visits to lots of other cities in the US (especially cities in the South) and I always wondered why that was (aside from white flight and big auto, though I figured those weren't the _only_ reasons).
Honestly that would be fixed with expanded immigration. Look at places where the limited immigrants we have had in recent years primarily ended up and have changed the demography, like LA county or Miami-Dade county, and they don’t look like those midwestern or great plains cities. In fact there are almost no vacant parcels anywhere today, with majority latino populations now reflecting the recent waves of immigration.
LA has extremely dysfunctional housing policy. A wave of immigration does nothing but increase demand for housing and drive up prices on rather limited stock. It has not lead to an increase in housing stock or better commercial districts. Adding more people who don't really speak the language laws are written in doesn't change the laws that prevent you from building vibrant cities.
There is very little mixed use. Majority of the city is zoned single family. The only reason there are no parking minimums is because the California changed that law. It has nothing to do with expanded immigration. LA, despite the immigration, is in massive need of a zoning overhaul to build a vibrant city. Very little is walkable, it is very car-centric, and the zoning is the strong opposition to all of this.
There are at least 15 million illegals currently in the US. If they all left, there'd be atleast 3-4 million housing units freed up instantaneously, mostly in areas already with hard to get housing. It should be pretty obvious what that would do to housing prices.
No, I don't. Which is why I changed 15 million into 3-4M housing units...
The country is not full. But the places with jobs have more renters than rentable units.. which is why a 2br costs $3k a month.
You got 2 out of 3 points completely wrong, and your other was a pedantic point about wording. You should probably slow down and think before discussing this subject.
Immigrants have a lot of motivations. Jobs are one, but unless the immigrant was recruited for a specific job (which is common) it isn't primary. There are jobs everywhere, even in blighted cities.
Immigrants with no particular job in mind look for places where the cost of living is low: they tend to have much worse job prospects than normal, so a minimum wage job in a low cost of living area is better life than double minimum wage in a high cost of living area.
Immigrants often have poor English skills (or whatever the local language is). They often are used to food not common in the country. So if they can find a community of other immigrants that means people they can comfortably talk to, and also makes it more likely that someone can figure out the process of getting food they like into local stores.
That's not the cause at all. Extreme minority poverty and the potent bifurcation of incomes, education and wealth in the US is the cause.
Parking won't fix any of that realistically. You can push minority poverty to the suburbs, which for example is what France does, however it doesn't solve anything about the bombed out look, it merely redistributes the problem to somewhere else. You can gentrify the cities and push poor minorities to the suburbs and inverse how it's arranged in the US now, it will make the suburbs look bombed out - until you fix the minority poverty problem.
as usual, it’s probably a mixture of many things, and poverty is one, property prices is another, and there are certainly many many others.
we (engineering types) have this terrible habit of declaring that it is One Thing when in reality, complex problems are… complicated. shocking, i know. it isn’t a simple math problem with a one answer. human problems are significantly more chaotic and fractal.
i don’t want to imply that we shouldn’t look at these and add our ideas, only that id love to see us lessen our crutches of “You’re wrong, it’s X!” and recognize that others are probably correct as well.
The decision is really surprisingly multi-dimensional and, no, most people don't even scratch the surface of it. I thought this calculator was brilliant a decade ago, and my opinions hasn't changed.
PG radically underestimates the continuing importance of institutions in the modern world, which is understandable given how and with whom he spends his days. The public sector is huge and largely old fashioned heirarchical/institutional. What is the Fortune 500, if not a big list of institutions.
Read the CV of any new-minted corporate CEO almost without fail you'll find that before leaping into the C-suite they first laboured for 15 years in one big institution, building credibility and experience.
Big law firms, big financial firms, the military, academia, on and on it goes, large institutions within which career advancement depends on finding ones way through the institutional culture and comporting oneself to it, in greater and lesser ways.
The key irony is that the empowerment of ambitious individuals that he praises is only possible in an institutional framework that makes it possible. That just allows you to sell your homebrew computer, for example. And there are plenty of people who, once they have become powerful by climbing those ladders, would have no qualms about pulling them up. So pg's analysis works at an individual level, but it's not great guidance for what society should do.
> The key irony is that the empowerment of ambitious individuals that he praises is only possible in an institutional framework that makes it possible.
That's the pretty consistent blindspot I've found in people who strongly promote that view - they are almost always blind to the institutions that are required to support someone "being independent".
