It a matter of finding the right balance. You want scalability? you have to drop your constraints and external keys in your DB. In fact don't use a DB with a s

It a matter of finding the right balance. You want scalability? you have to drop your constraints and external keys in your DB. In fact don't use a DB with a schema. You want safe data? Use a good old relational DB with well designed schema and you're good to go.