🚀 go-pugleaf

On Thu, 4 May 2000 17:50:30 +0200, "Martijn Tonies"
<remove_seal97@dds.nl> wrote:

>My guess is that your first plan would be slow... very slow... What about a
>3-tier solution here?
>
>Build a server application that connects to the database from localhost and
>build a client app that connects to the server app...

Why not just use the stuff in Bundle::DBI from CPAN?  I don't recall
the name of the modules, but there is one (two?) that allows you to
set up a proxy on the box that has the DB running.  The proxy accesses
the DB from localhost, but provides remote network access to the Perl
DBI.
-- 
Elliot (efinley@efinley.com) Weird Science!

My guess is that your first plan would be slow... very slow... What about a
3-tier solution here?

Build a server application that connects to the database from localhost and
build a client app that connects to the server app...

Martijn Tonies

--

For Delphi Components and InterBase tools:
http://www.upscene.com


<ammar_aganovic@my-deja.com> wrote in message
news:8epqus$i1p$1@nnrp1.deja.com...
> I need to make a database residing on MySQL available to custom
> developed software which would be able to access the database directly.
> The most elegant solution would be to simply add a System DSN in ODBC
> sources with MySQL driver, and access the database through DSN. The
> problem is the proveider would not let a user to connect from host
> other then localhost (security reasons). So I need to improvise.
>
> I am thinking of delivering a DB through HTTP. I though a perl script
> would be able to read the MySQL tables, and output them to for example
> access file. The file would be then send via http protocol, and the
> software at the client side would then process the access db, make the
> changes, modify the access file and send back. Or I could even do some
> streaming (both Client & Server side). I thought of using Perl & Delphi
> to accomplish that, but would be very gratefull if U could help me with
> some modules & units I could search for.
>
>
>
> P.S. does anyone know how to drive a ODBC connection through secure
> channel? I did manage to use a portmapper (or something like that) to
> reroute the connection through previously established secure line (with
> TTerm & TTsh), but I found no way to automatise the process.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

In article <8es697$spk$1@porthos.nl.uu.net>,
  "Martijn Tonies" <remove_seal97@dds.nl> wrote:
> My guess is that your first plan would be slow... very slow... What
about a
> 3-tier solution here?

Which one would be slow? The one delivering the records through HTTP?
This about access file was silly, but would it be slow too, if I would
do a "select * from table* query via Perl/PHP3, and send the records
through normal http port, the client would recieve the records and
sttore them localy. Would it be slow, too? We are talking pure ASCII
here, would binary transfers be somewhat faster?

What is a 3-tier solution?

regrads,
Ammar


Sent via Deja.com http://www.deja.com/
Before you buy.

In article <39160278.72617631@news.firstworld.net>,
  efinley@efinley.com wrote:

> Why not just use the stuff in Bundle::DBI from CPAN?  I don't recall
> the name of the modules, but there is one (two?) that allows you to
> set up a proxy on the box that has the DB running.  The proxy accesses
> the DB from localhost, but provides remote network access to the Perl
> DBI.

I've downloaded a a 164k DBI module from CPAN. Is there anything more I
need?  I don't understand how do I set the DSNs in ODBC up to use such
a proxy? Or it can be used by a perl on a client only? Does the proxy
listen to specific port all the time? The root might not like that :(,
and I'd have a restart problems (would have to use at to start such a
proxy).

This sound like a good moment for the following question...

Can I install/use Perl modules without having the root to install them
globaly? I guess I could do a 'perl Makefile.pl', and a make, too. I
also guess I could use some calling convention to call the module with
a given path, right? The thing that confuses me is that there are loads
of users asking the root to install some Perl modules taht they want to
use...


Sent via Deja.com http://www.deja.com/
Before you buy.