Re: Revisiting case-sensitivity in PHP

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