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....@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 -- http://mail.python.org/mailman/listinfo/python-list
