King County (disambiguation)

King County is a county in Washington State that includes the city of Seattle.

King County may also refer to:

Places

Ships
gollark: I did think of the idea of *only* having `revisions` and just running weird queries on that, but it involves more problems.
gollark: Also, the latest update to something doesn't show on the user-visible revisions page, which is a minor nitpick but I mildly dislike it.
gollark: This isn't really ideal, as I think I'm duplicating data a bit (timestamps), updating a page involves more work, and more importantly the `revisions` thing doesn't have any relevant information beyond what's available from `pages`.
gollark: Basically, when there's a new revision, the apiosystem reads the current content out of `pages`, compresses it, generates and serializes the metadata, then shoves in a row into `revisions`.
gollark: As of now I do this:```sqlCREATE TABLE pages ( title TEXT NOT NULL UNIQUE, content TEXT NOT NULL, updated INTEGER NOT NULL, created INTEGER NOT NULL);CREATE TABLE revisions ( page TEXT NOT NULL REFERENCES pages(title), timestamp INTEGER NOT NULL, meta BLOB NOT NULL, -- contains revision metadata and type -- ChangeContent { size } is the only one here for now full_data BLOB -- contains optionally compressed text);```but it is not ideal.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.