On Sun, Apr 6, 2008 at 11:21 AM, Platonides Platonides@gmail.com wrote:
Couldn't you track the link changes based on the binlogs content? It'd be quite low level, but already feasible.
Er, assuming that the user is keeping binlogs, and using MySQL for that matter. And assuming your application has filesystem read access to the binlogs, which would be approximately equal to having read access to all databases for security purposes. And assuming that they're kept forever, or that you're okay with having your history truncated every time the binlogs are. Which is a lot of assumptions.
The obvious way to implement link versioning is just to have fields like cl_from be foreign keys into revision, not page. The slight issue with this is increasing the size of all the links tables by a factor of, say, a hundred, when they're already among the largest tables. It should be feasible somehow; it's no more data to version than the article data, and in fact it's redundant to the article data. But no obvious plan strikes me at first thought.