search

tursodatabase / libsql-shell-go

7 stars 7 forks source link

.dump doesn't use a transaction (sqlite3 does) #149

Open CodingDoug opened 11 months ago

CodingDoug commented 11 months ago

Output of an empty database using sqlite3 dump. Note the transaction that's always present:

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;

What the libsql shell outputs:

PRAGMA foreign_keys=OFF;

libsql should also wrap all of the sqlite commands in a transaction in the same way that sqlite3 does.