Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re: Paradox Database

by coolmichael (Deacon)
on Mar 15, 2001 at 23:28 UTC ( #64757=note: print w/replies, xml ) Need Help??

in reply to Paradox Database

Ok. I've been thinking about this long and hard. The plan is to do the following once a night (at midnight, when it's likely that nobody will be using the database):

  1. On the local computer, use Perl and ODBC to copy the data out of the four tables in the database and export to CSV
  2. Compress the CSV file with Compress::Bzip2 (if it exists. I haven't looked yet)
  3. Upload the file to the web server with FTP.
  4. use telnet to connect to the webserver and decompress the file.

I'll write some scripts to query the database on the web server with DBD::CSV. Unfortunately, the people who run the server won't install SSH, or MySQL or Postgresql. It's really getting quite frustrating. I think I'll just start my own web server in my office.

What do the monks think? I know that telnet and ftp aren't the best protocols to use, but I don't have much choice. The webserver is in another room in the same building, so I'm not too worried about passwords.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://64757]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (2)
As of 2018-04-23 01:53 GMT
Find Nodes?
    Voting Booth?