Commit/Rollback changes made through statements executed in SQL editor

[pawelsalawa]

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 3393 Originally created at: Sat Dec 9 04:18:35 2017 Originally last updated at: Sat Dec 9 04:18:35 2017

Hi,

I'd like to see a commit/rollback feature for the SQL editor.

Steps: 1) Open SQL editor. 2) For example, execute an arbitraty INSERT statement on a table. 3) Let user decide whether changes should COMMITed or ROLLBACKed.

Thanks! :)

[pawelsalawa]

After further analysis I decided to move this story out of 3.2 version scope, because once we introduce such commit/rollback in the editor, people will start executing some queries in an editor, then do other things in other editor, maybe modify some objects with dialog windows and then they will rollback the first editor they started with, which will result in rolling back all the changes along the way, which is rather not expected.

To address the issue and make transaction local to the editor window, the window has to obtain its own connection to the database.

Quite a lot to do, while this feature is not the top priority (you still can use BEGIN/COMMIT in the SQL typed manually). I don't want it to hold the 3.2 release for too long, so I will postpone it.