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

Has anyone considered writing a database driver for an MSI file? It is a database and it does support SQL. I searched for MSI on CPAN and it returned Win32::MSI::DB but it would be nice to have the same interface as other database drivers like mysql or sqlite.

-------------------------------
by me
http://www.basgetti.com
http://www.kidlins.com

Replies are listed 'Best First'.
Re: DBD::MSI anyone?
by ghenry (Vicar) on Nov 14, 2005 at 18:54 UTC

    Go ahead ;-)

    Walking the road to enlightenment... I found a penguin and a camel on the way.....
    Fancy a yourname@perl.me.uk? Just ask!!!
      Maybe I will. I did not want to start on such a project if it was already out there or in the works. If I do, can anyone direct me to a springboard for writing DBD drivers? Is there a template that you start with or anything. I have not written one before.

      -------------------------------
      by me
      http://www.basgetti.com
      http://www.kidlins.com

        Join the DBI developers mailing-list and ask there. That's the best place to find out if anyone else is working on MSI and also a good place to go for tips on how to get started.

        -sam

        If I do, can anyone direct me to a springboard for writing DBD drivers?

        I have always found the DBD::MysqlPP source code to be very readable. I have used it many times as a reference when writing DBD::Mock.

        There are also a number of modules in DBI which can be helpful (DBI::DBD, DBD::File, etc).

        -stvn