dumps.wikimedia.org/enwiki/latest/enwiki-latest-category.sql.gz contains a list of categories. It only contains the categories and some counts, but it doesn't contain the subcategories and pages under each category, so it is a bit pointless.
The schema is listed at: www.mediawiki.org/wiki/Manual:Category_table
The SQL first defines the table:followed by a few humongous inserts:which we can see at: en.wikipedia.org/wiki/Category:Computer_storage_devices
CREATE TABLE `category` (
`cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cat_title` varbinary(255) NOT NULL DEFAULT '',
`cat_pages` int(11) NOT NULL DEFAULT 0,
`cat_subcats` int(11) NOT NULL DEFAULT 0,
`cat_files` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`cat_id`),
UNIQUE KEY `cat_title` (`cat_title`),
KEY `cat_pages` (`cat_pages`)
) ENGINE=InnoDB AUTO_INCREMENT=249228235 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED;INSERT INTO `category` VALUES (2,'Unprintworthy_redirects',1597224,20,0),(3,'Computer_storage_devices',88,11,0)Se see that en.wikipedia.org/wiki/Category:Computer_storage_devices_by_companyso it contains only categories.
- en.wikipedia.org/wiki/Category:Computer_storage_devices is a subcategory of that category and it appears in that file.
- en.wikipedia.org/wiki/Acronis_Secure_Zone is a page of the category, and it does not appear
We can check this with:and it shows:There doesn't seem to be any interlink between the categories, only page and subcategory counts therefore.
sed -s 's/),/\n/g' enwiki-latest-category.sql | grep Computer_storage_devices(3,'Computer_storage_devices',88,11,0
(521773,'Computer_storage_devices_by_company',6,6,0
A spectrum auction is a process used by governments or regulatory authorities to allocate radio frequency spectrum rights to telecommunications companies and wireless service providers. Radio frequency spectrum is a limited natural resource that enables wireless communication, including mobile phone services, radio and television broadcasting, and various forms of wireless data transmission.
This is true. The level of competition in university entry exams in Asia in insane in the early 21st century compared to the West.
This is actually both good and bad. Good because it selects some very good exam passers. And bad because it selects some very good exam passers.
The Australian Capital Territory (ACT) is known for several notable attractions, landmarks, and features. Here are some of the "big things" associated with the ACT: 1. **Canberra**: As the capital city of Australia, Canberra is central to the country's politics and culture. It is home to important national institutions.
Described at: arxiv.org/pdf/2107.12475.pdf where a relation to the Busy beaver scale is proven, and the intuitive relation to the Collatz conjecture described. Perhaps more directly: demonstrations.wolfram.com/CollatzSequenceComputedByATuringMachine/
Western Australia is known for several "big things" that are popular tourist attractions. These oversized structures often celebrate local culture, industry, or natural features. Here are some of the notable "big things" in Western Australia: 1. **The Big Banana** - Located in Coffs Harbour, although not technically in Western Australia, it is a well-known example of the "big things" phenomenon found throughout Australia.
In New South Wales (NSW), Australia, "big things" typically refer to large, often quirky monuments or structures that are tourist attractions throughout the state. Here are some notable examples: 1. **The Big Banana** - Located in Coffs Harbour, it's one of the first and most famous big things in Australia. It features a banana-themed park with attractions like water slides and a mini-golf course.
William Compston could refer to a specific individual, but it appears that there isn't a widely recognized or notable figure by that name in public records, literature, or media up to October 2023. It’s possible that he could be a private individual, a fictional character, or someone emerging in prominence after my last update.
"Big things" in Victoria, Australia, refer to a collection of oversized structures or sculptures that are often found along highways and in tourist areas. These quirky attractions are usually named after local industries, landmarks, or wildlife, and they serve as fun photo opportunities for travelers.
Martin Pope is a prominent figure in the field of solid-state physics and material science. He is particularly known for his contributions to the understanding of organic semiconductors and the development of organic electronic devices, such as organic light-emitting diodes (OLEDs) and organic solar cells. His research has significantly advanced the field and helped in the commercialization of various organic electronic technologies.
Australian astrophysicists are scientists who study the properties and interactions of celestial bodies and the universe as a whole, based in Australia. They work in various fields within astrophysics, including cosmology, stellar dynamics, planetary science, and observational astronomy. These researchers often collaborate with international teams and contribute to large-scale projects, such as those involving space telescopes, observatories, and theoretical research.
Pinned article: ourbigbook/introduction-to-the-ourbigbook-project
Welcome to the OurBigBook Project! Our goal is to create the perfect publishing platform for STEM subjects, and get university-level students to write the best free STEM tutorials ever.
Everyone is welcome to create an account and play with the site: ourbigbook.com/go/register. We belive that students themselves can write amazing tutorials, but teachers are welcome too. You can write about anything you want, it doesn't have to be STEM or even educational. Silly test content is very welcome and you won't be penalized in any way. Just keep it legal!
Intro to OurBigBook
. Source. We have two killer features:
- topics: topics group articles by different users with the same title, e.g. here is the topic for the "Fundamental Theorem of Calculus" ourbigbook.com/go/topic/fundamental-theorem-of-calculusArticles of different users are sorted by upvote within each article page. This feature is a bit like:
- a Wikipedia where each user can have their own version of each article
- a Q&A website like Stack Overflow, where multiple people can give their views on a given topic, and the best ones are sorted by upvote. Except you don't need to wait for someone to ask first, and any topic goes, no matter how narrow or broad
This feature makes it possible for readers to find better explanations of any topic created by other writers. And it allows writers to create an explanation in a place that readers might actually find it.
Figure 1. Screenshot of the "Derivative" topic page. View it live at: ourbigbook.com/go/topic/derivativeVideo 2. OurBigBook Web topics demo. Source. - local editing: you can store all your personal knowledge base content locally in a plaintext markup format that can be edited locally and published either:This way you can be sure that even if OurBigBook.com were to go down one day (which we have no plans to do as it is quite cheap to host!), your content will still be perfectly readable as a static site.
- to OurBigBook.com to get awesome multi-user features like topics and likes
- as HTML files to a static website, which you can host yourself for free on many external providers like GitHub Pages, and remain in full control
Figure 2. You can publish local OurBigBook lightweight markup files to either OurBigBook.com or as a static website.
Figure 3. Visual Studio Code extension installation.
Figure 5. . You can also edit articles on the Web editor without installing anything locally. Video 3. Edit locally and publish demo. Source. This shows editing OurBigBook Markup and publishing it using the Visual Studio Code extension. 
- Infinitely deep tables of contents:
All our software is open source and hosted at: github.com/ourbigbook/ourbigbook
Further documentation can be found at: docs.ourbigbook.com
Feel free to reach our to us for any help or suggestions: docs.ourbigbook.com/#contact