Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Wikipedia: Wikitech

Filtering for RevisionDeleted edits

 

 

Wikipedia wikitech RSS feed   Index | Next | Previous | View Threaded


church.of.emacs.ml at googlemail

Nov 22, 2009, 11:04 AM

Post #1 of 2 (462 views)
Permalink
Filtering for RevisionDeleted edits

Hi,

since some time we have RevisionDelete, which allows deleting specific
revisions of a page without having to delete the whole page. This
feature is currently enabled for Oversight on WMF wikis and the
community wants it to be enabled for regular administrators[1].

The only bug currently blocking this request is
https://bugzilla.wikimedia.org/show_bug.cgi?id=20186
which requests an easy method to filter history and contributions lists
for RevisionDeleted edits.

I partially fixed that bug in r58153, but afaik there is a problem with
the current database layout:
To filter for revisiondeleted edits, one has to go through all
history/contributions lists and look at each individual revision if it
is rev_deleted or not. This clearly isn't efficient and fails for pages
that have a large history.

Afaik, a database change is needed to make filtering for RevisionDeleted
edits efficient for large pages (I'm no DB expert, though).

Any suggestions on this problem?


Regards,

Church of emacs

[1] https://bugzilla.wikimedia.org/show_bug.cgi?id=18780
https://bugzilla.wikimedia.org/show_bug.cgi?id=19697
Attachments: signature.asc (0.25 KB)


Platonides at gmail

Nov 22, 2009, 3:33 PM

Post #2 of 2 (429 views)
Permalink
Re: Filtering for RevisionDeleted edits [In reply to]

CREATE INDEX /*i*/rev_deleted ON /*_*/revision (rev_page,rev_deleted); ?


_______________________________________________
Wikitech-l mailing list
Wikitech-l [at] lists
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Wikipedia wikitech RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.