Re: [Wikitech-l] Case Insensitive Database Lookups

2013-10-02 Thread Sean Pringle
On Wed, Oct 2, 2013 at 10:22 AM, Matthew Walker wrote: > > Given that I want to support case insensitive searching; does anyone have > any thoughts or examples on how to go about doing it in a binary table? > > The only solution I can think of would be to change the collation/charset > of the tabl

Re: [Wikitech-l] Updating Wikipedia based on Wikidata changes

2013-07-28 Thread Sean Pringle
On Tue, Jul 23, 2013 at 1:42 AM, Denny Vrandečić < denny.vrande...@wikimedia.de> wrote: > > * EntityUsage: one table per client. It has two columns, one with the > pageId and one with the entityId, indexed on both columns (and one column > with a pk, I guess, for OSC). > * Subscriptions: one tab