Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:123654
Message-ID: <a0c5e311-615e-46d2-99c4-15326ffd7108@bastelstu.be>
Date: Mon, 17 Jun 2024 19:15:29 +0200
Precedence: bulk
MIME-Version: 1.0
Subject: Re: [PHP-DEV] Revisiting case-sensitivity in PHP
To: Timo Tijhof <ttijhof@wikimedia.org>,
 php internals <internals@lists.php.net>
References: <CAPyeZ4O2rK+2ApuE-YLc7j_Z2LcT29yHcLYXvB0oGs-D_zTSag@mail.gmail.com>
 <CAMjSS5OPKm0dRP+ckCdpBd4Kg1aRhU5QgcuTWwPTnyC_1aZRkw@mail.gmail.com>
Content-Language: en-US
In-Reply-To: <CAMjSS5OPKm0dRP+ckCdpBd4Kg1aRhU5QgcuTWwPTnyC_1aZRkw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
From: tim@bastelstu.be (=?UTF-8?Q?Tim_D=C3=BCsterhus?=)

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