Mailing list discussion:

http://www.google.com/search?q=site%3Ahttp%3A%2F%2Fmail.gnome.org%2Farchives%2Fsnowy-list%2F+mysql&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

Created attachment 143607 [details] [review]
[Note model] Remove uniqueness constraint on title (#595626)

TextFields cannot be unique in MySQL.

Per the mailing list discussion, I don't think we need to verify title uniqueness at the model level.

In fact, it is possible for users to modify their Tomboy note files directly to have identical titles, and in such a situation they would find themselves unable to use Snowy.

I believe we only need to worry about uniqueness when renaming a note, which is a rare operation (especially now, when we don't have note editing enabled), which means it's okay for it to be slow.

The only users who would benefit from us introducing a model-level uniqueness constraint are the same users who find themselves unable to use Snowy in the first place if we have such a constraint.  :-)

I'll probably wait for feedback from Brad (who is out of the country until next week) before I push this, but other comments are welcome.

Comment on attachment 143607 [details] [review]
[Note model] Remove uniqueness constraint on title (#595626)

Sounds good.  We'll sort out the shrapnel when we implement title editing.