Compact SQLite database

Christian Langers chris at
Wed Dec 30 13:09:11 EST 2009

Hi Stewart,

this could answer your question : <>

try somthing like this (if needed) :

global gConID
put "VACUUM" into tSQL
get revdb_execute(gConID,tSQL)

Hope this helps,


On 30/12/09 17:42, RevList wrote:
> Is there a way to compact a SQLite database from within a Rev application?
> I have an application that uses a SQLIte database and it grows in size as
> records are added.  The nature of the application is that the database is
> often purged but the db size does not reduce.  I can use a SQLite Manager
> application to compact the database, but I would rather do this within the
> application when the database is purged.
> Thanks in advance.
> Stewart Lynch
> --------------------------------------------------------------------------------------------------------------------
> This message and any attachments are intended only for the use of the
> individual to whom they are addressed and it may contain information that
> is privileged or confidential. If you have received this communication by
> mistake, please notify us immediately.
> --------------------------------------------------------------------------------------------------------------------
> _______________________________________________
> use-revolution mailing list
> use-revolution at
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the Use-livecode mailing list