how to attach another sqlite db to $dbh with Perl dbd-sqlite

Question

How to attach several sqlite databases into a single $dbh in Perl? In the command line I can do attach in the interactive sqlite3 rpel, how about with dbd-sqlite in Perl?

Sorry if this has been already answer here, perlmonks or similar but was not able to find a proper answer.

Why do you think you can load multiple databases at once with one instance of dbd-sqlite ? — Prix
– Prix, Commented Jul 15, 2013 at 17:54
I don't know. I was hopping that dbd-sql had implemented something like attach but I have not seen anything in the docs and I wanted to be sure I was not missing something obvious. — Pablo Marin-Garcia
– Pablo Marin-Garcia, Commented Jul 15, 2013 at 18:03
I see, well you can also look at the source at CPAN as well and I have not seen that possibility so you would have to create multiple instances and compare with each other. — Prix
– Prix, Commented Jul 15, 2013 at 18:04
In case there is no solution with dbd-sqlite I can always use stackoverflow.com/questions/11733581/… recipe and dump all dbs into one. The tables have different names. — Pablo Marin-Garcia
– Pablo Marin-Garcia, Commented Jul 15, 2013 at 18:10

daxim · Accepted Answer · 2013-07-15 18:33:56Z

5

do executes arbitrary SQL statements.

$dbh->do('attach foobar as foobar');

foobar's tables are then queryable.

answered Jul 15, 2013 at 18:33

daxim

39.3k4 gold badges71 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joseph Martin · Accepted Answer · 2015-12-16 16:04:57Z

2

You can even do this:

use DBI;
my $dbfile1 = 'test1.db'; # will be `main`
my $dbfile2 = 'test2.db'; # will attach as `other`
my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile1","","") or die "dbh";
$dbh->do('attach ? as ?', undef, $dbfile2, 'other') or die "attach";

answered Dec 16, 2015 at 16:04

Joseph Martin

1211 silver badge5 bronze badges

Collectives™ on Stack Overflow

how to attach another sqlite db to $dbh with Perl dbd-sqlite

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related