Re^2: Accessing SQLite databases within ZIP files

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 (Archbishop) 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).	[reply] [d/l] [select]
Re^4: Accessing SQLite databases within ZIP files by AppleFritter (Vicar) on Oct 02, 2017 at 12:42 UTC
Ah, thanks again -- I probably would've missed that.	[reply]

In Section Seekers of Perl Wisdom