Обсуждение: General question (C++ interfacing to PostgreSQL)

I'm just curious about what the standard practice for creating 
PgConnection/PgDatabase objects should be. 

First, I'm not quite sure when or how should I use PgDatabase 
(in the simple tests that I've done so far, I use only PgConnection). 

As for the PgConnection, I'm wondering if I should create them 
as local variables whenever I need to execute a selcect or 
insert/update/delete statement, or if it is a better idea to 
keep a unique (possibly global) PgConnection object and keep 
asking it to Exec SQL statements. 

Is there any considerable overhead when creating PgConnection 
instances?  Are multiple instances asking for trouble? 


There's probably a tutorial where these guidelines are?  I 
haven't been able to find it, but if someone points me to 
such tutorial, I'd be very grateful! 

Oh, another thing...  How can I prevent output from being 
sent to stdout whenever I execute a SELECT statement?  I'd 
like to get the data, and not send it to stdout -- however, 
when I do  connect.Exec ("select ..... "), I get the results 
of the SQL statement displayed without the program cout'ing 
them explicitly... 

Thanks!

Carlos
--

On Sun, 22 Apr 2001, Carlos Moreno wrote:

> First, I'm not quite sure when or how should I use PgDatabase 
> (in the simple tests that I've done so far, I use only PgConnection). 

Use whichever provides functionality you need--it's as simple as that.  If
you want to actually read values from the database (and I guess at some point
you will), use PgDatabase.

The current class hierarchy is a little confusing, and not always for very
good reasons.  So expect them to change radically in the not-too-far future.


Jeroen