Pack SQLite database?

Hi,
Our SQLite data source support the version tracking (change history and recycle bin). It's possible that's why you database size has increased. Do you want us to add an option to disable this?

I'm not sure that this is the root cause. Databases normally don't release space for deleted objects, that why one has to "pack" them.

It's possible. I will verify what we can do.

Hi,
I've found this:

http://www.sqlite.org/lang_vacuum.html

I will see if we can add this for the next version

Check also this topic about vaccum with the SQLite command line

http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html

Yes, that's the one I was referring to. The problematic things are that the database is in use by Remote Desktop Manager and encrypted. But you're likely already aware of this.
edited by thorsten on 6/23/2013

I think that you will need to close RDM to do the vaccum

The v9.0 beta (out soon) will have the Vacuum functionality built in. The Data Source screen will have an extra tab called "Maintenance" where you can perform the Vacuum. Also note the "PRAGMA auto_vacuum =FULL;" will also be set.

Niiice!