SQLite is quite SQL compliant

[Philip Semanchuk]

On Oct 2, 2010, at 6:58 PM, Tim Chase wrote:

> On 10/02/10 17:06, Seebs wrote:
>> On 2010-10-02, Ravi<ra.ravi.rav at gmail.com>  wrote:
>>> The documentation of the sqlite module at
>>> http://docs.python.org/library/sqlite3.html says:
>> 
>>> "...allows accessing the database using a nonstandard
>>> variant of the SQL..."
>> 
>> I would agree that the word "nonstandard" seems to be a little
>> strong and discouraging.  sqlite is a source of joy, a small
>> bright point of decent and functional software in a world full
>> of misbehaving crap.  While it does omit a few bits of SQL
>> functionality, I'd call it perhaps a "slightly incomplete
>> implementation" rather than a "nonstandard variant".
> 
> In my experience, it might be better phrased as "non-standard (but more adherent to standards than Microsoft SQL-Server or MySQL) variant of SQL". :-)
> 
> I mean really...does *any* RDBMS actually adhere to ANSI SQL?

That's what I was thinking. Most of them achieve 90 - 98% and implement their own extra 10% of non-standard extensions. One just has to hope that the bits one needs are not in the missing 2-10%.

I agree with the OP that the Python doc description of SQLite, while factually correct, seems a bit severe.

Cheers
Philip