Alvania denhartogi
Alvania denhartogi is a species of minute sea snail, a marine gastropod mollusk or micromollusk in the family Rissoidae.[1]
| Alvania denhartogi | |
|---|---|
Scientific classification  | |
| Kingdom: | Animalia |
| Phylum: | Mollusca |
| Class: | Gastropoda |
| Clade: | Caenogastropoda |
| Clade: | Hypsogastropoda |
| Order: | Littorinimorpha |
| Family: | Rissoidae |
| Genus: | Alvania |
| Species: | A. denhartogi |
| Binomial name | |
| Alvania denhartogi Hoenselaar & Goud, 1998 | |
Description
Distribution
gollark: For example, it stores created/updated timestamps in a way which allows them to be looked up more quickly, makes it faster to look up the latest revision of stuff, allows me to do compression (I implemented brotli compression to reduce storage requirements a lot), and allows revisions to have data and represent stuff other than "the page content changed".
gollark: The new version *is* better, even if it involves something like 70 lines more code.
gollark: I've reworked minoteaur's design a bit again because productivity is BEES and happens to other people.```sqlCREATE TABLE pages ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, updated INTEGER NOT NULL, content TEXT NOT NULL);``` I went from that small and thus uncool database thingy to this:```sqlCREATE TABLE versions ( vuuid TEXT PRIMARY KEY COLLATE BINARY, rawSize INTEGER NOT NULL, encoding TEXT, data BLOB NOT NULL);CREATE TABLE pages ( title TEXT PRIMARY KEY, created INTEGER NOT NULL, updated INTEGER NOT NULL, latestVersion TEXT NOT NULL REFERENCES versions(vuuid));CREATE TABLE revisions ( ruuid TEXT PRIMARY KEY COLLATE BINARY, page TEXT NOT NULL REFERENCES pages(title), timestamp INTEGER NOT NULL, type TEXT NOT NULL, data TEXT NOT NULL, -- JSON version TEXT NOT NULL REFERENCES versions(vuuid));CREATE INDEX revisions_page_ix ON revisions(page);```
gollark: Suspicious timing.
gollark: potatOS privacy policy, first 4000 characters.
References
- Alvania denhartogi Hoenselaar & Goud, 1998. WoRMS (2009). Alvania denhartogi Hoenselaar & Goud, 1998. Accessed through the World Register of Marine Species at http://www.marinespecies.org/aphia.php?p=taxdetails&id=224644 on 9 August 2010 .
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.