Central Basketball League
The Central Basketball League was an early regional professional or semi-pro basketball league based in Ohio and Pennsylvania. The league disbanded on November 12, 1912 after playing a few exhibition games. Joseph "Joe" Meech Leithead served as Secretary prior to 1908 and President of the League for four years 1908-1912. Previously, Leithead was coach and captain of the Pittsburgh's South Side team from 1899-1907. "Joe Leithead Retires from the Floor Game" 10/20/43 Pittsburgh Sun Telegraph article by Harry Keck (sports editor) "Low Score Basketball Games Recalled by Vets' Reunion - Joe Leithead Honor Guest".
Complete team list
|
|
Champions
- 1906/07 East Liverpool Potters & Pittsburgh South Side
- 1907/08 East Liverpool Potters
- 1908/09 Homestead Young Americans
- 1909/10 McKeesport Tubers
- 1910/11 McKeesport Tubers
- 1911/12 Johnstown Johnnies
- 1912/13 LEAGUE DISBANDED
gollark: Basically, if I want to run a search it just goes `SELECT * FROM page_tokens WHERE token = 'one token in search query'` or something like that, and it now has a list of pages with the right token, and SQLite can execute this query relatively fast.
gollark: I mean, as far as I can tell there isn't really a faster *and* more storage-efficient way to do search than the inverted-index page_tokens thing.
gollark: ```sqlCREATE TABLE crawl_queue ( id INTEGER PRIMARY KEY, url TEXT NOT NULL UNIQUE, lockTime INTEGER, added INTEGER NOT NULL, referrer TEXT);CREATE TABLE pages ( id INTEGER PRIMARY KEY, url TEXT NOT NULL UNIQUE, rawContent BLOB NOT NULL, rawFormat TEXT NOT NULL, textContent TEXT NOT NULL, updated INTEGER NOT NULL);CREATE TABLE page_tokens ( id INTEGER PRIMARY KEY, page INTEGER NOT NULL REFERENCES pages(id), token TEXT NOT NULL, weight REAL NOT NULL);CREATE TABLE links ( id INTEGER PRIMARY KEY, toURL TEXT NOT NULL, fromURL TEXT NOT NULL, lastSeen INTEGER NOT NULL, UNIQUE (toURL, fromURL))```Here is the database.
gollark: To be fair, the text content field isn't that necessary, as for search it uses the page_tokens table anyway and it can be rebuilt from the HTML if I need it.
gollark: The frequency of every word *must* be stored for quick (O(log n) time or something) search, the raw HTML or at least might be needed if I come up with a better way to weight frequency or something, the links are useful for (future) better search ranking algorithms.
External links
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.