Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Suggestions about deleting data from databases. #810

Closed
IonuDragomir1 opened this issue Apr 28, 2023 · 5 comments
Closed

Suggestions about deleting data from databases. #810

IonuDragomir1 opened this issue Apr 28, 2023 · 5 comments
Labels

Comments

@IonuDragomir1
Copy link

Hi,
I'd like to make some suggestions about deleting data from databases.

  1. It's not clear to me what data are deleted from DB or what happens with the DB after 1 year from the option shown below:

image

What data from SQLite db is deleted after 1 year? The SQLite may contain many databases with lots of tables.

image

Clearing all alarms and history feature is very useful, but are many practical situations where the user wants to keep alarms or history from the last months, or a year. So it'd be useful if the user could choose how much time the alarms and history data are stored in database.

@unocelli
Copy link
Member

Hi,

  1. the DAQ storage for SQlite is separated and saved in _db, chunked in files ~pro day and these files are deleted if they are old.
  2. We have to add the feature like DAQ, so that you can define how long the alarm history should be maintained.

@IonuDragomir1
Copy link
Author

  1. Yes, this would be a very useful feature.

@unocelli
Copy link
Member

@IonuDragomir1 You will find the feature in the latest commit. let me know if you have any issues.

@IonuDragomir1
Copy link
Author

Thank you! If there are any issues, I'll let you know.

@unocelli
Copy link
Member

unocelli commented Jul 9, 2023

I’m going to close this as resolved. let me know if you have any issues.

@unocelli unocelli closed this as completed Jul 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants