Ginásio C.F. (basketball)

Casino Figueira Ginásio is a professional basketball team based in Figueira da Foz, Portugal. It plays in the second-tier Proliga. In 1977, it won the first-tier LPB.

Casino Figueira Ginásio
LeaguesProliga
ArenaPavilhão Galamba Marques
LocationFigueira da Foz, Portugal
Team colorswhite & red
Championships1 (1977)

Achievements

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.

References

  1. "II Divisão Basquetebol". zerozero.pt (in Portuguese). Archived from the original on 28 April 2020.
  2. "II Divisão Basquetebol – EVOLUÇÃO HISTÓRICA". zerozero.pt (in Portuguese). Archived from the original on 28 April 2020.


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