Do you need to preserve cases? If not, you could just normalize them during validation.
Saklad5
Users receive reputation points by contributing quality content to the forums.
Posts include post and replies published on the forums.
Post authors can mark replies as Accepted to indicate successful solutions.
Apple Developer Forums admins can mark replies as Apple Recommended to indicate an approved solution
Last seen
User for
Post
Replies
Boosts
Views
Activity
I recommend using derived attributes. I haven't tried using them for unique constraints, but you can definitely use them to make an attribute that is an all-lowercase version of "name".
What platform are you on? This seems more like a concurrency question, and there are different options on different platforms.If you want it to run on macOS, I've found NSBackgroundActivityScheduler works wonders. The completion handler it uses can be trivially called from within an NSManagedObjectContext's perform method, too.