[smolder-devel] sqlite binary dependency

[Michael P. <mp...@pl...>]

The only reason we bundle the full sqlite binary with smolder is because we use
the .dump command to get the full database dump. I asked Matt Sargeant if he
could expose this functionality in DBD::SQLite. He pointed out that it's only
implemented in the CLI binary, but suggested I look at it's code and translate
it to Perl. So I did.

It was pretty easy once I figured out that there's a table named sqlite_master
that holds all the meta data for the database. It even holds the full table
creation SQL, which makes extracting that really easy.

So I've committed those changes to svn and completely removed the sqlite src
only using DBD::SQLite. All tests are passing and the dump in the backup looks
good too. Please try it out.

Mark, Sorry about the recent work you did to make the sqlite binary build on
freebsd. It's now obsolete :)

-- 
Michael Peters
Developer
Plus Three, LP