Yes, be aware of the transactional capabilities of your database. Some ACID databases in their default configuration don't provide all transactional guarantees!
[1] https://www.postgresql.org/docs/current/static/transaction-i...
[2] https://en.wikipedia.org/wiki/Isolation_(database_systems)#I...