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

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

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

Replies are listed 'Best First'.
Re: Re: Re: Re: Re: DBI modules for database representation in plain files
by jZed (Prior) on Feb 25, 2004 at 19:26 UTC
    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".

      Nor is "ALTER TABLE"... I have used that sometimes when some new data needs to be added to a table...