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

old databases may take up too much space #1

Open
coldnebo opened this issue Feb 28, 2014 · 0 comments
Open

old databases may take up too much space #1

coldnebo opened this issue Feb 28, 2014 · 0 comments

Comments

@coldnebo
Copy link
Owner

using DataHut for logging and analysis, I've noticed that sometimes the sqlite database file grows big and stays big no matter how much record culling is done.

in this case, a method like dw.compact! would be useful. This could call sqlite's VACUUM statement like this:

@db.run "VACUUM"

Also, perhaps the db should be exposed to people who need to maintain the sqlite db directly? (previously I had tried to hide the db as I wanted the primary interaction to be through data_hut and perhaps the records themselves, but there are certain meta operations (like VACUUM) that are made easier by having a public handle to the db as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant