Re: Can I write an application using Windows and Linux?

"Chris L." <chrisliapis@xxxxxxxxx> wrote:
> I am looking to write an application and am wondering exactly how to
> accomplish its automation process.
> If my perl application starts on a windows os and then accomplishes its
> goal sending its output to a mysql server on a different machine.
> Can I then grab this data on the mysql server from a completely
> seperate linux machine (running Fedora)?

Sure.

> So thats three seperate systems all networked together (Windows
> machine, Fedora Core Machine, and machine solely running MySQl Server).
> I'm almost positive (please correct me if Im wrong) the application
> will be able to store data from the Windows machine to the MySQL Sever
> machine, and the Linux machine will be able to retrieve this data once
> in the MySQL database.

I've never tried to connect to MySQL from Windows, but I'm pretty sure it
can be done.

> However, how would I automate the linux machine to automatically pick
> the data up when the windows machine is done writing its Filehandle to
> the MySQL Sever??

There are many ways to do it, from simple to very complex. What kind of
latency can you accept between when Windows is done and when Linux realizes
that Windows is done? Can there be more than one program on Windows at any
one time, writing into MySQL? Can there be more than one program on Linux
reading from MySQL?

Some examples:

1) have windows set a flag in a table in MySQL when it is done. Have Linux
daemon check the flag every 30 seconds to see if anything is read.

2) Use sockets to connect directly from perl on Windows machine to perl on
Linux machine, use this socket to tell linux when windows is done.

3) Rather than having a always running daemon on linus, Use some kind of
telnet or ssh module to have windows log onto linux and kick off the linux
perl program when it is done.

4) use MySQL's lock server to coordinate the behaviour of the Windows and
Linux machines.

Xho

--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB
.

Relevant Pages

  • Re: free database server for desktop application with ado.net driv
    ... > I've used MySQL on Windows since its 3.x days, ... If it works at all on linux, ... people who have problems compiling it post about it because they want their own optimizations. ...
    (microsoft.public.dotnet.languages.csharp)
  • Looking for best solution - FastCGI, ODBC, FreeTDS, MSSQL
    ... I have an application that we have developed mostly for MySQL but we want to bring it to a wider ranges of database servers. ... Our application works well on Windows and Unix-like systems (Linux) but one area we are having problems in a Windows and Linux setup. ... We have the application installed on a Linux box and MS-SQL on Windows. ...
    (comp.lang.perl.misc)
  • Re: Oracle error with swedish characters
    ... > machine was just a test to see if it was a greater perl problem. ... > works on windows i am now trying to get perl DBI to work only on linux. ... what you want to use in the system configuration, and also in the Oracle 8.1.7. ...
    (perl.dbi.users)
  • RE: Perl on Windows Server.
    ... There is a problem in coding perl in windows and using it in linux. ... Subject: Perl on Windows Server. ...
    (perl.beginners)
  • Re: Kann mysql dump nicht importieren: auto_increment Problem
    ... Auf 4.1 habe ich nur aktualisiert, weil ich hoffte, dass es mit Windows 2003 besser zusammenarbeitet - das funktioniert aber leider auch nicht. ... MySQL macht irgendwas mit der ipnat.sys, dass das restliche Problem Schwierigkeiten bekommt. ... Windows 2003 finde ich durchaus gelungen, erheblich besser als alle "Linux GUI Enterprise Server" die ich bisher gesehen habe. ... Die MySQL Software funktioniert nicht! ...
    (de.comp.datenbanken.mysql)
Loading