Database Transactions

[Timu57]

As pointed out by @daussho in #177 a database transaction feature with automatic rollback would be awesome.

Interesting articles regarding database transactions:

https://en.wikipedia.org/wiki/Database_transaction
https://en.wikipedia.org/wiki/ACID

https://en.wikipedia.org/wiki/Software_transactional_memory

[REDAL]

@Timu57 @rakibtg

Did you did further reading about this idea ?!

how about, making temporary files of the query, then verifying if everything went good, just renaming the files with the next id

for example, when trying to make 2 writing in 2 different tables, that are related, just make a temporary file table1.x(id).temp
and make the second writing, table2.x(id).temp, if both operations were successful, then rename the files

table1/256
table2/317

what do you think of this practice