turso-cli icon indicating copy to clipboard operation
turso-cli copied to clipboard
verified publisher icon tursodatabase

Should shell `.dump` use a transaction?

Open CodingDoug opened this issue 2 years ago • 1 comments

sqlite3 .dump wraps the entire SQL output (after PRAGMA foreign_keys=OFF;) in BEGIN TRANSACTION; and COMMIT;. Turso's shell does not. Should it? That would defend against a partial set of statements from executing in the face of an error part way through.

CodingDoug avatar May 30 '23 19:05 CodingDoug

Duplicate of https://github.com/libsql/libsql-shell-go/issues/75.

athoscouto avatar May 30 '23 20:05 athoscouto