RE: Mysql over HTTP

Hi Daniel

"and you could still use a mini-client with HTTP communication to make this
happen while using the server-side to deal with REAL database stuff (the
important work). In fact, you don't need to convert anything, you could just
write an app that make queries, send it to a PHP page that would process and
return stuff and parse a HTML, XML, CSV, whatever, return from the PHP
simple page" < now THAT is an EXCELLENT idea!!

Could have the client app just call a php page with for example
http://www.myserver.com/myphp.php?proc=procname&param1=value1&param2=value2 
Or maybe in the content of the request so that its not seen by all probably
encrypted ie data=fdsjkhsfsdfsidfyr4ryt8wdgh8ifdhw8fiog3 which translates to
the above

Then the page calls the mysql stored procedure splashes the results into the
content in xml or whatever that the client app can load into memory datasets
and process; to keep the php page simple.

GENIOUS

Want to share in the profits?  :)

Thanks again.

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

On 4/7/06, Jangita <[email protected]> wrote:
> 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 :)

Yes you could, it would be better than most HTTP tunelling software in
the market, in fact, you'll drive most admins crazy with that, as your
app could possibly produce a risky environment on any company that
allow Internet surfing, you could install the server at home and
virtually use any app using the client and connecting with your home
computer... Sounds like a dream for users and a nightmare for
admins...

Stuff like ActiveX can be used to download and run mini-apps to
provide what you want (popups, notifiers, icons and sounds), and you
could still use a mini-client with HTTP communication to make this
happen while using the server-side to deal with REAL database stuff
(the important work). In fact, you don't need to convert anything, you
could just write an app that make queries, send it to a PHP page that
would process and return stuff and parse a HTML, XML, CSV, whatever,
return from the PHP simple page.

Delphi can be used to share a session opened (and even authenticated)
from the web using the browser, I remember an app that would do that,
just don't know if its written in Delphi, but it sure could be,
Audiogalaxy, check it out: http://www.audiogalaxy.com/

There are millions of options for Delphi way better than what you
initially wanted to do, althought you could get a LOT of profit from
writting something like that and selling it... It can be more
complicated than it sound.

--
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]