View Issue Details

IDProjectCategoryView StatusLast Update
0008414Talerwallet-corepublic2024-12-13 18:15
ReporterFlorian Dold Assigned ToFlorian Dold Resolution deadline
ImplementerReviewer 
Release signed byDeployed by 
VerifierCommunicator 
Data protection authority notification requiredNo  
CSIRT notification requiredNo  
Estimated effort (hours)Actual effort (hours)0 
Fast-trackNo
Work packagenone
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionfixed 
Target Version0.14Fixed in 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.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Relationships

child of 0008406 closedFlorian Dold Let the user copy the DB to the public folder 

Activities

Florian Dold

2024-11-05 10: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 12:27

manager   ~0023669

Actually, much easier to do this via VACUUM INTO.

Florian Dold

2024-11-06 13: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 13: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 ModifiedUsernameFieldChange
2024-02-15 21:34Florian DoldNew Issue
2024-02-15 21:34Florian DoldStatusnew => assigned
2024-02-15 21:34Florian DoldAssigned To => Florian Dold
2024-02-15 21:34Florian DoldSeverityminor => feature
2024-02-20 19:17MarcSRelationship addedchild of 0008406
2024-04-03 11:11Florian DoldSummarywallet-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 13:01Christian GrothoffTarget Version0.11 => 0.14
2024-05-24 10:09Florian DoldAssigned ToFlorian Dold => avalos
2024-07-25 21:55Christian GrothoffTarget Version0.14 => post-1.0
2024-08-09 21:04Christian GrothoffTarget Versionpost-1.0 => post-2.0
2024-11-05 10:07Florian DoldAssigned Toavalos => Florian Dold
2024-11-05 10:07Florian DoldTarget Versionpost-2.0 => 0.14
2024-11-05 10:07Florian DoldNote Added: 0023667
2024-11-05 11:31Christian GrothoffTarget Version0.14 => 1.0
2024-11-06 12:27Florian DoldNote Added: 0023669
2024-11-06 13:36Florian DoldStatusassigned => informing
2024-11-06 13:36Florian DoldResolutionopen => fixed
2024-11-06 13:36Florian DoldNote Added: 0023670
2024-11-06 13:37Florian DoldNote Added: 0023671
2024-11-06 13:37Florian DoldTarget Version1.0 => 0.14
2024-12-13 00:59Christian GrothoffFixed in Version => 0.14
2024-12-13 18:15Christian GrothoffStatusinforming => closed