Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
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 drinking their drinks and smoking their pipes about the Monastery: (7)
As of 2014-07-10 23:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (217 votes), past polls