SQLite is quite SQL compliant

[Antoine Pitrou]

On Sat, 2 Oct 2010 19:13:11 -0400
Philip Semanchuk <philip at semanchuk.com> wrote:
> 
> 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.

You can open an issue at http://bugs.python.org

Regards

Antoine.