Using transactions in all CRUD operations

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема Using transactions in all CRUD operations
Дата
Msg-id CAAY=A7-2mXGycTAjqF8xEUga5YnY8YxAZWD=YaTfooZeXq=GKw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Using transactions in all CRUD operations  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Список pgsql-sql
Hello,

I am developing an information system applying several design patterns being the Unit of Work one of them. For this pattern, my code automatically implements the use of transactions and this means that all of the DB CRUD operations will use them: INSERT, UPDATE, DELETE AND SELECT statements. It makes sense to me that all of these operations, except for the SELECT statement, make use of transactions. However, my Unit of Work design pattern has them implemented by default. I have read some articles about using transactions on SELECT statements and have seen that it is not as absurd as it seems to me to use transactions with only SELECT statements inside. My main reason to use transactions in all CRUD operations is to maintain my Unit of Work design pattern standard. If using transactions for all CRUD operations is not a good practice or not recommendable, then I have to choice to re-design my code

I will very much appreciate your valuable feedback on this topic.

Respectfully,
Jorge Maldonado

Libre de virus. www.avast.com

В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump compatibility level / use create view instead of create table/rule
Следующее
От: Rene Romero Benavides
Дата:
Сообщение: Re: Using transactions in all CRUD operations