Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

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

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

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (6)
As of 2023-03-27 11:12 GMT
Find Nodes?
    Voting Booth?
    Which type of climate do you prefer to live in?

    Results (65 votes). Check out past polls.