http://qs1969.pair.com?node_id=146438


in reply to DBI::SQLite

OK, it's now on CPAN.

I've ported over DBD::CSV's nice test suite (which was designed as a generic DBD test suite), and managed to get all relevant tests to pass. It's also about 10 to 30 times faster than DBD::CSV for inserts/updates/selects, though please test that for yourself before taking my word for it.

So download it, play with it, and let me know how you get on. It probably leaks memory here and there - I haven't done any tests on leaks yet. But overall it looks fairly stable. I haven't done *any* multiple server's connecting to it tests though - I'd certainly welcome testing in that area.

Replies are listed 'Best First'.
Re: Re: DBI::SQLite
by theguvnor (Chaplain) on Feb 20, 2002 at 00:43 UTC
    Wow.. as of 5:39 on Feb 19 the author warned not to download due to instability, but by 11:49 the same day was fixed and loaded to CPAN. Are you trying to set a record Matts? :^) Can't wait to take a look!!! This might just cure what ails me!

    ..Guv

      Those who know me know I'm not a real human being. Just call me dolly.

      Seriously though, I get wierd withdrawl symptoms if I don't release something to CPAN every now and then. I'm now up to 46 modules on CPAN. Wow, even I didn't know I had so many until I just counted.

Re: Re: DBI::SQLite
by $code or die (Deacon) on Feb 20, 2002 at 13:29 UTC

    Great! I am writing an app that makes heavy use of a database and was looking at DBD::Sprite and DBD::CSV and friends for use in my test scripts. DBD::SQLite looks perfect and it's fast too. I don't mean to suck up too much in one message, but it also gives me a perfect excuse to use DBIx::AnyDBD :)

    ___ Simon Flack ($code or die)
    $,=reverse'"ro_';s,$,\$,;s,$,lc ref sub{},e;$,
    =~y'_"' ';eval"die";print $_,lc substr$@,0,3;