in reply to Re: Accessing SQLite databases within ZIP files
in thread Accessing SQLite databases within ZIP files

but I think you'll have to extract the file to disk.

Looks like I will, going by the answers so far. Oh well, I suppose there's worse! Thanks for the pointer re: File::Temp and tempdir's's CLEANUP flag, that sounds mighty useful.

(FWIW, performance wouldn't have mattered much. Famous last words, I know, but I really just need to run one SELECT query against this DB in order to extract the information I need.)

  • Comment on Re^2: Accessing SQLite databases within ZIP files

Replies are listed 'Best First'.
Re^3: Accessing SQLite databases within ZIP files
by haukex (Bishop) on Oct 02, 2017 at 06:58 UTC
    tempdir's CLEANUP flag

    Since elsewhere in this thread you wrote this needs to work on Windows, let me quote "DBD::SQLite And File::Temp" from the DBD::SQLite documentation:

    CLEANUP may not work unless a database is disconnected

    When you set CLEANUP option to true when you create a temporary directory with tempdir() or newdir(), you may have to disconnect databases explicitly before the temporary directory is gone (notably under MS Windows).

      Ah, thanks again -- I probably would've missed that.