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 Custom Indices: 117 MB > Compressed: 13 MB > > Dumped DB: 181 MB > Compressed: 6.8 MB
I assume you're using lzma -9 for both of these. You might try other compressors besides lzma but you're already getting very good compression. > Is there a way to strip even more redundancies from the DB for the > transfer (e.g. the automatically created indices for primary keys)? I think those are inherent in how SQLite works. You can't strip them from its format. > Alternatively, is there an easy way to dump and recover the DB using the > standard API rather than the SQLite shell? (Obviously I could write a > dump program myself, but I'd be nice if there is a solution that > requires less work). I think you've already worked out the best way to do it using sqlite and SQL formats. And of course if you're writing your own dump program you're probably better off using TSV format than raw SQL commands. Unless you have BLOBs in your file. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users