persistent-storage.md

Persistent Storage Design

Please refer to this diagram for more details

SQLite db as a persistent storage

Persistent storage is needed to store data in a non-volatile device during and after the running of object store harvestor SQLite has been chosen for that purpose. Object store harvestor by defualt stores all the data in db file : harvestor.db

Object store harvestor DB persistent storage objectives

• media files locations and types
• sidecar locations
• partial response from media file upload API POST request
• partial response from media file metadata API POST request

Desktop SQLite managing tool:

• SQLite DB desktop tool : sqlitebrowser

Working with SQLite db file : harvestor.db

• Download and install sqlitebrowser
• Open sqlitebrowser application
• 
• Click on Browse Data
• 
• On the left hand side choose from the Table dropdown menu a table of your interest.
• For more possible operations please refer to this documentation