Hi,
my “sessions” table got 10708 lines,
and the sqlite database is getting very big (24M) for just ~50 tasks.
How can I easily reduce the size of the sessions table ?

just run

{{{
rake db:sessions:clear
}}}

this task will clean the sessions from your database.

ignore the {{{ and }}}

Thanks !

RAILS_ENV=production rake db:sessions:clear

I managed, using it, to empty the sessions table, thank you !
But the database still got the exact same size… very strange !

I’m not sqlite expert, but perhaps there is some sort of ‘compact’ tool for sqlite databases? I see a VACUUM command, but I’m not sure if that will do the trick. http://www.sqlite.org/lang_vacuum.html

Great, thanks !

I did :

# sqlite3 db/tracks-15-blank.db

VACUUM;

.exit

And the database went from 24M to 65K !

great! Now to put a recurring todo in your tracks to remind you to do this once in a while