How about creating a fifo (aka Named pipe) and passing the filesystem name for that pipe for sqlite to write to ? Your perl code could then read off that pipe and compress away. No disk I/O ! (But you may need a reader thread).
What is the sound of Perl? Is it not the sound of a wall that people have stopped banging their heads against?
-Larry Wall, 1992
Comment on Re: SQLite in memory database to scalar