Re: Frontend Dilema
Can someone tell me whats worng with my syntax:
use DBI;
$dbh = DBI->connect("DBI:mysql:rushload\@leader","richard", "passwd");
leader = name of server, rushload = name of database
Do I need a port number if so which one should I use?
Richard
"Jeremy D. Zawodny" wrote:
>
> On Wed, Jan 17, 2001 at 03:58:11PM -0600, Richard Reina wrote:
>
> > Thanks for the reply. Curses worked OK. But I was convinced that a
> > web server would be more efficient than NFS for sharing the database
> > files. Is that true? Or is a NFS a longtime viable solution for
> > clients on the LAN quering the database.
>
> You don't need NFS in the loop at all.
>
> You curses/perl app will be a client that talks to your MySQL server
> via TCP/IP. The MySQL server is the only things that needs direct
> access to the data files.
>
> I'm suggesting that you replcate browser/mod_perl/apache with
> perl/curses.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878Fax: (408) 530-5454
> Cell: (408) 439-9951
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Frontend Dilema
On Thu, Jan 18, 2001 at 01:49:30PM -0800, Jeremy D. Zawodny wrote: > On Wed, Jan 17, 2001 at 03:58:11PM -0600, Richard Reina wrote: > > > Thanks for the reply. Curses worked OK. But I was convinced that a > > web server would be more efficient than NFS for sharing the database > > files. Is that true? Or is a NFS a longtime viable solution for > > clients on the LAN quering the database. > > You don't need NFS in the loop at all. > > You curses/perl app will be a client that talks to your MySQL server > via TCP/IP. The MySQL server is the only things that needs direct > access to the data files. > > I'm suggesting that you replcate browser/mod_perl/apache with > perl/curses. "replicate" should have been "replace". I've apparently typed variations of the word "replicate" a few too many times recently. :-( -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Frontend Dilema
The client programs connect to mysqld over the network. Compile the clients to run on the workstations. Then set your mysql host to be the server. One server, many clients. Richard Reina wrote: > > Thanks for the reply. Curses worked OK. But I was convinced that a web > server would be more efficient than NFS for sharing the database files. > Is that true? Or is a NFS a longtime viable solution for clients on the > LAN quering the database. > > Richard > > "Jeremy D. Zawodny" wrote: > > > > On Wed, Jan 17, 2001 at 03:17:52PM -0600, Richard Reina wrote: > > > > > I run a small business. A year and a half ago I embarked on a > > > jorney to port my DOS Foxpro Database to linux. I selected mysql as > > > an the engine and and begand writing the app. using perl/dbi and > > > perlmenu module/curses as the front end at first I used NFS to share > > > the databse files on the LAN. I was soon after convinced by a perl > > > gut to ditch NFS as and use apach/mod_perl and write the front end > > > in HTML. > > > > > > I hired someone to help me and we wrote the first phase and I hate > > > the frontend. I hate having to hit submit after every entry. I > > > hate the way a browser looks and the wait it feels. We're even > > > tried using w3m I still hate it. I'm looking for a NON GRAPHICAL > > > interface taht I guess would work with apache mod-perl. Any > > > suggestions? Does Perl Tk fit this bill? > > > > Perl/Tk is for generating GUIs, which you don't want. > > > > I don't understand what's wrong with the curses/DBI approach. It > > should work fine. There's not need for mod_perl and Apache if there is > > not supposed to be a web interface. > > > > Jeremy > > -- > > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > > Technical Yahoo - Yahoo Finance > > Desk: (408) 328-7878Fax: (408) 530-5454 > > Cell: (408) 439-9951 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Frontend Dilema
You can connect to the DB on Linux using ODBC over any TCP/IP network, and you don't need to worry about NFS, File sharing, Samba etc. All you need is MySQL on Linux connected to your network and ODBC will connect on port 3306 over TCP/IP, that's all you need. A system built this way can use many different front-ends on different OS's completely independant of the DB. - Scott > > Thanks for the reply. Curses worked OK. But I was convinced that a web > server would be more efficient than NFS for sharing the database files. > Is that true? Or is a NFS a longtime viable solution for clients on the > LAN quering the database. > > Richard > > "Jeremy D. Zawodny" wrote: > > > > On Wed, Jan 17, 2001 at 03:17:52PM -0600, Richard Reina wrote: > > > > > I run a small business. A year and a half ago I embarked on a > > > jorney to port my DOS Foxpro Database to linux. I selected mysql as > > > an the engine and and begand writing the app. using perl/dbi and > > > perlmenu module/curses as the front end at first I used NFS to share > > > the databse files on the LAN. I was soon after convinced by a perl > > > gut to ditch NFS as and use apach/mod_perl and write the front end > > > in HTML. > > > > > > I hired someone to help me and we wrote the first phase and I hate > > > the frontend. I hate having to hit submit after every entry. I > > > hate the way a browser looks and the wait it feels. We're even > > > tried using w3m I still hate it. I'm looking for a NON GRAPHICAL > > > interface taht I guess would work with apache mod-perl. Any > > > suggestions? Does Perl Tk fit this bill? > > > > Perl/Tk is for generating GUIs, which you don't want. > > > > I don't understand what's wrong with the curses/DBI approach. It > > should work fine. There's not need for mod_perl and Apache if there is > > not supposed to be a web interface. > > > > Jeremy > > -- > > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > > Technical Yahoo - Yahoo Finance > > Desk: (408) 328-7878Fax: (408) 530-5454 > > Cell: (408) 439-9951 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Frontend Dilema
On Wed, Jan 17, 2001 at 03:58:11PM -0600, Richard Reina wrote: > Thanks for the reply. Curses worked OK. But I was convinced that a > web server would be more efficient than NFS for sharing the database > files. Is that true? Or is a NFS a longtime viable solution for > clients on the LAN quering the database. You don't need NFS in the loop at all. You curses/perl app will be a client that talks to your MySQL server via TCP/IP. The MySQL server is the only things that needs direct access to the data files. I'm suggesting that you replcate browser/mod_perl/apache with perl/curses. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Frontend Dilema
Thanks for the reply. Curses worked OK. But I was convinced that a web server would be more efficient than NFS for sharing the database files. Is that true? Or is a NFS a longtime viable solution for clients on the LAN quering the database. Richard "Jeremy D. Zawodny" wrote: > > On Wed, Jan 17, 2001 at 03:17:52PM -0600, Richard Reina wrote: > > > I run a small business. A year and a half ago I embarked on a > > jorney to port my DOS Foxpro Database to linux. I selected mysql as > > an the engine and and begand writing the app. using perl/dbi and > > perlmenu module/curses as the front end at first I used NFS to share > > the databse files on the LAN. I was soon after convinced by a perl > > gut to ditch NFS as and use apach/mod_perl and write the front end > > in HTML. > > > > I hired someone to help me and we wrote the first phase and I hate > > the frontend. I hate having to hit submit after every entry. I > > hate the way a browser looks and the wait it feels. We're even > > tried using w3m I still hate it. I'm looking for a NON GRAPHICAL > > interface taht I guess would work with apache mod-perl. Any > > suggestions? Does Perl Tk fit this bill? > > Perl/Tk is for generating GUIs, which you don't want. > > I don't understand what's wrong with the curses/DBI approach. It > should work fine. There's not need for mod_perl and Apache if there is > not supposed to be a web interface. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 328-7878Fax: (408) 530-5454 > Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Frontend Dilema
On Wed, Jan 17, 2001 at 03:17:52PM -0600, Richard Reina wrote: > I run a small business. A year and a half ago I embarked on a > jorney to port my DOS Foxpro Database to linux. I selected mysql as > an the engine and and begand writing the app. using perl/dbi and > perlmenu module/curses as the front end at first I used NFS to share > the databse files on the LAN. I was soon after convinced by a perl > gut to ditch NFS as and use apach/mod_perl and write the front end > in HTML. > > I hired someone to help me and we wrote the first phase and I hate > the frontend. I hate having to hit submit after every entry. I > hate the way a browser looks and the wait it feels. We're even > tried using w3m I still hate it. I'm looking for a NON GRAPHICAL > interface taht I guess would work with apache mod-perl. Any > suggestions? Does Perl Tk fit this bill? Perl/Tk is for generating GUIs, which you don't want. I don't understand what's wrong with the curses/DBI approach. It should work fine. There's not need for mod_perl and Apache if there is not supposed to be a web interface. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
