Skip to content

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

Description

@CodingDoug

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions