DBI::DatabaseHandl#columns

ruby-talk
1

Can any one tell me if a call to DBI::DatabaseHandle#columns actually queries
the database? or is the all the ColumnInfo stored as soon as a connection is
made?

i’m extending DatabaseHandle a touch and i need meta info for the methods i’m
adding. i certainly don’t want the database to be queried every time one of
these methods is called, so i’ll cache all the ColumnInfo myself if need be,
but i don’t know if i need to.

thanks,
transami

2

The source indicates that this is the case for the Oracle driver. I
didn’t check any others.

Gavin

···

On Wednesday, January 1, 2003, 4:34:40 PM, Tom wrote:

Can any one tell me if a call to DBI::DatabaseHandle#columns actually queries
the database? or is the all the ColumnInfo stored as soon as a connection is
made?

3

thanks much Gavin!

by “is the case” i take it you mean that in queries. so i’ll assume it is the
case for all of them and cache the ColumnInfo myself. correct me if i misread
you.

happy new year,
transami

···

On Wednesday 01 January 2003 12:11 am, Gavin Sinclair wrote:

On Wednesday, January 1, 2003, 4:34:40 PM, Tom wrote:

Can any one tell me if a call to DBI::DatabaseHandle#columns actually
queries the database? or is the all the ColumnInfo stored as soon as a
connection is made?

The source indicates that this is the case for the Oracle driver. I
didn’t check any others.

Gavin

4

thanks much Gavin!

by “is the case” i take it you mean that in queries. so i’ll assume it is the
case for all of them and cache the ColumnInfo myself. correct me if i misread
you.

No correction necesary.

happy new year,
transami

Same to you!
Gavin

···

On Wednesday, January 1, 2003, 6:19:25 PM, Tom wrote: