[REQ] Add bzip2 support to SPFileHandle

[GoogleCodeExporter]

For larger databases, it's pretty common to compress a dump with gzip, bzip2, 
or zip. It would be 
great if Sequel Pro could handle such dumps automatically when importing and 
exporting.

For anyone else looking at this, note that if you're connecting with SSH for an 
import or export, SSH 
compresses data as part of the encryption process, so this wouldn't help with 
network performance. 
So, with the current release, feel free to import and export multi-GB 
databases, as long as they 
compress reasonably well :)

Original issue reported on code.google.com by devianti...@gmail.com on 16 May 2010 at 6:28

[GoogleCodeExporter]

Hiya deviantintegral,

You'll be pleased to hear that we've built gzip support for dumps into trunk 
since 0.9.8 was branched; we also 
implemented this in a mutlithreaded approach, so imports should be the same 
speed as they are now and exports should 
be faster (whether or not gzip is in use!).  To give this a go, try the most 
recent nightly from http://nightly.sequelpro.com/ 
- gzipped files should be handled automatically when importing, and the SQL 
export dialog has a new "Compress dump 
file" checkbox. (But please note we don't recommend the use of the nightlies 
with production databases - they can 
represent development code which hasn't been as widely tested).

A quick final note - we don't actually use SSH compression, because we use 
MySQL-level compression instead, and using 
both will probably just cause a slowdown :)

Hope that helps - do comment again if you try and out and spot any issues, and 
we'll reopen.

Thanks for taking the time to request this!

Original comment by rowanb@gmail.com on 16 May 2010 at 7:19

• Changed state: Implemented

[GoogleCodeExporter]

Great to hear about gzip support - hopefully bzip2 makes it in as well.

Original comment by devianti...@gmail.com on 17 May 2010 at 3:19

[GoogleCodeExporter]

Interesting thought - do you feel we need bz in addition to gz? For reading, or 
also for writing?

Original comment by rowanb@gmail.com on 17 May 2010 at 3:49

[GoogleCodeExporter]

I would find it very useful for both import and export. With large databases, I 
find bzip2 can save me several 
hundred MB over gzip, so I use it for most of my dumps.

Original comment by devianti...@gmail.com on 17 May 2010 at 4:01

[GoogleCodeExporter]

OK - shouldn't be too hard now that we have the code structure already sorted.

Original comment by rowanb@gmail.com on 17 May 2010 at 4:44

• Changed title: [REQ] Add bzip2 support to SPFileHandle
• Changed state: Accepted

[GoogleCodeExporter]

At the moment it just fails when I try an import a g-zipped SQL file.  It'd be 
great having this feature added :)

Original comment by ben.schw...@gmail.com on 9 Jul 2010 at 4:24

[GoogleCodeExporter]

Hi Ben,

gzip support is already in the nightlies :)  Just need bzip support as well at 
some point…

Original comment by rowanb@gmail.com on 9 Jul 2010 at 9:10

[GoogleCodeExporter]

Stuart has started having a crack at bzip2 support, so assigning to him...

Original comment by rowanb@gmail.com on 9 Jul 2010 at 5:12

[GoogleCodeExporter]

Original comment by stuart02 on 18 Jul 2010 at 9:47

• Changed state: Started
• Added labels: Component-Logic, Milestone-Release0.9, Performance, Priority-Medium

[GoogleCodeExporter]

Implemented in r2473.

Original comment by stuart02 on 24 Jul 2010 at 9:35

• Changed state: Implemented

[GoogleCodeExporter]

Awesome, thanks!

Original comment by devianti...@gmail.com on 26 Jul 2010 at 2:31

[GoogleCodeExporter]

Issue 812 has been merged into this issue.

Original comment by rowanb@gmail.com on 13 Sep 2010 at 3:15