[DBD-SQLite] DBD::SQLite table introspection

Andrew Rodland andrew at cleverdomain.org
Wed May 19 06:46:26 GMT 2010

Recently I've been working on the DBIx::Class::Schema::Loader support for 
SQLite -- specifically, removing all of the "parse SQL from sqlite_master" 
hacks from it. Things have been going quite well, but the heuristic I have for 
determining whether a column is an autoinc PK is fragile.

I see that SQLite provides a definitive answer to the question of whether a 
column is autoinc via the sqlite3_table_column_metadata API function, and 
DBD::SQLite already makes use of this function to provide the NULLABLE sth 
attribute. Does adding a private statement handle attribute that 
returns the autoinc information from the same API function sound like a 
reasonable solution to my problem?

Many thanks,

Andrew Rodland (IRC: hobbs)

More information about the DBD-SQLite mailing list