Forum: Ruby on Rails Database integrity and multiple users?

Does RAILS ensure that multiple users of a RAILS application won't 
create a
corrupt database
if each user is creating database entries with foreign keys linking
multiple tables together?

Do you have to use explicit table locking ?

Thanks,

P.

On Oct 15, 10:44am, "xscr...@gmail.com" <xscr...@gmail.com> wrote:
> Does RAILS ensure that multiple users of a RAILS application won't create a
> corrupt database
> if each user is creating database entries with foreign keys linking
> multiple tables together?
>
> Do you have to use explicit table locking ?
>

Rails doesn't do anything by default. You can use optimistic or
pessimistic locking of rows if you need to guard against concurrent
modifications to a single row. I've never needed table level locking
(which is an obvious scalability bottleneck)
I personally always use foreign key constraints to enforce integrity
of those references

Fred