1857 in Denmark
| |||||
| Decades: |
| ||||
|---|---|---|---|---|---|
| See also: | Other events of 1857 List of years in Denmark | ||||
Events from the year 1857 in Denmark.
Incumbents
- Monarch – Frederick VII[1]
- Prime minister – Carl Christoffer Georg Andræ (until 13 May), Carl Christian Hall
Births
- July 24 — Henrik Pontoppidan, Nobel Prize-winning writer (died 1943)
- December 7 — Hans-Georg Tersling, architect (died 1820)
Deaths
- June 23 – Christian Molbech, historian and editor (born 1783)
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.
References
- "Frederick VII | king of Denmark". Encyclopedia Britannica. Retrieved 21 June 2019.
- "Hassel & Teudt". coneland.dk (in Danish). Retrieved 12 March 2018.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.