ActiveRecord transactions & thread safety

rubyonrails-talk
1

My question is about AR transactions feature. Is it thread safe? Is it safe to use both **ActiveRecord::Base.transaction do ...** and **Account.transaction do ...** statements?

I plan to use Puma as web server, and Sidekiq for background processing.

Is there some tricks I should know about?

Thanks!

2

My question is about AR transactions feature. Is it thread safe? Is it safe to use both `ActiveRecord::Base.transaction do ...` and `Account.transaction do ...` statements?

It should be - a connection is only ever used by 1 thread at a time (and unless you have configured Account to use a separate connection then AR won't be default create nested transactions/save points )If you could show in more detail what you are doing then a more considered reply might be possible.

Fred