Re: [Snowy] Issues with MySQL

[Sandy Armstrong <sanfordarmstrong gmail com>]

On Mon, Jun 1, 2009 at 4:04 PM, Sandy Armstrong
<sanfordarmstrong gmail com> wrote:
> On Mon, Jun 1, 2009 at 10:55 AM, Brad Taylor <brad getcoded net> wrote:
>> While this approach may work in Tomboy where the worst penalty is on the
>> user, when we put it on the web, everyone is impacted by a user who
>> writes an Homerian epic in the note title.
>
> Okay.  Maybe we should just not guarantee title uniqueness in the
> Snowy DB.  If you think about it, when we generate titles for new
> notes and when we attempt to rename notes in Funcooker (TM), we're
> going to have to do a query anyway.  In the case of new notes we'll
> have to create a new unique title, and in the case of renames we'll
> want to give useful error messages instead of just a DB error.  So is
> it worth it to guarantee title uniqueness at the DB level?  I'm not
> sure what the benefit is, but I'm probably missing something obvious.
> If a duplicate title somehow snuck in via sync or something, I don't
> think anything would break.

A user filed a bug for this, and I attached a patch removing the
uniqueness constraint on note titles.  Waiting for brad to return
before pushing:

https://bugzilla.gnome.org/show_bug.cgi?id=595626

Sandy