User avatar
celeste_hearts_lesbianceleste_hearts_transceleste_hearts_demisexual flori_ava_star:~cursor_blinking @star@amazonawaws.com
9mo
migrated all database queries from directly using the database connection pool to execute statements to getting passed a single transaction instead during yesterday and today! neobot_melt_happy Feels good to have this done and use a much better, more reliable and controlled approach to handling data in my application neocat__w_
1
0
5
0
User avatar
celeste_hearts_lesbianceleste_hearts_transceleste_hearts_demisexual flori_ava_star:~cursor_blinking @star@amazonawaws.com
9mo
in case you are interested: using transactions requires you to commit or rollback your changes. When the transaction starts, you get presented a snapshot of the current view of the database. When committing, all changes are commited in one atomic step. Rolling back rolls back all changes made in the transaction.

The snapshot view also means that changes not yet committed do not affect other concurrent/parallel events happening in parallel on the database. It's very neat, easy and just a good way to avoid unwanted side effects and weird data inconsistency bugs.
0
0
4
0