Skip to content

Store detection information in a sqlite database on the pi #51

Description

@kgarwoodsdzwa

We currently just store the detection clips with the important metadata like time, confidence value, and species in the filename. We also store the sent log in a regular file. This will start to become very bloated after a long period of time. A way to make this lighterweight and faster to work with will be to store this info in a database, this way we can also store additional metadata like model version, hardware version, firmware version, sample rate, bitrate, etc. A good very first step for this would be seeing if you can use a sqlite database to store the sent/not sent log in this format rather than in the current text file format. If that's successful, we can go from there. There is a python package, sqlite3 that we can use for this.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions