[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 --- Comment #25 from Nemo federicol...@tiscali.it --- (In reply to comment #24) We use mysql (technically mariadb) not postgress It would be nice if PostgreSQL support also had some things *more* in MediaWiki, isn't it possible to add a feature depending on the used DB? -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 --- Comment #26 from Bawolff (Brian Wolff) bawolff...@gmail.com --- (In reply to comment #25) (In reply to comment #24) We use mysql (technically mariadb) not postgress It would be nice if PostgreSQL support also had some things *more* in MediaWiki, isn't it possible to add a feature depending on the used DB? Its possible, but something we don't generally do (in core anyways. Extensions can do what they want). Typically our db compatibility policy is that it must work on mysql, as mysql is our primary supported db platform. - Adding a fancy index like that in postgress, is probably not that much different from adding an extra field in mysql with the title reversed. -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 Janus Troelsen ysang...@gmail.com changed: What|Removed |Added CC||ysang...@gmail.com --- Comment #23 from Janus Troelsen ysang...@gmail.com --- There is at least some DB support for doing this efficiently. In PostgreSQL, since 9.1, there is a built-in function for reversing strings: http://www.postgresql.org/docs/9.2/static/functions-string.html In 9.0 and earlier, the function can be built in PL/pgSQL (search for it :) It is also possible to build indexes on expressions at least since 7.4: http://www.postgresql.org/docs/7.4/static/indexes-expressional.html (didn't find any older documentation) -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 --- Comment #24 from Bawolff (Brian Wolff) bawolff...@gmail.com --- (In reply to comment #23) There is at least some DB support for doing this efficiently. In PostgreSQL, since 9.1, there is a built-in function for reversing strings: http://www.postgresql.org/docs/9.2/static/functions-string.html In 9.0 and earlier, the function can be built in PL/pgSQL (search for it :) It is also possible to build indexes on expressions at least since 7.4: http://www.postgresql.org/docs/7.4/static/indexes-expressional.html (didn't find any older documentation) We use mysql (technically mariadb) not postgress -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 Chong-Dae Park cdp...@gmail.com changed: What|Removed |Added CC||puzz...@gmail.com --- Comment #22 from Chong-Dae Park cdp...@gmail.com 2012-11-23 02:52:41 UTC --- *** Bug 2168 has been marked as a duplicate of this bug. *** -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 Max Semenik maxsem.w...@gmail.com changed: What|Removed |Added CC||maxsem.w...@gmail.com --- Comment #21 from Max Semenik maxsem.w...@gmail.com 2011-09-14 10:02:39 UTC --- (In reply to comment #20) Just add an SQL ORDER BY clause at the end. And it will be sorted by reverse title. Not quite useful. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 --- Comment #20 from jida...@jidanni.org 2011-09-14 01:38:52 UTC --- Just add an SQL ORDER BY clause at the end. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 --- Comment #17 from Nemo_bis federicol...@tiscali.it 2011-09-11 08:55:23 UTC --- (In reply to comment #16) Thus unless SuffixIndex would be useful with results in non-alphabetical order (which seems unlikely) this should be wontfixed as unfeasible imo. Alphabetical order doesn't seem necessary at all to me. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 --- Comment #18 from MZMcBride b...@mzmcbride.com 2011-09-11 19:11:08 UTC --- (In reply to comment #16) Thus unless SuffixIndex would be useful with results in non-alphabetical order (which seems unlikely) this should be wontfixed as unfeasible imo. I don't think it's that infeasible to add a page.page_title_reversed column and index it (possibly in a page_title_reversed,page_title pair). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 --- Comment #19 from Bawolff bawolff...@gmail.com 2011-09-11 19:23:20 UTC --- (In reply to comment #18) (In reply to comment #16) Thus unless SuffixIndex would be useful with results in non-alphabetical order (which seems unlikely) this should be wontfixed as unfeasible imo. I don't think it's that infeasible to add a page.page_title_reversed column and index it (possibly in a page_title_reversed,page_title pair). My point was that would result in a non-alphabeticaly ordered suffix list. If that's ok then it is potentially feasible to do, if a non-alphabetical list is not acceptable, it would not be possible to reasonably do this (As far as I can tell). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 Bawolff bawolff...@gmail.com changed: What|Removed |Added CC||bawolff...@gmail.com --- Comment #16 from Bawolff bawolff...@gmail.com 2011-09-11 04:02:40 UTC --- So say we want a list of All things ending with ed - would you want that list in alphabetical order? (If the answer is yes this would be really difficult to do, if no then less difficult). Since if you want it in alphabetical order we'd basically need an index sorting it in both directions since first we jump to everything ending in ed, and then we need to sort from the other end (normal direction) of the word. Otherwise in our suffix search (for say the suffix ed) we'd have sorting like yielded, zigzagged, recovered, edited, amortized (Note how the third last letter of each word is alphabetically ordered) I suppose one could create a table that for each page name had a partially reversed page name, and to what point its reversed, for all possible points- For example for the page Fred (with page_id 1) we'd have: page_id | page_reversed_point | page_reversed +-+-- 1 | 1 | dFre 1 | 2 | edFr 1 | 3 | redF 1 | 4 | Fred +-+-- So each page would have up to 255 entries depending on how long the title is. (because the user could search for a suffix between 1 to 255 letters long). However, having such a table would be INSANE ;) Thus unless SuffixIndex would be useful with results in non-alphabetical order (which seems unlikely) this should be wontfixed as unfeasible imo. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 Nemo_bis federicol...@tiscali.it changed: What|Removed |Added CC||federicol...@tiscali.it --- Comment #15 from Nemo_bis federicol...@tiscali.it 2011-07-14 11:19:53 UTC --- Because someone (like me) could look for this feature here, I leave here a link to a Toolserver tool that can be used to get such titles (thank you MZMcBride), for instance http://toolserver.org/~mzmcbride/yanker/?db=enwiktionary_plist=pagescategory=page=pattern=.%2Bps%24namespace=0limit=5000sort=wrapper=%241 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 MZMcBride b...@mzmcbride.com changed: What|Removed |Added CC||br...@wikimedia.org --- Comment #14 from MZMcBride b...@mzmcbride.com 2011-05-17 18:50:46 UTC --- I wonder if the page_props table could be used for this. The current schema has the following unique index: CREATE UNIQUE INDEX /*i*/pp_page_propname ON /*_*/page_props (pp_page,pp_propname); If a second index were added on (pp_propname, pp_value), you could store the reversed page title with a suffixindex key fairly easily, couldn't you? Except that pp_value is a blob... bleh. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 jida...@jidanni.org changed: What|Removed |Added CC||jida...@jidanni.org --- Comment #12 from jida...@jidanni.org 2010-11-20 08:50:37 UTC --- From an outsider's point of view it looks like an oversight to only have [[Special:PrefixIndex]]. On it you could put mention the reason for no complimentary [[Special:SuffixIndex]] there for people to see... Tons of times when I wanted to use it... Let's find all the ... Agencys on my wiki, etc. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 jida...@jidanni.org changed: What|Removed |Added URL||http://en.wikipedia.org/wik ||i/Wikipedia_talk:Special:Pr ||efixIndex#SuffixIndex -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 Casey Brown b...@caseybrown.org changed: What|Removed |Added CC||b...@caseybrown.org --- Comment #13 from Casey Brown b...@caseybrown.org 2010-11-20 23:41:50 UTC --- (In reply to comment #12) Let's find all the ... Agencys on my wiki, etc. ...or pages in Chinese (PAGE/zh). :-) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 百楽兎 public.w...@gmail.com changed: What|Removed |Added CC||public.w...@gmail.com --- Comment #10 from 百楽兎 public.w...@gmail.com 2009-12-16 11:19:48 UTC --- *** Bug 21864 has been marked as a duplicate of this bug. *** -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 --- Comment #11 from 百楽兎 public.w...@gmail.com 2009-12-16 11:20:46 UTC --- *** Bug 21864 has been marked as a duplicate of this bug. *** -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 10808] Introduce Special:Suffixindex
https://bugzilla.wikimedia.org/show_bug.cgi?id=10808 MZMcBride pub...@mzmcbride.com changed: What|Removed |Added CC||pub...@mzmcbride.com Status|RESOLVED|REOPENED Resolution|LATER | --- Comment #9 from MZMcBride pub...@mzmcbride.com 2009-04-20 01:35:52 UTC --- Re-opening this. There are legitimate use cases for this (like Wiktionary, cf. bug 17999). Nothing's really holding this up except a developer willing to implement it (i.e., no reason to leave this as LATER). -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email --- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
