SQLite is quite SQL compliant

Tim Chase python.list at tim.thechases.com
Sun Oct 3 00:58:44 CEST 2010


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?

-tkc






More information about the Python-list mailing list