https://bugzilla.wikimedia.org/show_bug.cgi?id=72931
Bug ID: 72931
Summary: Add el_timestamp to the externallinks table
Product: MediaWiki
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Web browser: ---
Mobile Platform: ---
Betacommand Ive got an interesting idea for the externallinks table. What
about having a including the timestamp that a link was added? Like what happens
with cl_timestamp ?
legoktm what's your usecase
Reedy it's doable, but ^
Betacommand legoktm: tracking when links are added, so batch requests for
archival (IE a partnership with IA) can be done
Betacommand or tracking how long a link has been in an article without
having to check every diff
Betacommand tracking overall external link volume over time
Betacommand or within a given time span
legoktm sounds useful
legoktm file a bug?
Betacommand legoktm: I was thinking about it but wanted a sounding board
first
This issue came up as I was thinking about external link recovery (Preventing
link rot). Right now there is zero ways of finding external links that have
been added in the last X time. Which means any attempt at proactive archiving
of URLs must be done via database dumps and diffing the externallinks table
between two dumps.
While it may be feasible for smaller wikis any type of diffing on a large scale
easily becomes unmanageable. Being able to do a select based off a given times
would enable this and would allow nightly incremental dumps that could then be
passed to archival sites to take proactive steps to avoid link rot.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
