On 5/26/2009 at 05:06 PM, in message <4A1BD439.3000006@suse.cz>, Pavol Rusnak
wrote: Rastislav Krupanský wrote: I am glad that it helped you. I still remember the surprise in the face of my friends after I do this trick on their machine. May be it is time I resume my project and make the sqlite compaction done in the background without users having to do it explicitly. It would be great.
I think that simple shell script running from cron would suffice. No need for extra C code or GUI. We just need to collect the files (by find command - eg. firefox or by knowing exact location - eg. banshee) and run sqlite vacuum command.
I created a wiki page[1] and repo on github[2]. Package will follow shortly. If you'd like to add other sqlite-enabled applications, please drop me a note.
[1] http://en.opensuse.org/Vacuumizer [2] http://github.com/stickac/vacuumizer/tree/master
Yes. A simple cron job is sufficient for this. But I started the project because I wanted to learn some GTK# programming, makefiles, icon usage etc. ;-) Also, I wanted to show some progress bars, easy GUI to add new db locations, warn if the application is running, etc. A simple shell script is more than sufficient to solve the problem, though :-) It may be a good idea to backup the sqlite files before you VACUUM them. -- Sankar http://psankar.blogspot.com -- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-factory+help@opensuse.org