Fw: PHP or Perl? (or Rebol via TCP/IP)
Hello Tim, Do've an example on using Rebol to connect to mySQL via TCP/IP? How do you do it? How do you execute SQL quieries? Return results etc ? Do you use some kind of "middleware" that your communicating to from Rebol via TCP/IP which gets the data for you? I'm actually a Delphi, Java, VB, Perl & Ruby developer (done alittle Rebol before) but found it strange that your using TCP/IP to communicate with mySQL. Kind Regards, Lennie De Villiers (nRs - Please don't remove this when replying!) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl? (or Rebol via TCP/IP)
Hello Tim, Do've an example on using Rebol to connect to mySQL via TCP/IP? How do you do it? How do you execute SQL quieries? Return results etc ? Kind Regards, Lennie De Villiers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
The only and best careful way to use a global is not to use one at all!! At 11:38 AM 8/18/03 +0900, Joel Rees wrote: >> The only advantage of PHP is that >> it runs faster than Perl which may be important if a lot of people are >> accessing your web page. > >Using mod_perl vs. mod_php? or perl with the CGI interface vs. mod_php? > >(I understand that using mod_perl introduces persistence problems when >globals are not carefully used, and I have never seen those problems >when using PHP, but that is less about speed than about programming.) > >-- >Joel Rees, programmer, Systems Group >Altech Corporation (Alpsgiken), Osaka, Japan >http://www.alpsgiken.co.jp > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." -- Will Durant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
> The only advantage of PHP is that > it runs faster than Perl which may be important if a lot of people are > accessing your web page. Using mod_perl vs. mod_php? or perl with the CGI interface vs. mod_php? (I understand that using mod_perl introduces persistence problems when globals are not carefully used, and I have never seen those problems when using PHP, but that is less about speed than about programming.) -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
> People tell me that PHP is THE way to do database work with mysql. > The thing is, I'm familiar with Perl and it has all kinds of neat > string manipulation stuff and LWP. People have opinions. My personal opinion, but I think of PHP as Perl with all the warts filed off, but I also think they filed off a little too much. Most of the cutting edge development is still done in Perl, and the rought edges still show in places, and I think that's part of the reason many people prefer PHP. If you are just starting out with MySQL, I don't think you're going to find yourself playing with cutting edge libraries, however. If you know Perl, PHP is not going to be hard to pick up. But if you don't have a customer speccing PHP, go ahead and use Perl to learn MySQL so you aren't learning too many things at once. When you get a chance to pick up PHP and find yourself wondering where some library is, look at Pear (pear.php.net). Pear isn't CPAN, but it is becoming the umbrella project for libraries for PHP. Perl 6 and PHP 5 will have some rather drastic changes, which I am looking forward too. And Java can profitably be used with MySQL, and PostGreSQL can be mixed in at will, and ... -- Joel Rees, programmer, Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
Hello I am no PHP expert but I find it quite easy to move from Perl to PHP. PHP too has a huge standard library with lots of useful functions and it has PEAR, something similar to CPAN. but when I develop MySQL appliction (mainly for myself at the moment) I use Python or Ruby. they are also easy to learn and are very clean languages. and Ruby is quite similar to Perl but fully OOP. and Ruby and Python also have great standard libraries. in Python there is for example urlib and urllib2 as a replacement for LWP. and Ruby also hat stuff for this in the standard library and the Ruby Application Archive. just my experiences. check out http://www.ruby-lang.org http://www.rubycentral.com http://www.python.org Markus On Sat, 2003-08-16 at 07:17, Mark Healey wrote: > As part of my own learning mysql project I'm planning to build > databases for all my books and DVD's. Stephen Hawking is probably > a better typist than I am so I plan to use barcodes to get the info > ,taking the information from various web sites. > > People tell me that PHP is THE way to do database work with mysql. > The thing is, I'm familiar with Perl and it has all kinds of neat > string manipulation stuff and LWP. > > Does PHP have comprable libraries (especially LWP) and how difficult > is it to move from Perl. > > I hope I don't start a relegious war here I just want some advice. > > > Mark Healey > [EMAIL PROTECTED] > > This account is only for lists to which I've subscribed. > Any spammers invite the worst revenge I think I can get away with. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl? (or Rebol via TCP/IP)
> > > > I hope I don't start a relegious war here I just want some advice. > > > > > > Mark Healey > > [EMAIL PROTECTED] I program with C, C++, python and rebol. My partner use perl. We do lots of stuff with MySql. My hands-down favorite is rebol. I find more code-efficient than any other language that I have used in my career. And it delivers sizzling performance from mysql on a TCP/IP connection (rather than using shared binaries). Like perl, rebol is easy to get off the ground with and there are multiple ways to do anything. (including roll-your-own control structures). given rebol's performance, I'm going to investigate using C on a socket connection to MySql... Just my thoughts My brother is a project engineer with motorola they use lots of both rebol and perl. Perl for regex and rebol for socket work. Although I believe that you can harness regex directly with mysql, I haven't done anything more than simple blobs. -- Tim Johnson <[EMAIL PROTECTED]> http://www.alaska-internet-solutions.com http://www.johnsons-web.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
Hi Where to start For a pure web system, I would recommend PHP. It is smaller, faster and interfaces better with apache. This was its design goal. For a non web system, it has to be PERL. For a mixed system, I would again favour Perl, due to its flexibilty and power. I am currently working on a system with a few friends and we have chosen to write it in Perl. The prototype was written in Php, and was well received, but the production copy had to move to perl. We had so much code that we had to duplicate between web and backend systems, that Perl was the only viable option. The code uses several libraries, accessed from modperl, cgi and standalone perl apps. Finally, the standard interface that Perl offers for databases, DBI, makes writing MySQL/Perl applications much easy. I hope this helps Simon On Saturday 16 August 2003 06:17, Mark Healey wrote: > As part of my own learning mysql project I'm planning to build > databases for all my books and DVD's. Stephen Hawking is probably > a better typist than I am so I plan to use barcodes to get the info > ,taking the information from various web sites. > > People tell me that PHP is THE way to do database work with mysql. > The thing is, I'm familiar with Perl and it has all kinds of neat > string manipulation stuff and LWP. > > Does PHP have comprable libraries (especially LWP) and how difficult > is it to move from Perl. > > I hope I don't start a relegious war here I just want some advice. > > > Mark Healey > [EMAIL PROTECTED] > > This account is only for lists to which I've subscribed. > Any spammers invite the worst revenge I think I can get away with. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -- This message has been scanned for viruses and dangerous content by MailScanner, http://www.mailscanner.info, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
On Saturday 16 August 2003 8:44, O'K Web Design wrote: > Hi Mark > > I can only tell you about my experience from the Perl side of things. > The integration to the database is great and the amount of things you can > do with the data once you get it in the script is the biggest bonus. My > feeling is that a combination of the two would probably be the best. Any > pages that just list your records, I would build in PHP. Any that involve > handling the data before output, I would use Perl. Mike I have yet to come upon data handling that I can do in Perl that I can't do in PHP. PHP is pretty robust in that area. The biggest advantage to Perl that I see is that there are more libraries and such available for Perl, but the PHP community is working on that. -Jackson > > > - Original Message - > From: "Mark Healey" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: August 16, 2003 1:17 AM > Subject: PHP or Perl? > > > As part of my own learning mysql project I'm planning to build > > databases for all my books and DVD's. Stephen Hawking is probably > > a better typist than I am so I plan to use barcodes to get the info > > ,taking the information from various web sites. > > > > People tell me that PHP is THE way to do database work with mysql. > > The thing is, I'm familiar with Perl and it has all kinds of neat > > string manipulation stuff and LWP. > > > > Does PHP have comprable libraries (especially LWP) and how difficult > > is it to move from Perl. > > > > I hope I don't start a relegious war here I just want some advice. > > > > > > Mark Healey > > [EMAIL PROTECTED] > > > > This account is only for lists to which I've subscribed. > > Any spammers invite the worst revenge I think I can get away with. > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
Hi Mark I can only tell you about my experience from the Perl side of things. The integration to the database is great and the amount of things you can do with the data once you get it in the script is the biggest bonus. My feeling is that a combination of the two would probably be the best. Any pages that just list your records, I would build in PHP. Any that involve handling the data before output, I would use Perl. Mike - Original Message - From: "Mark Healey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: August 16, 2003 1:17 AM Subject: PHP or Perl? > As part of my own learning mysql project I'm planning to build > databases for all my books and DVD's. Stephen Hawking is probably > a better typist than I am so I plan to use barcodes to get the info > ,taking the information from various web sites. > > People tell me that PHP is THE way to do database work with mysql. > The thing is, I'm familiar with Perl and it has all kinds of neat > string manipulation stuff and LWP. > > Does PHP have comprable libraries (especially LWP) and how difficult > is it to move from Perl. > > I hope I don't start a relegious war here I just want some advice. > > > Mark Healey > [EMAIL PROTECTED] > > This account is only for lists to which I've subscribed. > Any spammers invite the worst revenge I think I can get away with. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
At 12:17 AM 8/16/2003, you wrote: As part of my own learning mysql project I'm planning to build databases for all my books and DVD's. Stephen Hawking is probably a better typist than I am so I plan to use barcodes to get the info ,taking the information from various web sites. People tell me that PHP is THE way to do database work with mysql. The thing is, I'm familiar with Perl and it has all kinds of neat string manipulation stuff and LWP. Does PHP have comprable libraries (especially LWP) and how difficult is it to move from Perl. I hope I don't start a relegious war here I just want some advice. Mark, Perl is a much richer (larger) programming language than PHP. PHP is best suited for designing webpages whereas Perl is a more universal tool (you can use it for just about anything). The only advantage of PHP is that it runs faster than Perl which may be important if a lot of people are accessing your web page. But if you are running this application locally on your hard disk (not as a web page), then probably C++ will give you the fastest possible application. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
> As part of my own learning mysql project I'm planning to build > databases for all my books and DVD's. Stephen Hawking is probably > a better typist than I am so I plan to use barcodes to get the info > ,taking the information from various web sites. > > People tell me that PHP is THE way to do database work with mysql. > The thing is, I'm familiar with Perl and it has all kinds of neat > string manipulation stuff and LWP. > Not to mention CGI.pm > Does PHP have comprable libraries (especially LWP) and how difficult > is it to move from Perl. They're called 'classes' and there are quite a number out there. > > I hope I don't start a relegious war here I just want some advice. > > > Mark Healey > [EMAIL PROTECTED] > I've used both for development, most recently for an application involving POP mail accounts. I'd say if you're already doing Perl you might as well stick with it - it's the grand-daddy after all. They are so close syntax-wise what's the point of learning another language unless it's got some overwhelming advantage? PHP is good if you don't have access to CGI, but you have to make sure all the necessary things are turned on at the server level. For example, I had written my email app in PHP but discovered that I needed imap turned on, which my ISP didn't have, and wasn't going to. So back to Perl. Any modules you need can be installed locally and there is just so much more available, being a more mature language. As far as accessing MySQL I don't see any advantage to using PHP over Perl - all the same features are available. One thing I don't like about PHP is having my form variables named after field names. I'd rather control my own names thank you very much. -- /* All outgoing email scanned by AVG Antivirus /* Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. "We make web sites work!" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP or Perl?
In the last episode (Aug 15), Mark Healey said: > As part of my own learning mysql project I'm planning to build > databases for all my books and DVD's. Stephen Hawking is probably a > better typist than I am so I plan to use barcodes to get the info > ,taking the information from various web sites. > > People tell me that PHP is THE way to do database work with mysql. > The thing is, I'm familiar with Perl and it has all kinds of neat > string manipulation stuff and LWP. The best way is with C, calling the libmysqlclient functions directly, of course :) Once you decide to use an interpreted language, just pick the one you're most comfortable with. PHP is "THE" way for people that know PHP. If you like Perl instead, use Perl. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP or Perl?
As part of my own learning mysql project I'm planning to build databases for all my books and DVD's. Stephen Hawking is probably a better typist than I am so I plan to use barcodes to get the info ,taking the information from various web sites. People tell me that PHP is THE way to do database work with mysql. The thing is, I'm familiar with Perl and it has all kinds of neat string manipulation stuff and LWP. Does PHP have comprable libraries (especially LWP) and how difficult is it to move from Perl. I hope I don't start a relegious war here I just want some advice. Mark Healey [EMAIL PROTECTED] This account is only for lists to which I've subscribed. Any spammers invite the worst revenge I think I can get away with. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Add, modify and delete entries with PHP or Perl
try PHPMyEdit: http://phpmyedit.sourceforge.net/ Maciek > -Original Message- > From: Nuno Lopes [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 10, 2001 11:37 AM > To: Lista MySQL > Subject: Add, modify and delete entries with PHP or Perl > > > Hi, > > I would like to know how to add, modify and delete entries with > PHP or Perl, because I want to create a table in mysql and and > don't know how. > The table look like this: > > -| time spent on-line | leads | mailling list | > e-mail | > -- > - > username1 | 4| 5 | YES | > [EMAIL PROTECTED] | > -- > - > username2 | 6| 8 | NO > | [EMAIL PROTECTED] | > -- > - > username3 | 9| 2 | YES | > [EMAIL PROTECTED] | > -- > - > > > Thanking in advance, > Nuno Lopes > > > P.S.: When you reply to the list, reply to my e-mail > ([EMAIL PROTECTED]), too, please... > - 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
Add, modify and delete entries with PHP or Perl
Hi, I would like to know how to add, modify and delete entries with PHP or Perl, because I want to create a table in mysql and and don't know how. The table look like this: -| time spent on-line | leads | mailling list |e-mail | --- username1 | 4| 5 | YES | [EMAIL PROTECTED] | --- username2 | 6| 8 | NO| [EMAIL PROTECTED] | --- username3 | 9| 2 | YES | [EMAIL PROTECTED] | --- Thanking in advance, Nuno Lopes P.S.: When you reply to the list, reply to my e-mail ([EMAIL PROTECTED]), too, please...
