Re: best stategry: check before create

[prev] [thread] [next] [Date index for 2005/03/18]

On Fri, 2005-03-18 at 00:34 -0800, Ofer Nave wrote:
> I appreciate the help, but I think I'm going to try a different 
> strategy.  I think I'll explictly 'search' and then 'create' if the 
> search yields 0 results.  Somehow that feels cleaner.

Keep in mind that there's a race condition in that strategy.  Someone
could create a record between your search and create.  (This is true for
find_or_create too.)  You need to either be prepared for possible (rare)
failures in the create step, or lock the tables for the length of the
search and create.

- Perrin