RE: Mysql over HTTP

Maybe you should start looking into AJAX.

AJAX (Asynchronous Javascript and XML) does exactly what you are looking
for, and can use a MySQL data connector.

I currently write in AJAX and MySQL with ASP, giving applications the
richness of desktop apps on the web.

Yes, AJAX is a pain to learn, and you have to spend a lot of time wrapping
your head around the Asynchronous part (writing code variants to do one
thing while the server/client wait for other code to finish its execution).
However, when you get it right, you can do a lot with it.

Take a look into that, and please, from a data security standpoint, DO NOT
open your MySQL (or any database) to the real world by using port 80. This
is what Web Servers, functions, triggers, and stored procedures are for.

Just my $0.02...

J.R.




-----Original Message-----
From: Jangita [mailto:[email protected]] 
Sent: Friday, April 07, 2006 3:34 PM
To: [email protected]
Subject: FW: Mysql over HTTP


True, I could write a browser app with apache/mysql/php - but there are some
things that just can't be done with a browser, for example back to my chat
example; having a web based yahoo chat is fun and will work; but those
notifications at the bottom of the screen the sounds etc. Or another example
like a news popup program that sits on the system tray. You probably agree
that there is stuff that an application is better (and more secure as
doing).Frankly I'm not that good in http and php - can whip up a Delphi app
in seconds tho :) )

I'm thinking packing it well enough (the way you can download a regular file
from a website) should hide the traffic well enough;

As for the client and server conversion apps I could probably sell then :)

-----Original Message-----
From: Daniel da Veiga [mailto:[email protected]]
Sent: 07 April 2006 10:18 p
To: MySQL Win32 List
Subject: Re: Mysql over HTTP

On 4/7/06, Jangita <[email protected]> wrote:
> Hi all,
>
> It's all well and good having mysql using port 3309 (or any other port 
> for that matter); I'm writing an application that will be used by 
> loads of
users
> off the internet - so I'm expecting firewall issues.
>
> One easy way is to have the mysql traffic flow over port 80; that 
> works sometimes but not with intelligent firewalls that only allow 
> http traffic
or
> companies that have only http ports open (yes there are many of these)
>
> One method I've thought about that goes around this is to write an
interface
> that sits in-front of the mysql client and translates the mysql 
> traffic
into
> http get or put requests and use wininet.dll to send these requests to 
> the server. Since these are get and put requests I'll have to write 
> and
install
> a cgi or isapi dll on the webserver which translates these requests 
> into normal traffic and relays it to the mysql server and vice versa.
>
> This would in effect produce an environment where as long as you can
browse
> you can use the mysql client application (with iexplore because of
wininet)
> - and with linux to some extent and this will also be able to go thru 
> http proxies etc (basically anything that ie can go thru)
>
> Before I get my hands dirty; is there anything like this that exists 
> out there? I have a week leave from Monday and if there isn't well im 
> about to start writing one.
>

Is there any specific reason for you not to write your application using a
web language like PHP, Perl, ASP, .NET or anything like that?
You mentioned some weird convertions regarding TCP packages headers and
filtering, while searching for a solution to let an app access MySQL trough
firewalls and/or proxies, why not simply write a CGI or server-side based
app?

You'll have LOTS of problems while dealing with TCP/IP packaging and headers
and converting it all to HTTP traffic, besides, you'll probably load your
server a LOT while still having to write a client-side AND a server-side
conversion tool for traffic. Besides, it won't be fail proof as you can
still step in some routers that may block your converted packages.

If you want to use a browser-like app, why not let the browser do its work?

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE
Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE
BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]