Possible to do Connect Caching? connect, pull, wait 30secs, pull again...

2007-09-18 Thread Ow Mun Heng
Current script does this in sequence. connect pull data based on select copy/import into PG wait 30 secs connect again. I've turned on connection logging in PG and I noticed that I keep seeing LOG : connection received statuses. Which means that the script is connecting to the server every

Re: Looking for a good explanation of select function in perl dbi

2007-09-18 Thread Martin Evans
Scott Mohnkern wrote: Well, I've figured out how to put data into a sqlite database. I can extract data from the command line, however, for the life of me, I just can't find any good documentation on using Select. What I'm trying to do: SELECT name, size FROM filelist where uid=given value