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

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
  • Comment on Re: Re: Re: DBI modules for database representation in plain files

Replies are listed 'Best First'.
Re: Re: Re: Re: DBI modules for database representation in plain files
by davido (Cardinal) on Feb 25, 2004 at 17:21 UTC
    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]
        Nor is "ALTER TABLE"... I have used that sometimes when some new data needs to be added to a table...
[reply]
Re: Re: Re: Re: DBI modules for database representation in plain files
by Anonymous Monk on Feb 25, 2004 at 17:36 UTC
[reply]

In Section Seekers of Perl Wisdom