Hi
On 6/13/24 21:48, Timo Tijhof wrote:
I ask because MediaWiki's main "text" database table is an
immutable/append-only store where we store the text of each page revision
since ~2004. It is stored as serialised blobs of a value class. There have
been a number of different implementations over the past twenty years of
Wikipedia's existence (plain text, gzip-compressed, diff-compressed, etc.).
Is it theoretically possible to migrate the table contents using an upgrade script that does something along these lines:
UPDATE text SET blob = serialize(unserialize(blob));
? Or is it actually immutable by somehow incorporating the blob (or a hash of the blob) in some kind of hash chain or Merkle tree?
Best regards
Tim Düsterhus