Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

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.


Comment on Re: Paradox Database

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (8)
As of 2014-09-30 11:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (364 votes), past polls