In modern RDBMS, Reads does not block writes and writes does not block reads. And all these concurrent session works based on MVCC model implemented by database. For Ex - any update on a row in Postgres will create another version of the row so current transaction can read the new version and any earlier transaction will be looking the older version.