Remote database access: How?

Bernard Devlin bdrunrev at gmail.com
Mon Jun 8 09:58:35 EDT 2009


Tereza, By going down the cgi route, you may have more complexity and
maybe performance issues.  The rev cgi app will be returning your data
to your client app via some kind of structuring (xml, json, csv, etc).
 Effectively, the cgi app is acting as an application server, even if
it is only the translation layer between SQL and the structured data.

You could connect directly to the SQL server with few security worries
if your app and the server will run on the same LAN (or if they
connect via some kind of VPN/secure tunnel).

Bernard

On Mon, Jun 8, 2009 at 5:17 AM, Tereza Snyder<tereza at califex.com> wrote:
> Hi All,
>
> I told my client Rev could do it...and now I'm stuck! Here's what my app
> needs to do:
>
> 1) user downloads Rev app from web page
> 2) user runs app
> 3) user types username and password
> 4) app looks up username/password in remote MySQL database
>
> ...if found:
>
> 5) user does stuff with app that generates data
> 6) app uploads data to remote MySQL database
> 7) app thanks user and quits.
>
> I have 5) completed—a nice app that does complex stuff to collect data—and
> now its time to implement the DB end of things, beginning with making a
> connection to a remote database. I have a DB set up on a remote server that
> I can configure. I can access the tables there, etc with Navicat.
>
> Now what?
>
> To get my feet wet, I downloaded Trevor DeVore's libDataBase, and installed
> his "recipes" demo db on my local (macos x) MySQL and it runs fine. I
> installed the data in the remote MySQL, changed the "host" stuff in the demo
> to point to it, but the "recipes" stack can't connect.
>
> A great chasm of ignorance is open at my feet. I suspect there's security
> issues and many many more icky demons lurking in the depths. I HAVE ONE DAY
> TO BRIDGE THAT CHASM.
>
> Do I need to install a rev cgi on the remote server to communicate with the
> DB? Aaaeeee! What should it do?
>
> I know for a fact that Rev apps can do this. I've seen them. But the details
> elude me.
>
> Help!
>
> t
>
>
>
>
>
> --
> Tereza Snyder
> Califex Software, Inc.
> <www.califexsoftware.com>
>
>
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



More information about the use-livecode mailing list