[docs] Should say 'REAL' not 'FLOAT' as the SQLite datatype in 11.13.1 of sqlite3.

[Richard Kelsall]

Hello Python Docs,


TLDR: I think it should probably say 'REAL' not 'FLOAT' as the SQLite
       datatype in 11.13.1 of sqlite3.


I am reading the sqlite3 page

http://docs.python.org/2/library/sqlite3.html

for Python v2.7.5. It says in 11.13.1:

"SQLite natively supports only the types TEXT, INTEGER, FLOAT, BLOB and
NULL."

This made me wonder, is this a double or single FLOAT? (I have not used
this database or this Python module before.) And I looked in the SQLite
documentation here

http://sqlite.org/datatype3.html

This says that SQLite version 3 uses an 8 byte (i.e. double) float and
has this as type REAL. So I go back to the python page thinking maybe
this is an earlier version of SQLite - maybe Python 2 provides SQLite 2
for backwards compatibility and the module name 'sqlite3' does not
follow the SQLite version number for some reason. I cannot see on this
page mention of what version of SQLite this module provides, maybe I
missed that? But I see in 11.13.5.1:

"SQLite natively supports the following types: NULL, INTEGER, REAL,
TEXT, BLOB."

So this internal contradiction makes me think section 11.13.1 is
incorrect.

I feel posting to this public list, of unknown proportions, may
be a rather loud way of reporting such a minor problem, but the
documentation page seems to ask me to do this. A wiki might have
been an easier and less noisy way to suggest corrections. I expect
many people would not go to the trouble of emailing a public mailing
list to get a detail like this corrected and that there are many
similar bugs which are found but not immediately reported for this
reason.


Richard.