David Gerard wrote:
Erik Moeller wrote:
Gregory Maxwell:
For every wikidata table there are actually two tables in the database, a item table and a revision table. In item, the key will be constrained to be unique and non-null, in the revision table it will be just non-null. Generally just follow mediawiki for the fields, but rather than text have your data fields.
The scenario of having a basically flat table that is versioned is a simple one. It gets tricky when you have 20 tables which are in complex relations with each other, and you want to revert or view a particular revision. Note that even our current MediaWiki is broken in this respect
- when you view an old version of a page, you see it with the latest
versions of the templates it uses, which can lead to very funny results.
This is mentioned on [[m:Article validation possible problems]] - you can't really rate a particular version going back too far sensibly as it'll show the current version of any templates.
Another advantage an import-only site would have - change of templates is controlled.
BTW, the "staticwiki.php" extension now fully works for text imports. Image imports are not supported yet.
Magnus