1. Web-enabled desktop applications
- Posted by caleb <lemeia at hotmail.com>
Mar 29, 2005
-
Last edited Mar 30, 2005
I'm interested in exploring the idea of creating a web-enabled desktop
application.
I would like to build the GUI and business logic on the desktop but have a MySQL
database backend on my web host server.
Can I use ODBC to send SQL to web host databases?
Also - should I be looking at any particular Euphoria libraries to enable
communication between the desktop and my domain server?
I know it's simpler to use a browser front-end with server-side scripting for
these kinds of things, but I'm interested in looking at a desktop solution as
well.
Regards
Caleb
2. Re: Web-enabled desktop applications
Hi Caleb,
I've been writing Euphoria apps that use MySQL (and SQLite) for a while now and
can simply say that you won't need to go down the ODBC route really.
Get the EuMySQL library from the archives and simply 'connect' to the ip address
of the host - easy and fast. You'll probably want to modify the euMySQLlib a
little to suit your needs (I had to!), but it does most of what's needed.
Currently my major tool, under development, is a fully-fledged Content
Management System for websites with MySQL (with PHP on the server) - Euphoria
works very well for this.
Using Matt's EuCOM wrapper for dropping an Internet Exploder preview window
within your app is also useful for having immediate access to browser aspects.
Altogether Euphoria combined with various of the many libraries out there gives
a clean process for web-enabled tools.
Cheers,
Dave
. .. : :: = == == = :: : .. .
Server-Side DB driven web sites,
Software Development
and part-time games developer
contact dave_p at purpletiger dot com
Website http://www.purpletiger.com
. .. : :: = == == = :: : .. .
3. Re: Web-enabled desktop applications
Dave Probert wrote:
> Using Matt's EuCOM wrapper for dropping an Internet Exploder preview window
> within
> your app is also useful for having immediate access to browser aspects.
Eeek! Internet Exploder used inside an app??????
Regards, Alexander Toresson
4. Re: Web-enabled desktop applications
Alexander Toresson wrote:
>
> Dave Probert wrote:
> > Using Matt's EuCOM wrapper for dropping an Internet Exploder preview window
> > within
> > your app is also useful for having immediate access to browser aspects.
>
> Eeek! Internet Exploder used inside an app??????
>
> Regards, Alexander Toresson
>
*puts on his Priest outfit, draws a circle around the program, and
pentacle, and says the magic words* OUT WITH YOU, DEMON SPAWN OF ALL EVIL
SPIRITS!
Mario Steele
http://enchantedblade.trilake.net
Attaining World Dominiation, one byte at a time...
5. Re: Web-enabled desktop applications
Thanks for that Dave - it sounds encouraging.
I guess one of the reasons I was thinking about using ODBC was that I should be
able to easily configure the application to work with a web host on MySQL and
then change it to work with SQL Server within a LAN without having to recode.
I've never done these things before so I'm not sure how idiotic I'm being.
I believe the MySQL library you're talking about is EMySQLib.ew yes? Or have I
got this wrong?
I have not yet been able to run the simple connect to the test MySQL database I
set up on my web host yet. I keep getting -
"Status: Host 'my host information' is not allowed to connect to this MySQL
server."
I'll have to post a message or ten in my web host providers forum and see if
someone can show me the error of my ways.
Regards
Caleb
6. Re: Web-enabled desktop applications
- Posted by Dave Probert <zingo at purpletiger.com>
Mar 30, 2005
-
Last edited Mar 31, 2005
Hi Caleb,
Yes, EMySQLib.ew is the one I was referring to.
As to the connect error, it could be that the host % (percent) is not set up on
the server MySQL database admin for that database. The % host is one for all
hosts outside the supplied domains for prescribed users.
In other words, when you connect it looks for
eg. user[caleb] on host[IP_address] for db[mydatabase]
where the host would be your machine's IP address (which on a dialup or adsl
might change whenever you connect!)
This problem means that a host set up at the server for % covers all IP
addresses and then only the Username and Password control the access.
Web pages using server-side scripting are considered as 'localhost' to MySQL on
that server, so they automatically get access.
For remote access the IP address is used and therefore you need the % option
configured.
That all sounds kinda complicated, but it isn't really - either use whatever
control panel application on your web server to manage your MySQL and set us the
Host % against your database or talk to your server managers to set it up for
you.
If there's anything else I can help with then please post a note or email me
directly.
Note to all Internet Exploder Non-Worshippers out there - can I join you :)
Anyone know how to do a similar thing (embed in Eu app) with Firefox?????
(Please!!!!!)
Cheers,
Dave
. .. : :: = == == = :: : .. .
Server-Side DB driven web sites,
Software Development
and part-time games developer (but mainly player :))
contact dave_p at purpletiger dot com
. .. : :: = == == = :: : .. .
