Freezer icon indicating copy to clipboard operation
Freezer copied to clipboard

Sqlite database grows without bound

Open joshaber opened this issue 12 years ago • 3 comments

Currently the sqlite database just keeps adding things. That's less than ideal. We should have some way of trimming it.

Some things:

  • We could trim down to the most recent level attribute-value for all keys.
  • But it's tricky to know that someone's not holding on to an old database.
  • How does this interact with #3?

joshaber avatar Nov 07 '13 22:11 joshaber

This has been partially addressed by 4a50b1952ab17d4a8e9bbfa242ea2c032c6d8d92, but:

  • The API isn't public yet.
  • It hasn't been tested thoroughly.
  • Trimming might be something users would want to customize. Trim only the oldest x entries, trim when it's bigger than x, etc.

joshaber avatar Nov 09 '13 03:11 joshaber

-trim: is now public and functionally complete as of https://github.com/joshaber/Freezer/commit/cd688e2b7640890f6bd6daf1d0fbd32485f80a35.

It'd be great to provide more customization in the future.

joshaber avatar Nov 16 '13 06:11 joshaber

It'd also be nice if -trim: could make some safety guarantees, i.e., no open databases.

joshaber avatar Nov 16 '13 06:11 joshaber