Select Code to Download

Select or download this

SQL - trace SQL statements executed
      (not yet implemented in DBI but implemented in some DBDs)

Select or download this

$ sqlite3 pm_11137916_anon
SQLite version 3.34.0 2020-12-01 16:14:00
...
5|Jupiter|gas
9|Pluto|dwarf
sqlite>

Select or download this

#!/usr/bin/env perl

...
my $dbh = DBI->connect('dbi:SQLite:dbname=pm_11137916_anon');

print join('|', @$_), "\n" for $dbh->selectall_array('select * from Pl
+anet');

Select or download this

$ ./trace_none.pl
3|Earth|rock
5|Jupiter|gas
9|Pluto|dwarf

Select or download this

$ ls -al *.out
-rw-r--r-- 1 ken None  1839 Oct 24 03:50 trace_dbi_1.out
...
-rw-r--r-- 1 ken None  6570 Oct 24 03:45 trace_dbi_4_sql.out
-rw-r--r-- 1 ken None 10574 Oct 24 04:02 trace_dbi_5.out
-rw-r--r-- 1 ken None 10632 Oct 24 04:03 trace_dbi_5_sql.out