Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Contributors | November 26, 2014

    Chris Faatz: IMG The Collected Poems of James Laughlin



    Fall has brought us a true gift in the publication of the massive The Collected Poems of James Laughlin, published by New Directions in an... Continue »

    spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse General- General

More copies of this ISBN

Programming the Perl DBI: Database Programming with perl

by and

Programming the Perl DBI: Database Programming with perl Cover

 

 

Excerpt

 [ Symbols ], [ A ], [ B ], [ C ], [ D ], [ E ], [ F ], [ G ], [ H ], [ I ], [ J ], [ K ], [ L ], [ M ], [ N ], [ O ], [ P ], [ Q ], [ R ], [ S ], [ T ], [ U ], [ V ], [ W ], [ X ], 

#LINK<Symbols[ Top ]>#
< comparison operator, 60
= comparison operator, 60
> comparison operator, 60
< > comparison operator, 60

#LINK<A[ Top ]>#
access-list configuration, 181-183
accessor methods, 43
ACID transaction handling, 155
Active attribute, 117, 203
active statement handles, 117
ActiveKids attribute, 120, 204
ActiveState Perl for Windows, 179
ADO (ActiveX Data Objects), 171
(see also DBD::ADO driver)
alias names, 115
AND logical operator, 62
AnyDBM_File module, 32
APIs (Application Programming Interfaces), 8, 164
archives, dbi-users mailing list, 231
array indices, 133
array references, 113, 131
arrays
associative, 32
retrieved from databases, 112
ASLaN (Ancient Sacred Landscape Network), 332
atomic fetching, 130
\%attr attribute parameter, 86, 138, 192, 197
attribute handles
case significance of names, 139
inheritance rules, 137
(see also database handles; statement handles)
AutoCommit database handle attribute, 142, 156, 191, 197, 218
available_drivers( ), 82, 198

#LINK<B[ Top ]>#
batch fetching, 131-135
Berkeley databases, 31-50
accessor methods, 43
chaining multiple values into a hash, 45-49
creating, 32-34
with DB_BTREE, 45-48
DB_BTREE format, 33
DB_HASH format, 33
DBM files and, 31-50
DB_RECNO format, 33
localized storage and retrieval, 38-40
locking, 34
packing in Perl objects, 40-43
values
deleting, 49
inserting/retrieving, 36-49
binary large object datatypes, 57, 141
bind values, 121-127, 220
data typing and, 124
execute( ), 126
input/output parameters, 125
LONG/LOB datatypes and, 153
placeholders and, 194
references, 125
specifying multiple, 121
vs. interpolated statements, 122-124
bind_col( ), 128, 226
bind_columns( ), 128, 227
binding (see bind values)
bind_param( ), 121, 125, 154, 220-222
bind_param_inout( ), 125, 222
blank-padded character columns, 141
BLOB (binary large object) datatype, 57, 141
boolean operators (see logical operators)
buffer space allocation, 141

#LINK<C[ Top ]>#
CachedKids attribute, 204
Call Level Interface, 164
cancel( ), 230
Cartesian Product, 64
cascading delete mechanisms, 72
CGI scripts, generating web pages from databases, 4
chained records, traversing, 47
CHAR character datatype, 57, 141, 148
character columns, 141
character datatype, 56
ChopBlanks attribute, 141, 205
cipher mechanism, 184-186
/clear dbish command, 176
client programs, database proxying, 177-186
CLOB (binary large object) datatype, 57
column names, aliasing, 115
commit( ), 89, 211
transaction handling, 156-159
committing data, 154
comparison operators, 60
CompatMode attribute, 204
compression, data, 183
Compress::Zlib module, 183
condition clauses, 59-64
configuration files, 181-183
/connect dbish command, 175
connect( ), 86-88, 196-198
data source names and, 82, 138
driver handles and, 80
error checking, 90-94
proxy servers, 180
connect_cached( ), 198
CPAN (Comprehensive Perl Archive Network), 179, 236
CREATE TABLE command, 75
Crypt::DES module, 184
Crypt::IDEA module, 184-186
CSV (comma-separated values), 12
(see also DBD::CSV driver)
CursorName statement handle attribute, 229
cursors, fetching operations, 111

#LINK<D[ Top ]>#
data
compression, 183
deleting, 10, 71-73, 120
delimited-field files, 20
fixed-length record files, 21
encryption, 184
fetching, 9
using DBI, 111-118
fetchrow_array( ), 112
fetchrow_arrayref( ), 113
fetchrow_hashref( ), 114
finishing early, 117
piece-by-piece, 153
printing and, 116
selectall_arrayref( ), 131, 209
selectcol_arrayref( ), 209
selectrow_array( ), 130, 208
selectrow_arrayref( ), 130
inserting, 10, 69-71, 120
delimited-field files, 16
fixed-length record files, 17
using quote( ), 97
long values, truncating, 142
marshalling modules
Data::Dumper, 8, 22-25
Storable, 8, 25-29
modifying within tables, 69-75
committing changes, 75, 156
deleting data, 71-73
inserting data, 69-71
undoing changes, 74, 157
updating data, 73
querying, 12-16
delimited-field files, 12
fixed-length record files, 14
from multiple tables, 64-68
from single tables, 59-64
using SQL, 58-69
rolling back, 154
selecting, 9, 12-16
serializing, 22, 50
storing (see data, inserting)
trailing blanks, removing, 141
truncating long values, 141, 152
updating, 10, 73, 120
delimited-field files, 17
fixed-length record files, 19
data source names, 81-84
available_drivers( ), 82
connect( ) and, 82, 138
data_sources( ), 82
name=value pairs, 82
data structures, storing complex, 50
data warehousing, 3, 55, 69
Data( ), 169
database drivers
connection syntax examples
CSV, 84
mSQL, 84
Oracle, 84
DBI, 77-79, 236
prefixes, 83, 139, 193
standard, 83
database handles, 80
atomic fetching and, 131
attributes, 142
connecting with, 138
driver-specific, 137, 139
error checking, 140
getting or setting values, 137
passing to DBI methods, 138
$dbh, 81
retrieving entity metadata, 143
database metadata, 143-146
database-independent programming interfaces, 2, 163
databases
accessing using proxying, 177-186
basic attributes, 8
Berkeley (see Berkeley databases)
committing changes, 154-157
concurrent access to, 29
connecting to, 85-88
requirements, 85
with dbish, 173-175
creating new tables, 75
cursors, 111
deleting tables, 75-76
disconnecting from, 88, 158
evolution from mainframes to workstations, 1-3
executing SQL statements, 110
extracting table information, example, 148
fetching data, 105
using DBI, 111-118
file locking, 29
flat-file (see flat-file databases)
generating dynamic views, 143-146
locking
Berkeley databases, 34
flat-file databases, 30
preparing SQL statements, 106-110
proxying, 177-186
queries, issuing simple, 105
query languages (see query languages)
quoting and escaping SQL statements, 97
relational, 53-55
result sets, 111
retrieving entity metadata, 143
rolling back changes, 154-158
schemas, 54, 144
storage managers and layers, 8
system catalogs, 143
Data::Dumper module, 8, 22-25
displaying restored data, 51
DataHash( ), 169
$data_source argument, 84, 88, 196-198
data_sources( ), 199
available_drivers( ) and, 82
driver handles and, 80
datatypes, 56-58
binary large object, 57, 141
bind values and, 124
character, 56
date, 57
LOB (large object), 151-154
LONG, 141, 151-154
numeric, 56
date datatype, 57
db database manager, 31
DB2 (see DBD::DB2 driver)
DB_BTREE storage format, 33, 45
DBD::ADO driver, 236-239
connect syntax, 238
datatypes, 238
SQL dialect, 238
DBD::CSV driver, 239-244
connect syntax, 240
datatypes, 241
driver-specific attributes, 243
SQL dialect, 242
table metadata, 243
DBD::DB2 driver, 244-252
connect syntax, 245
datatypes, 245
parameter binding, 252
SQL dialect, 250
transactions, 249
DBD::Empress driver, 252-259
connect syntax, 253
datatypes, 254
parameter binding, 258
SQL dialect, 257
transactions, 256
DBD::EmpressNet driver (see DBD::Empress driver)
DBD::Informix driver, 259-267
connect syntax, 260
datatypes, 260
SQL dialect, 264
stored procedures, 266
table metadata, 267
transactions, 264
DBD::Ingres driver, 267-273
connect syntax, 268
datatypes, 269
driver-specific attributes, 273
parameter binding, 272
SQL dialect, 271
table metadata, 273
transactions, 271
DBD::InterBase driver, 273-278
connect syntax, 274
datatypes, 275
parameter binding, 278
SQL dialect, 277
transactions, 276
DBD::mSQL driver (see DBD::mysql driver)
DBD::mysql driver, 278-291
connect syntax, 279
datatypes, 280
driver-specific attributes and methods, 289
locking, 285
parameter binding, 288
SQL dialect, 286
table metadata, 289
DBD::ODBC driver, 291-296
connect syntax, 292
datatypes, 293
SQL dialect, 295
table metadata, 296
DBD::ODBC module
vs. Win32::ODBC, 168-170
DBD::Oracle driver, 297-305
connect syntax, 298
datatypes, 298
driver-specific methods, 305
parameter binding, 304
SQL dialect, 302
stored procedures, 304
table metadata, 305
transactions, 301
DBD::Pg driver, 306-310
connect syntax, 306
datatypes, 307
driver-specific attributes, 312
parameter binding, 311
SQL dialect, 310
transactions, 310
DBD::Proxy module, 178, 180, 197
DBDs (see database drivers)
DBD::SearchServer driver, 313-318
connect syntax, 314
datatypes, 314
locking, 315
parameter binding, 317
SQL dialect, 316
DBD::Sybase driver, 318-326
connect syntax, 319
datatypes, 320
driver-specific attributes and methods, 326
parameter binding, 324
SQL dialect, 323
stored procedures, 325
transactions, 322
DBD::XBase driver, 327-331
connect syntax, 328
datatypes, 328
parameter binding, 330
SQL dialect, 329
table metadata, 331
DB_File module, 32, 51
default values, 34
using for storage, 51
using seq( ), 47
$dbh database handle, 81
$dbh variable, 197
DB_HASH storage format, 33, 45
DBI, 1
application architecture, 189
architecture, 77-79
combining with ODBC, 170
connecting to databases, 81
conventions, 190
data flow through, 78
data source names (see data source names)
database drivers, 77-79
database proxying, 177-186
downloading source code, 236
error codes, 166
error handling (see error handling)
execution tracing, 98-101
formatting output generated by tracing, 101-103
handles (see handles)
home page, 188
implementing drivers, 78
implementing SQL, 165
installing, 236
integrating databases and web sites, 108
interface rules, 192
metadata functions, 166
module, 78
naming conventions, 193
proxy architecture, 178
proxy servers (see proxy servers)
real-world uses, 4
shell program (dbish), 173-177
specification, 187-195
statement preparation data flow, 106
supporting databases, 78
synopsis, 187
transaction handling (see transaction handling)
usage summary, 190-192
utility functions (see utility functions)
utility methods (see utility methods)
using Win32::DBIODBC module, 171
DBI methods, passing attributes to, 137
DBI_AUTOPROXY environment variable, 181, 196
DBI->available_drivers( ) (see available_drivers( ))
DBI->connect( ) (see connect( ))
DBI->data_sources( ) (see data_sources( ))
DBI_DSN environment variable, 84, 139, 196
$DBI::err variable, 97, 201
$DBI::errstr variable, 97, 201
DBI::neat_list( ), 176
DBI_PASS environment variable, 197
dbiproxy script, 179, 182
DBI::ProxyServer module, 178, 181-184
$DBI::rows variable (see rows( ))
dbish (DBI shell), 173-177
command syntax, 175
issuing ad-hoc SQL statements, 175
miscellaneous commands, 177
$DBI::state variable, 97, 166, 201
DBI_TRACE environment variable, 101
DBI->trace( ) (see trace( ))
DBI->trace_msg( ) (see trace_msg( ))
DBI_USER environment variable, 197
dbi-users mailing list, 231
DBM file libraries, 9
DBM files, 31-50
accessor methods, 43
Berkeley databases and, 31-50
chaining multiple values into a hash, 45-49
creating new databases, 32-34
deleting values, 49
file descriptors, 35
hashtables, querying limitations, 44
key/value pairs, 31, 36
localized storage and retrieval, 38-40
packing in Perl objects, 40-43
storing data using join( ) or pack( ), 39
DBperl, 164
DB_RECNO storage format, 33
DDL (Data Definition Language) commands, 75
debugging (see trace( ))
delete operator, Perl, 49
DELETE SQL statement, 71
delimited fields, choosing vs. fixed-length records, 15
delimited-field files
deleting data, 20
inserting data, 16
querying data, 12
updating data, 17
delimiting characters, 12
DESC SQL statement, 68
DESTROY method, 89, 158, 211
diagnostics, error (see error diagnostics)
die( ), 90-93, 111, 118
automatic error checking, 91
used with RaiseError, 141
disconnect( ), 88, 118, 211
transaction handling, 158
distributed environments, 2
DML (Data Manipulation Language) commands, 58, 69
do( ), 120, 207
vs. prepare( ), 129
$drh driver handle, 80
Driver database handle attribute, 219
driver handles, 80
driver-specific attributes, 137
dump_results( ), 116, 227

#LINK<E[ Top ]>#
/edit dbish command, 176
Empress (see DBD::Empress driver)
encryption, 184
error checking, 89-94
automatic, 91-93
disabling, 91-92
vs. manual, 89
manual, 90-91
mixed, 93
error codes, 166
error diagnostics, 94-97
methods, 95
variables, 97
error handling, 89-97
using die( ), 90
exceptions, 90
transaction handling (example), 158-162
using warn( ), 90
eval( ), 22-25
execute( ), 108, 222
binding values and, 126
SQL statements, 111
execution tracing, 98-101
external modules, 3

#LINK<F[ Top ]>#
FAQ, 232
Fcntl package, 30
fd( ) DB_File method, 35
fetch loops, 113, 152
fetch( ), 127
(see also data, fetching)
fetchall_arrayref( ), 131-135, 224
hash reference arguments, 133
no arguments, 131
slice array reference arguments, 133
FetchRow( ), 169
fetchrow_array( ), 112, 151, 169, 223
fetchrow_arrayref( ), 113, 223
fetchrow_hashref( ), 114, 169, 224
file descriptors (DBM files), 35
finish( ), 117, 225
fixed-length record files
data storage, 39
deleting data, 21
inserting data, 17
querying data, 14
updating data, 19
fixed-length records, choosing vs. delimited fields, 15
fixed-width character columns, 141
flat files, storing complex data into, 22
flat-file databases, 8, 11-29
concurrent access to, 29
delimited-field files (see delimited-field files)
fixed-length record files (see fixed-length record files)
FLOAT numeric datatype, 56
flock( )
locking modes, 30
used with DBM files, 35
foreign keys, 65, 71
fork( ), used with InactiveDestroy, 204
/format dbish command, 176
freeze( ), 28
Fulcrum SearchServer (see DBD::SearchServer driver)

#LINK<G[ Top ]>#
garbage collector, 119
gdbm database manager, 31
GDBM_File module, 32
get_dup( ), 49
GetInfo( ), 167
Get/SetConnectOption( ), 167
Get/SetStmtOption( ), 167
GROUP BY clause, 68
GUI development toolkit (Tk), 4

#LINK<H[ Top ]>#
handles, 79-81
attributes, 136-142
child and parent, 137
database (see database handles)
driver, 80
encapsulating a connection to a database, 80
encapsulating SQL statements for execution in a database, 81
statement (see statement handles)
hash references
fetchall_arrayref( ) and, 133
retrieved from databases, 114
hash values, 33
hash variables, 32
hashtables
DBM files, querying limitations, 44
traversing chained records, 47
$h->err( ), 95, 201
$h->errstr( ), 95, 201
$h->func( ), 203
/history dbish command, 176
home page, DBI, 188
$h->state( ), 95, 166, 202
$h->trace( ), 202
$h->trace_msg( ), 202

#LINK<I[ Top ]>#
IBPerl module, 273
IN comparison operator, 61
InactiveDestroy attribute, 204
Informix (see DBD::Informix driver)
Ingres (see DBD::Ingres driver)
INSERT SQL statement, 70
INTEGER numeric datatype, 56
InterBase (see DBD::InterBase driver)
interface rules, DBI, 192
interpolated
hash lookup, 136
SQL statements, 122-124

#LINK<J[ Top ]>#
join( ), 24
storing data in DBM files, 39
joins
outer, 66
relational databases, 55

#LINK<K[ Top ]>#
key/value pairs
DBM files, 31, 36
handle attribute values, 136
Kids attribute, 120, 204

#LINK<L[ Top ]>#
layers (storage managers), 8
LIKE comparison operator, 61
LOB (large object) datatype, 151-154
logging (see trace( ))
logical operators, 61-63
precedence, 63
LONG datatype, 141, 151-154
long values, truncating, 141, 152
LongReadLen attribute, 141, 206
LOB data and, 151-153
RaiseError and, 152
LongTruncOk attribute, 141, 206
LOB data and, 151
RaiseError and, 142
looks_like_number( ) function, 103, 200
lowercase attribute names, 139

#LINK<M[ Top ]>#
mailing list, dbi-users, 231
metadata
database, 143-146
functions, ODBC, 166
statement, 146-151
methods
accessor, 43
available_drivers( ), 82, 198
bind_col( ), 128, 226
bind_columns( ), 128, 227
bind_param( ), 121, 125, 154, 220-222
bind_param_inout( ), 125, 222
cancel( ), 230
commit( ), 89, 156-159, 211
connect( ), 80, 82, 86-88, 90-94, 138, 180, 196-198
connect_cached( ), 198
data_sources( ), 80, 82, 199
die( ), 90-93, 111, 118, 141
disconnect( ), 88, 118, 158, 211
do( ), 120, 129, 207
dump_results( ), 116, 227
error diagnostic, 95
eval( ), 22-25
execute( ), 108, 126, 222
fd( ), 35
fetch( ), 127
fetchall_arrayref( ), 131-135, 224
fetchrow_array( ), 112, 151, 169, 223
fetchrow_arrayref( ), 113, 223
fetchrow_hashref( ), 114, 169, 224
finish( ), 117, 225
flock( ), 30, 35
freeze( ), 28
get_dup( ), 49
join( ), 24, 39
nfreeze( ), 28
pack( ), 24, 39, 43
ping( ), 212
prepare( ), 100, 107-110, 209
prepare_cached( ), 210
quote( ), 97, 103, 121, 217
rollback( ), 89, 157, 211
rows( ), 226
selectall_arrayref( ), 131, 209
selectcol_arrayref( ), 209
selectrow_array( ), 130, 208
selectrow_arrayref( ), 130
seq( ), 47-49
split( ), 14, 24
table_info( ), 144, 212
tables( ), 143, 213
trace( ), 99-101, 199
type_info( ), 214-217
type_info_all( ), 213
unpack( ), 15, 24, 43
utility, 97-101
warn( ), 90-93, 111, 140
MLDBM module, 50-52
mSQL (see DBD::mysql driver)
mysql (see DBD::mysql driver)

#LINK<N[ Top ]>#
Name database handle attribute, 142, 220
NAME statement handle attribute, 146, 228
NAME_lc statement handle attribute, 146, 228
NAME_uc statement handle attribute, 146, 228
naming conventions, DBI, 193
ndbm database manager, 31
NDBM_File module, 32
neat( ) function, 101-103, 200
neat_list( ) function, 101-103, 117, 200
nfreeze( ), 28
NOT logical operator, 62
NULL values, 57, 98, 194
NULLABLE statement handle attribute, 148, 229
NUMBER numeric datatype, 56
numeric testing, 103
NUM_OF_FIELDS statement handle attribute, 146, 228
NUM_OF_PARAMS statement handle attribute, 148, 228

#LINK<O[ Top ]>#
ODBC driver manager, 163, 291
ODBC drivers
implementing SQL, 165
working with DBD::ODBC module, 291
ODBC (Open Database Connectivity), 163
attributes and options, 167
combining with DBI, 170
error codes, 166
main features, 165-167
metadata functions, 166
using from Perl, 167
using standard SQL, 165
ODBC (see DBD::ODBC driver)
odbm database manager, 31
ODBM_File module, 32
O_EXLOCK flag, 35
ops pragma, 25
OR logical operator, 62
Oracle (see DBD::Oracle driver)
ORDER BY clause, 68
outer joins, 66
output columns, binding Perl variables, 127-129

#LINK<P[ Top ]>#
pack( ), 24
Perl objects and, 43
storing data in DBM files, 39
parameters (see bind values)
$password argument, 197
Perl, 3
ActiveState version, 236
using ADO, 171
binding variables to output columns, 127-129
database proxying, 177-186
datatypes, retrieving data using, 112-115
DBD::ODBC and ODBC, 167
DBI shell program (dbish), 173-177
delete operator, 49
garbage collector, 119
modules, extending functionality of, 3
Net::Daemon module, 179, 181
PIRPC module, 179, 181
signal handling, 230
string-handling capabilities, 108-110, 122
using threads, 230
web links, 232
Win32::ODBC and ODBC, 167
Perl Database Interface (see DBI)
perldoc DBI command, 187
Pg (see DBD::Pg driver)
ping( ), 212
placeholders (see bind values)
.pm files, 82
PostgresSQL (see DBD::Pg driver)
PPM (Perl Package Manager), 32, 179, 236
PRECISION statement handle attribute, 148, 229
prepare( ), 107-110, 209
execute( ) and, 108
tracing DBI execution, 100
vs. do( ), 130
prepare_cached( ), 210
primary keys, 45, 65
PrintError attribute, 140, 204
connect( ) and, 86, 197
error checking, 90-94
executing SELECT statements, 111
tracing DBI execution, 100
private_x attributes, 207
programming languages
databases, writing in, 2
Perl, 3
proxy servers, 177-186
compression, 183
configuration files, 181-183
configuring, 185
connecting to, 180
data encryption, 184-186
setting up, 179

#LINK<Q[ Top ]>#
query execution plan, 122
query languages, data functions, 9
quote( ), 97, 217
and do( ), 121
looks_like_number function( ) and, 103

#LINK<R[ Top ]>#
race conditions, 30
RaiseError attribute, 140, 205
connect( ) and, 86, 197
data fetch, finishing early, 118
error checking, 90-94
executing SELECT statements, 111
LONG/LOB data and, 152
transaction handling, 159
RDBMS (Relational Database Management Systems), 7
read-only databases, 69
REAL numeric datatype, 56
references to bind values, 125
referential hashes, 44
Relational Database Management Systems (see RDBMS)
relational databases, 53-55
Remarks field, 145
resources for further reading, xiii
result sets, 111
rollback capability, 74
rollback( ), 89, 211
transaction handling, 157
rolling back data, 154
RowCacheSize database handle attribute, 220
RowInCache statement handle attribute, 230
rows
manipulating data, 54
retrieving data from tables, 58-60
rows( ), 226
RPC::PlClient module, 184
RPC::PlServer module, 184

#LINK<S[ Top ]>#
sacred sites, charter, 332
SCALE statement handle attribute, 148, 229
schemas, 54, 144
sdbm database manager, 31
SDBM_File module, 32
SearchServer (see DBD::SearchServer driver)
security
cipher mechanism and, 184-186
Taint attribute and, 207
SELECT SQL statement, 58, 105
active statement handles, 117
dbish and, 176
executing, 111
fetching data, 115
selectall_arrayref( ), 131, 209
selectcol_arrayref( ), 209
selectrow_array( ), 130, 208
selectrow_arrayref( ), 130
seq( ), 47-49
Shared SQL Cache, 122
$SIG{_ _DIE_ _} signal handler, 92, 141
$SIG{_ _WARN_ _} signal handler, 92, 140
signal handling in Perl, 230
significant digits, 148
split( ), 14, 24
SQL Access Group, 164
SQL datatypes (see datatypes)
SQL queries, 58-69
aliasing table names, 66
condition clauses, 59-64
joining tables, 64-68
narrowing searches, 61
outer joins, 66
primary keys and foreign keys, 65
rows, retrieving, 58
simple queries, 58
SQL statements
binding parameters to, 121-127
building dynamically, 143-146
custom-built, 108-110
dbish and, 175
DELETE, 71
DESC, 68
executing, 110
INSERT, 70
interpolated, 122-124
preparing, 106-110
SELECT, 58, 105, 111, 115
transaction handling (see transaction handling)
TRUNCATE TABLE, 72
UPDATE, 73
WHERE, 60
SQL syntax, standardized, 165
Sql( ), 169
SQL-level portability, 165
SQLSTATE error indicator, 166
standard drivers, 83
statement buffer, 175
statement handles, 81
active, 117
attributes, 146-151
connecting with, 138
driver-specific, 137, 139
error checking, 140
formatting and displaying data, 146-148
getting or setting values, 137
passing to DBI methods, 138
batch fetching and, 131
creating via DBI, 107
deallocating, 119
improving performance with prepare( ) and execute( ), 129
preparing from an SQL statement, 106
$sth, 81, 119
statement metadata, 146-151
Statement statement handle attribute, 146, 229
$sth statement handle, 81, 119
Storable module, 8, 25-29
storage managers, 8
MLDBM module, 50
strings
formatting, 101-103
packing values into, 42
Perl, processing of, 3, 108-110, 122
support, 233
dbi-users mailing list, 231
Sybase (see DBD::Sybase driver)
system catalogs, 143

#LINK<T[ Top ]>#
table information, extracting, 148
/table_info dbish command, 177
table_info( ), 144, 212
TABLE_NAME field, 144
TABLE_OWNER field, 144
TABLE_QUALIFIER field, 144
tables
joining, 64-68
retrieving data, 58-60
tables( ), 143, 213
TABLE_TYPE field, 144
Taint attribute, 207
Term::Readline module, 177
Term::Readline::Gnu module, 177
Text::CSV_XS module, 240
threads, Perl and, 230
three-valued logic tables, 58
tie mechanism
initializing Berkeley databases, 33
O_EXLOCK flag, 35
tied array, 36
tied hash, 36
Tk (GUI development toolkit), 4
trace( ), 99-101, 199
argument forms, 99
handle tracing, 100
training, 233
transaction handling, 154-162
ACID properties, 155
auto-commit mechanism, 156
automatic, 156
automatic error handling (example), 158-162
disconnecting from databases, 158
forcing a commit, 157
rolling back changes, 157
types of, 156
transaction rollback capability, 74
translations, of documentation, 233
TRUNCATE TABLE SQL statement, 72
truncating long values, 141, 152
truth tables, 62
two-system commit, 161
TYPE statement handle attribute, 147, 228
type_info( ), 214-217
type_info_all( ), 213

#LINK<U[ Top ]>#
unpack( ), 15
Data::Dumper module and, 24
Perl objects and, 43
UPDATE SQL statement, 73
uppercase attribute names, 139
$username argument, 197
utility functions
numeric testing, 103
string formatting, 101-103
utility methods, 97-101
DBI execution tracing, 98-101
fetching and printing data, 116
quote handling, 97

#LINK<V[ Top ]>#
values, packing into strings, 42
VARCHAR character datatype, 57, 148
VARCHAR2 character datatype, 57

#LINK<W[ Top ]>#
Warn attribute, 203
warn( ), 90-93, 111
automatic error checking, 91
used with PrintError, 140
warranty, 233
web links
DBI, 231
DBI drivers, 236
Perl, 232
SQL, 194
WHERE SQL statement, 60
Win32::DBIODBC module, 171
Win32::ODBC module
advantages, 169
vs. DBD::ODBC, 168-170
disadvantages, 168
emulating, 171
metadata functions, 166
Win32::OLE module, using ADO from Perl, 171

#LINK<X[ Top ]>#
XBase (see DBD::XBase driver)

END

Product Details

ISBN:
9781565926998
Subtitle:
Database programming with Perl
Author:
Descartes, Alligator
Author:
Descartes, Alligator
Author:
Bunce, Tim
Publisher:
O'Reilly Media
Location:
Sebastopol, CA :
Subject:
Programming Languages - General
Subject:
Programming - General
Subject:
Computer graphics
Subject:
Computers
Subject:
Database Management - General
Subject:
Database management
Subject:
Programming Languages - CGI, Javascript, Perl, VBScript
Subject:
Perl (computer program language)
Subject:
Object-oriented programming
Subject:
Perl
Subject:
Books; Computers & Internet; Internet & World Wide Web; Scripting & Programming; Perl
Subject:
Books; Computers & Internet; Networking & OS; Operating Systems; Unix; Programming
Subject:
Perl (Computer program languag
Subject:
Programming Languages - Perl
Subject:
General-General
Subject:
Alligator Descartes;DBI;Programming Perl DBI;Tim Bunce
Subject:
CourseSmart Subject Description
Edition Number:
1st ed.
Edition Description:
Print PDF
Series:
O'Reilly Perl
Series Volume:
201693
Publication Date:
20000214
Binding:
Paperback
Language:
English
Illustrations:
Yes
Pages:
366
Dimensions:
9.19 x 7 x 0.86 in 1.28 lb

Other books you might like

  1. Programming Perl, 3rd Edition Used Trade Paper $25.00
  2. Perl Cookbook Used Trade Paper $14.95
  3. C Programming Language Ansi C 2ND... Used Trade Paper $45.00
  4. Expert C Programming
    New Trade Paper $41.25
  5. Practical RDF New Trade Paper $40.95
  6. Advanced Perl Programming 1ST Edition Used Trade Paper $9.95

Related Subjects

Computers and Internet » Computer Languages » Perl
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management
History and Social Science » Politics » General
History and Social Science » Politics » United States » Foreign Policy
History and Social Science » World History » General

Programming the Perl DBI: Database Programming with perl Used Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 366 pages O'Reilly & Associates Inc. - English 9781565926998 Reviews:
"Synopsis" by ,
Co-authord by the primary developer of DBI, this text is the first and only book on Perl and DBI and destined to be the bible for and DBI programmer. Learn how to program with DBI through extensive examples.
"Synopsis" by , The primary interface for database programming in Perl is DBI, a database-independent package that provides a consistent set of routines regardless of what database product you use--Oracle, Sybase, Ingres, Informix, you name it."Programming the Perl DBI" is coauthored by Alligator Descartes, one of the most active members of the DBI community, and by Tim Bunce, the inventor of DBI. For the uninitiated, the book explains the architecture of DBI and shows you how to write DBI-based programs. For the experienced DBI dabbler, this book explains DBI's nuances and the peculiarities of each individual DBD. This is the definitive book for database programming in Perl.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.