Re^2: Accessing SQLite databases within ZIP files


Keep It Simple, Stupid
	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 (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

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://1200482]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others browsing the Monastery: (6)

As of 2023-03-27 11:12 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?