Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^2: Accessing SQLite databases within ZIP files

by AppleFritter (Vicar)
on Oct 01, 2017 at 18:00 UTC ( #1200482=note: print w/replies, xml ) Need Help??


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 (Chancellor) 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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1200482]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (5)
As of 2020-05-25 06:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    If programming languages were movie genres, Perl would be:















    Results (143 votes). Check out past polls.

    Notices?