Sqlite3 backend does not support describeTable

[jgoerzen]

http://software.complete.org/software/issues/show/127

Added by Gour D 2008-12-31

!

While reading database chapter in RWH I've come across the following sentence: "Sqlite3, for instance, does not support describeResult or describeTable as of this writing." and after building 1.1.6 I experienced the exception from the Subject line.

However, after raising the point in #sqlite, I got the following url: http://www.sqlite.org/c3ref/table_column_metadata.html so I'm curious whether it is really lack of support in sqlite3 backend or sqlite3 does not provide adequate support for 'describeTable' ?

Sincerely,
Gour

[jgoerzen]

Updated by Braden Shepherdson 301 days ago

Comment Edit

I'm wanting to use Sqlite3 with Turbinado. I've written what I think is a correct back-end for Turbinado's ORM, using PRAGMA queries to retrieve table information and so on. Trying to generate the Models fails because describeTable is not implemented.

As far as I can tell, Turbinado only cares about the type and nullability of the columns, and doesn't care about the size or octet size. Good, because with Sqlite's dynamic typing it's unclear what those values should be. I'm going to try to implement describeTable, but will probably leave those values simply set to Nothing. That may not work for all applications, but it can't be worse than "describeTable = fail ..." .