The Marriage of DBI and ODBC
The
DBI has been strongly influenced by ODBC
and the international standards that lie behind it (X/Open SQL CLI
and ISO/IEC 9075-3:1995 SQL/CLI). The development of the
DBD::ODBC module has given the DBI a more solid
footing in the world of ODBC.
The DBI specification naturally evolves over time. The ODBC standard
gives it a standards-based framework to build around. So, for
example, if a method to return information about the datatypes
supported by a database needs to be added, then following the proven
standard function that makes much more sense than defining a new way.
Thus, the DBI type_info method is modeled very
closely on the GetTypeInfo ODBC function.
As the DBI and DBD::ODBC modules evolve,
they’ll naturally move closer together. As there are two
excellent portable Open Source driver managers available,[64] the DBD::ODBC module should become as
portable as DBI itself. At that point, it may well make sense to
combine the two.
[64] It’s available from the FreeODBC project at: http://users.ids.net/~bjepson/FreeODBC/.