Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: DBD::Pg INSERT enlightenment

by penguinfuz (Pilgrim)
on Feb 06, 2001 at 10:14 UTC ( [id://56627]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: DBD::Pg INSERT enlightenment
in thread DBD::Pg INSERT enlightenment

I've slightly modified the code you posted for the array, and it's working pretty well. Here's what I've done...

print "\nEnter a brief description: "; my $desc = join('', <STDIN>); my $pg_array = join ('', map {split ' '} $desc); $pg_array =~ s/, $//; $pg_array = "{$pg_array}"; print "$pg_array\n\n"; $sth = $dbh->prepare(" INSERT INTO $tbl_name (product_id, model_number, description) VALUES (?, ?, ?) "); $sth->execute($prod_id, $mod_num, $pg_array); $sth->finish();

I really cannot afford seperate columns, as the description will contain more than just CPU and MHZ. My plan is to use only ONE table for CPU, RAM, HD, Monitor, case, NIC, MB, and videocard.

Thanks.

Replies are listed 'Best First'.
Re: Re: DBD::Pg INSERT enlightenment
by beppu (Hermit) on Feb 06, 2001 at 12:30 UTC
    I really cannot afford seperate columns, as the description will contain more than just CPU and MHZ. My plan is to use only ONE table for CPU, RAM, HD, Monitor, case, NIC, MB, and videocard.

    Then each of those gets their own column, too. You've got to believe me. Make sparing use of PostgreSQL's array capabilities, because you're missing the point of relational databases if you use them too much.

    If you want to discuss this more, email me at beppu@lineo.com. Meanwhile, I suggest you check out SQL for Web Nerds over at ArsDigita. It's a very nice introductory text.

    They also have the classic SICP in its entirety over at ArsDigita if you're interested.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://56627]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chanting in the Monastery: (5)
As of 2024-03-29 13:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found