Show this thread
-
Hey
@sgrif I'm sure you know about these things, would you care to weigh in?
`find_or_create` is impossible to actually do atomically without *some* sort of trade-off. You can do something extremely janky involving doing an insert in a CTE and then doing a select with a union to the CTE. `create_or_find_by` is probably the best you can do on MySQL
-
-
Important to note that CTEs *do not* make the query atomic. It just reduces the potential for race conditions by removing round trip time. There is *no* atomic solution for this on any DB
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.