1

I'm trying to dump my sqlite 3 file so that I can import into perl at a later stage and write a script that will output the table contents. How can I do this?

Thank you.

MVFORLYFE
  • 21
  • 2
  • See **SQLite Programming With Perl** at http://www.youtube.com/watch?v=szJFD_ejKV8 – Ωmega Apr 03 '12 at 14:55
  • Have a look at http://stackoverflow.com/a/199221/162833. – d5e5 Apr 03 '12 at 14:58
  • Why are you trying to do this? If we knew the reason, we might have a good suggestion. You have the [XY Problem](http://meta.stackexchange.com/questions/66377/what-is-the-xy-problem). :) – brian d foy Apr 03 '12 at 17:05
  • Sorry, I should've explained better. Basically, in Firefox v3, you can delete things like cookies/history and it the data will remain inside the SQLite file itself which you can view in a hex editor. I am trying to use perl to see if I can see this deleted data by somehow figuring out how to write a script that will do this for me. – MVFORLYFE Apr 09 '12 at 20:06

1 Answers1

2

Why dump and import when you can just 'read' sqlite/sqlite3 files in Perl?

It's on CPAN:

http://metacpan.org/pod/PAB3::DB::Driver::Sqlite3

http://metacpan.org/pod/DBD::SQLite

szabgab
  • 6,202
  • 11
  • 50
  • 64
ArjunShankar
  • 23,020
  • 5
  • 61
  • 83