On 10/24/07, Steve Bennett <stevagewp(a)gmail.com> wrote:
Possible implementation:
Without knowing the MediaWiki DB schema at all, I speculated on a possible
implementation that would be a good tradeoff between size and speed. Two new
tables are needed:
<snip>
No need for the complex setup you envisiage. For mysql, at least, we
could create a new table 'article_aliases', and "select aa_page from
article_aliases where 'my_title' like aa_alias". Of course, we'd need
to do some built-in, potentially expensive checking on the aliases
that would be originally introduced, like checking if any other pages
match the regex (if so, block the alias), and if the article title
itself matches the regex (if not, block the alias).
I have no idea how portable this would be to postgres and other
database engines, but it could potentially work as an extension.
--
Andrew Garrett