Zlēkas Parish

Zlēkas Parish (Latvian: Zlēku pagasts) is an administrative unit of the Ventspils Municipality, Latvia.The parish has a population of 577 (as of 1/07/2010) and covers an area of 107.155 km2.

Villages of Zlēkas Parish
  • Krācnieki
  • Laidzesciems
  • Pasilciems
  • Vāverciems
  • Veclīcnieki
  • Zlēkas
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.
gollark: Yes. Please hold on while I post the schæma.
gollark: Yes.

This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.