Re: [sqlite] Reduce database file size

On Sun, 11 Apr 2010 14:09:21 -0400 Nikolaus Rath wrote: > Using rsync is unfortunately not possible, I'm stuck with HTTP and > FTP. > > I tried a few PPM compressors, but even though the compression ratio > is amazing, I'm not desperate enough to invest *that* much CPU time >

Re: [sqlite] Reduce database file size

If the subject is transferring data from a web server to a central database, I like to refer to a feature of an open source package that I published myself. It is only a side-side feature, resulting from the general design, but it was added with just this in mind. This feature, 'Connecting

Re: [sqlite] Reduce database file size

Nikolaus Rath wrote: > I see. I gues I got confused by the help that refers to the parameter as > 'cmd': The help shows that a list of TABLE is taken in the same syntax as SQLite's shell uses. Also note that the help is formatted for documenting interactive usage rather than API usage. > That

Re: [sqlite] Reduce database file size

Roger Binns writes: > On 04/11/2010 11:09 AM, Nikolaus Rath wrote: >> Yes, you remember correctly. Actually that would be a perfect solution. >> But how do I use it? It seems to me that I need to pass some argument to >> Shell.command_dump(), because the following just

Re: [sqlite] Reduce database file size

On 04/11/2010 11:09 AM, Nikolaus Rath wrote: > Yes, you remember correctly. Actually that would be a perfect solution. > But how do I use it? It seems to me that I need to pass some argument to > Shell.command_dump(), because the following just produces an empty file: > > > import apsw > ofh =

Re: [sqlite] Reduce database file size

Roger Binns writes: > On 04/10/2010 03:06 PM, Nikolaus Rath wrote: >> However, I noticed that if I dump the entire database into a text file >> with the SQLite shell and then compress the text file, the result is >> significantly smaller than the "stripped" compressed

Re: [sqlite] Reduce database file size

On 04/10/2010 03:06 PM, Nikolaus Rath wrote: > However, I noticed that if I dump the entire database into a text file > with the SQLite shell and then compress the text file, the result is > significantly smaller than the "stripped" compressed database: Have you tried different page sizes? You

Re: [sqlite] Reduce database file size

On 10 Apr 2010, at 11:06pm, Nikolaus Rath wrote: > However, I noticed that if I dump the entire database into a text file > with the SQLite shell and then compress the text file, the result is > significantly smaller than the "stripped" compressed database: > > Full database: 146 MB > Without