in reply to Re: DBI modules for database representation in plain files
in thread DBI modules for database representation in plain files

I second this. I use DBD::SQLite with DBI all the time, and have found it to be an excellent solution in every application I've had for it. Certanly there will be times that more traditional databases are required, but I haven't found that time yet.

From the DBD::SQLite POD:

SQLite is fast, very fast.

It is! It is also happens to be a complete RDBMS database engine wrapped in one convenient module.


Dave

  • Comment on Re: Re: DBI modules for database representation in plain files

Replies are listed 'Best First'.
Re: Re: Re: DBI modules for database representation in plain files
by Limbic~Region (Chancellor) on Feb 25, 2004 at 17:01 UTC
    davido,
    It is also happens to be a complete RDBMS database engine

    That is a bit misleading since some people would argue that the omitted SQL Features make it incomplete. Since I have very limited db experience, I am not going to make that case. I like SQLite very much and have used it on at least 3 projects now. I also here there may be locking issues with too many concurrent updates. I guess someone deciding what to use knows their own requirements well enough to know if SQLite is right for the job.

    Cheers - L~R
[reply]
      If it's misleading I didn't intend it to be. The POD for SQLite states, "SQLite is a public domain RDBMS database engine..."

      The POD also states that it "Implements a large subset of SQL92", and is "A complete DB in a single disk file..."

      So you're right that only a "large subset" is implemented, but I think that's probably the case with many individual SQL implementations.

      What I meant by "complete" is that in one package you have just about everything you need. I didn't mean that its SQL implementation supports everything in the SQL92 spec. However, my practical usage has yet to encounter a need for those few edge cases of unsupported SQL features.


      Dave

[reply]
        I agree that SQLite is fantastic and useful for many many things.

        my practical usage has yet to encounter a need for those few edge cases of unsupported SQL features

        But I wouldn't call column constraints (which SQLite lacks) "an eddge case".

[reply]
[reply]

In Section Seekers of Perl Wisdom