SQLite is quite SQL compliant
Tim Chase
python.list at tim.thechases.com
Sat Oct 2 18:58:44 EDT 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