Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://64757]
help
Chatterbox?
[marto]: Rocks (YouTubes warning)
[Corion]: Your Mother: Better than Roc hunting, I guess :)
LanX WTF. Gernany beat Canada in ice hockey
[LanX]: Not fair ... I'm totally ignoring the doping games...
[Corion]: Huh? That's weird indeed... Also, I thought that the olympic games were over already, but obviously not ;)
[choroba]: And we lost to unknown sportspersons with no official dresses
[choroba]: Russia didn't send them officially, they're on vacation in Korea
[LanX]: no that was Syria! ;-)
[LanX]: And the reason is: The world’s best players aren’t at this year’s Games after the NHL stopped its athletes from leaving in the middle of the season. ... LOL
[LanX]: horoba: you like ice hockey?

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (9)
As of 2018-02-23 16:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    When it is dark outside I am happiest to see ...














    Results (303 votes). Check out past polls.

    Notices?