Where to enforce the uniqueness of your data

Background Here you are, want to enforce a constraint such as any new record must have a unique name, title, etc, but you are not sure where to enforce it exactly. application level or DB level? Application level vs database level For me having your ...