Perl & delivering Databases?
ammar_a...@my-deja.com
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.
Martijn Tonies
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_a...@my-deja.com> wrote in message
news:8epqus$i1p$1...@nnrp1.deja.com...
Elliot Finley
<remove...@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 (efi...@efinley.com) Weird Science!
ammar_a...@my-deja.com
"Martijn Tonies" <remove...@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
ammar_a...@my-deja.com
efi...@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...