Transfer a in-memory SQLite database to disk

saumitra121 has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I am creating a in-memory SQLite database using syntax below:

$dbh = DBI->connect('dbi:SQLite:dbname=:memory:');
[download]

Then I am inserting some data in this db. Now I want to write this db on disk.

I am familiar with SQLite ATTACH database command, but i only know how to use it in SQLite shell. How can I do this in perl?

Comment on Transfer a in-memory SQLite database to disk Download Code

Replies are listed 'Best First'.
Re: Transfer a in-memory SQLite database to disk by dsheroh (Monsignor) on Jul 03, 2012 at 10:57 UTC
No need to mess with ATTACH. DBD::SQLite provides an `sqlite_backup_to_file` method. (And, to respond to the earlier "shouldn't you just be creating the db on disk in the first place?" comment, I know of this method thanks to a game I was working on that ran from an in-memory database and periodically checkpointed itself to disk.)	[reply] [d/l]
Re^2: Transfer a in-memory SQLite database to disk by saumitra121 (Novice) on Jul 03, 2012 at 12:59 UTC
thanks...that's exactly what I was looking for. For future visitors...below is the syntax to backup a in-memory database to disk. `$dbh = DBI->connect('dbi:SQLite:dbname=:memory:'); .... .... do something .... $dbh->sqlite_backup_to_file($filename);` [download]	[reply] [d/l]
Re^2: Transfer a in-memory SQLite database to disk by Anonymous Monk on Jul 03, 2012 at 11:04 UTC
Neato :) JIC , `grep -ri attach DBD-SQLite-1.37 </t>` `t/16_column_info.t 31:# 3. Attach a memory database 32:ok( $dbh->do('ATTACH DATABASE ":memory:" AS db3'), 'ATTACH DATABASE + ":memory:" AS db3' ); 34:# 4. Create a table on the attached database t/35_table_info.t 55:# Attach a memory database 56:ok( $dbh->do('ATTACH DATABASE ":memory:" AS db3'), 'ATTACH DATABASE + ":memory:" AS db3' ); 58:# Create a table on the attached database 94:# Create another table "one" on the attached database` `[download]`	[reply] [d/l]
Re: Transfer a in-memory SQLite database to disk by Anonymous Monk on Jul 03, 2012 at 10:49 UTC
I am familiar with SQLite ATTACH database command, but i only know how to use it in SQLite shell. How can I do this in perl? I don't know but I have some ideas :) First I would grep DBD-SQLite source for ATTACH	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.