Are there professional degrees like that for, say, mathematics or physics?
An aside, the Actuarial profession's fellowship credentials (FSA/FCAS) are considered to be roughly equivalent in content to a professional doctorate (not counting a medical residency), and have a completely different format.
It's mostly exam based from pure self study, and aspiring actuaries typically work full time in the industry after passing the first 2-3 exams and finishing a bachelor's (which can be in any subject). Typical travel time from the first exam to the fellowship credential is 6-8 years, IIRC. Employers pay employees for some study time and for exam leave for each exam, with a bonus for each one passed.
I bring this all up because there are a lot of other ways for education to be structured outside of the BS -> MS -> PhD pathway, and there are ways for learning to be integrated with industry.
In a 2021 podcast interview[0], Dr. Hipp noted they've sold zero copies of the TH3 (extensive, proprietary) test suite in SQLite's history.
By the time TH3 was added in 2008, SQLite had gained a fair bit of traction across multiple industries. Though I totally agree that the comprehensive coverage is a leading reason why they've been so stable over the last ~20 years.
So indirectly, TH3 is why they (continue to) exist and (are able to) make money, but it isn't a direct line as one might assume.
They sell several niche things, for hopefully hundreds of thousands of dollars, to just a few people each. TH3 is just one instance of the general pattern.
For one, businesses and other entities also need Internet access. Cloud companies in particular needs a ton of addresses. That's gonna eat up a fair chunk of the remaining 50%.
Two, humanity is still growing, governments across the world are building new housing. That's gonna eat up another chunk.
Three, routing is hierarchical, and infrastructure organisations and ISPs are assigned blocks of addresses, not individual addresses. We can't just have a pool of free IP addresses and assign any address to any house in the world as needed. So even having 50% of IP addresses free wouldn't really be enough.
So in my mind, an IP addresses to household ratio of 0.5 means residential CGNAT is inevitable, even if we ignore legacy issues like individual universities and other institutions owning gigantic /8 or /16 ranges.
> In several Gallup measurements over the next three decades, including the most recent in 2019, the large majority of Black Americans have said the use of Black vs. African American doesn't matter to them.
Not caring is not acceptance. The term is literally racist both and origin. Unfortunately they were denied being called simply Americans due to historical reasons. African American is sadly also a misnomer given that there’s barely any connection to Africa for the people generally referred to as “black”.
Notice how everyone else is called by nationality or origin.
Black is absolutely accepted as an accepted adjective. Especially with the capital-b, Black is used to refer to the unique Black culture and heritage in the United States. Black history is one where people were taken from their nations or places of origin, transported to a foreign land, and put in bondage. As you say in your own comment, many black or African-American people (whichever label you prefer) have little connection to Africa; it wouldn't make sense to them to refer to them by nationality or origin, when Black culture is its own thing.
Don't get it twisted: I agree that the history of African-Americans in the US is one marred by slavery, segregation, racism, and the constant struggle to attain and retain equality. But out of that came something unique that many black people celebrate to this day.
> Next, we've got more than just two tables. The quote/paraphrase doesn't make it clear, but we've got two tables per thing. That means Accounts have an "account_thing" and an "account_data" table, Subreddits have a "subreddit_thing" and "subreddit_data" table, etc.
And the important lesson from that the k/v-like aspect of it. That the "schema" is horizontal (is that a thing?) and not column-based. But I actually only read it on their blog IIRC and never even got the full details - that there's still a third ID column. Thanks for the link.
https://en.wikipedia.org/wiki/Professional_degree#United_Sta...