Sails.js: Is Waterline ORM safe without foreign key constraints?

I am developing a sails.js application with MySQL. I am using from the waterline ORM that comes with sails.js. According to this post , the waterline does not create foreign key constraints in the manner that you describe. It only creates the corresponding field. Is it safe to continue working with the waterline and go ahead and create tables?

+3


source to share


1 answer


Yes, it's safe. Foreign keys prevent insertion of values ​​with an identifier that you do not have in the linked table, but on the other hand, when you delete the identifier, they do not delete rows from the linked tables, so there is no such event as cascading deletion and table (or row) locking ...



+2


source







All Articles