View Issue Details

IDProjectCategoryView StatusLast Update
0008414Talerwallet-corepublic2024-11-06 14:37
ReporterFlorian Dold Assigned ToFlorian Dold  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status resolvedResolutionfixed 
Target Version0.14 
Summary0008414: wallet-core should be able to export the db via the sqlite3 backup functionality [estimate: 5h]
DescriptionThis allows exporting larger DBs without having to convert everything to JSON in-memory.

The backup functionality of sqlite3 allows exporting the DB without blocking the running wallet.
TagsNo tags attached.

Relationships

child of 0008406 assignedMarcS Let the user copy the DB to the public folder 

Activities

Florian Dold

2024-11-05 11:07

manager   ~0023667

We need this one earlier to allow users to make a backup of the DB while wallet-core is running (just copying the sqlite3 file might corrupt the DB).

As the DB should be stored in a file system location where other apps can't access it, can't just ask the user to stop the app and get the DB from the file system.

Florian Dold

2024-11-06 13:27

manager   ~0023669

Actually, much easier to do this via VACUUM INTO.

Florian Dold

2024-11-06 14:36

manager   ~0023670

commit 5c1bcc68baed6593ca107ac4d6f5f2b850a7b688 (HEAD -> master, origin/master, origin/HEAD)
Author: Florian Dold <florian@dold.me>
Date: Wed Nov 6 14:35:11 2024 +0100

    wallet-core: implement exporting DB to file

Florian Dold

2024-11-06 14:37

manager   ~0023671

Implemented via the new `exportDbToFile` request:

fdold-work@sapota ~/r/t/wallet-core (master)> taler-wallet-cli api 'exportDbToFile' '{"directory":"dbdump", "stem":"mydb"}'
[...]
2024-11-06T13:36:05.638Z taler-wallet-cli.ts INFO handling 'api' request (exportDbToFile)
[...]
{
  "type": "response",
  "operation": "exportDbToFile",
  "id": "my-req",
  "result": {
    "path": "dbdump/mydb.sqlite3"
  }
}

Issue History

Date Modified Username Field Change
2024-02-15 22:34 Florian Dold New Issue
2024-02-15 22:34 Florian Dold Status new => assigned
2024-02-15 22:34 Florian Dold Assigned To => Florian Dold
2024-02-15 22:34 Florian Dold Severity minor => feature
2024-02-20 20:17 MarcS Relationship added child of 0008406
2024-04-03 13:11 Florian Dold Summary wallet-core should be able to export the db via the sqlite3 backup functionality => wallet-core should be able to export the db via the sqlite3 backup functionality [estimate: 5h]
2024-04-05 15:01 Christian Grothoff Target Version 0.11 => 0.14
2024-05-24 12:09 Florian Dold Assigned To Florian Dold => avalos
2024-07-25 23:55 Christian Grothoff Target Version 0.14 => post-1.0
2024-08-09 23:04 Christian Grothoff Target Version post-1.0 => post-2.0
2024-11-05 11:07 Florian Dold Assigned To avalos => Florian Dold
2024-11-05 11:07 Florian Dold Target Version post-2.0 => 0.14
2024-11-05 11:07 Florian Dold Note Added: 0023667
2024-11-05 12:31 Christian Grothoff Target Version 0.14 => 1.0
2024-11-06 13:27 Florian Dold Note Added: 0023669
2024-11-06 14:36 Florian Dold Status assigned => resolved
2024-11-06 14:36 Florian Dold Resolution open => fixed
2024-11-06 14:36 Florian Dold Note Added: 0023670
2024-11-06 14:37 Florian Dold Note Added: 0023671
2024-11-06 14:37 Florian Dold Target Version 1.0 => 0.14