CodingApache and Perl and MySQL: confusion

 

Press Ctrl+Enter to quickly submit your post
Quick Reply  
 
 
  
 From:  af (CAER)  
 To:  ALL
37663.1 
Hello :O

I am trying to wean myself off World Of Warcraft and instead do something useful with my time. I want to learn Perl, Javascript and MySQL.

Since I recently began writing a blog, I've had the mad idea that the best way to learn the things I want is to write my own basic blog software.

So, I installed Apache and Perl, and by following some guides found on Google I have something that works - I can go to http://localhost/test.pl and it runs my Perl program ("Hello world!").

It's the next bit where I run into confusion: how do I bring MySQL into all of this? Even the installation is confusing: it wants to put something in C:\ProgramData as well as C:\Program Files, and then asks me where I want to put my databases. I have my external USB drive as B: but MySQL won't let me pick that. This is a minor issue.

The big issue is how I actually "connect" Apache, Perl and MySQL together. I have a problem understanding it all on a conceptual level - once I get that part it should all become much easier.

And then we can move on to discussing how all this works on a remote server :&
Caer
0/0
 Reply   Quote More 

 From:  99% of gargoyles look like (MR_BASTARD)  
 To:  af (CAER)     
37663.2 In reply to 37663.1 
I can go to http://localhost/test.pl and it runs my Perl program ("Hello world!").

No.
quote:
The page cannot be displayed
The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings.

Other than that, I'm afraid I can't help. This is one some of us buy pooters with all this crap installed already.

bastard by name, bastard by nature

0/0
 Reply   Quote More 

 From:  Drew (X3N0PH0N)  
 To:  af (CAER)     
37663.3 In reply to 37663.1 
Why Perl? I mean, it's a bit archaic. Not saying useful stuff can't be done with it, it's a good and that. But I'm pretty sure even a Perl-nut would tell you there are easier/better ways to do the same thing.

0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  af (CAER)     
37663.4 In reply to 37663.1 
What insanity caused you to pick Perl?


quote:
Even the installation is confusing: it wants to put something in C:\ProgramData as well as C:\Program Files, and then asks me where I want to put my databases.


That's correct. Program Files is for the application files, whilst Program Data is for the application settings/etc.
The databases are more user data.

The reason for Program Files and Program Data splitting into two is for security/permissions stuff - remember when certain apps couldn't run without admin user? That's what this solves.


quote:
I have my external USB drive as B: but MySQL won't let me pick that. This is a minor issue.


What about if you do "SUBST X: B:\" - (where X is whatever other letter you'd like to use) - or even "SUBST X: B:\MySqlData\" if you prefer.

I think that will fool it into letting you use that.

If so, you'll need to add the command to a startup script so it runs every time you turn the machine on.
0/0
 Reply   Quote More 

 From:  af (CAER)  
 To:  ALL
37663.5 

SUBST doesn't work - I already have N: set up to be B:\NetShare and the installer doesn't list that either, so either it's ignoring SUBSTed drives, or it just won't let me put data on an external drive.

 

As for why Perl, well, BOB knows it so if I have problems I can phone/txt/gchat him and make him fix things. And I like archaic. Maybe.

 

And anyway, if not Perl, then what? (not PHP)

Caer
0/0
 Reply   Quote More 

 From:  99% of gargoyles look like (MR_BASTARD)  
 To:  af (CAER)     
37663.6 In reply to 37663.5 
not PHP

Why not? I've kinda (half-)written a bloggy think in PHP/MySQL and it's OK.

bastard by name, bastard by nature

0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  af (CAER)     
37663.7 In reply to 37663.5 
Well of course I'd recommend what I use, which is Railo CFML - has a nice easy learning curve and is brilliant in lots of ways. :)

Rendle would probably recommend Ruby, because he uses/likes that.

Python is also popular for web stuff these days.

All these options are modern/active/etc and have plenty of tutorials and help available online, all have good web frameworks available, and are capable of easily creating a blog application, or whatever else you might want to do.

There are other choices too, but I'd suggest picking one of the above (or maybe even check out all three) and see if you like it/them.
0/0
 Reply   Quote More 

Message 37663.8 deleted 5 Nov 2010 22:18 by CAER

 From:  Peter (BOUGHTONP)  
 To:  af (CAER)     
37663.9 In reply to 37663.8 
Just so you know, you're not limited to Perl/PHP with that:

http://code.google.com/p/rampp/
http://townx.org/ruby_on_rails_on_xampp
http://blog.chomperstomp.com/installing-python-mod_python-on-xampp/
0/0
 Reply   Quote More 

 From:  ANT_THOMAS  
 To:  af (CAER)     
37663.10 In reply to 37663.8 
I use WAMP (as recommended on here) to have a nice Apache, MySQL and PHP web server run happily.
0/0
 Reply   Quote More 

 From:  99% of gargoyles look like (MR_BASTARD)  
 To:  ANT_THOMAS     
37663.11 In reply to 37663.10 
But for some, as yet unexplained, reason Mr Zobu eschews PHP.

bastard by name, bastard by nature

0/0
 Reply   Quote More 

 From:  ANT_THOMAS  
 To:  99% of gargoyles look like (MR_BASTARD)     
37663.12 In reply to 37663.11 

Well he's silly.

 

I've made quite a few things with PHP and MySQL now that serve a few useful purposes, blog stuff, databases etc.

 

I would build my own system for my TKD site but it's not just me adding news so I went with CuteNews because it was very easy to setup and it's easy to use for the non-techy types without being overkill.

0/0
 Reply   Quote More 

 From:  99% of gargoyles look like (MR_BASTARD)  
 To:  ANT_THOMAS     
37663.13 In reply to 37663.12 
Agreed, I've done some fairly useful stuff with PHP, but perhaps there's some specific facet of Perl/PHP that he likes/dislikes. I cannot imagine what that would be though (shrug)

bastard by name, bastard by nature

0/0
 Reply   Quote More 

 From:  Peter (BOUGHTONP)  
 To:  99% of gargoyles look like (MR_BASTARD)     
37663.14 In reply to 37663.13 
Actually, it's easy to imagine what it might be: PHP is fucking ugly, with all those damned $dollars, under_scores, arrow->operators, and the silly paamayim::nekudotayim.

Or it might be that nobody cares if you know PHP (since it's so commonplace), and he wants something that might be found interesting instead of mundane.

Or maybe it's because it has a silly name and recursive acronym and is too many sylabulls.

Or, like, who cares. Life is too short to worry over whether someone picks PHP or not.
0/0
 Reply   Quote More 

 From:  af (CAER)  
 To:  ALL
37663.15 
I am a great fool.

It's actually Python wot Bob knows (and recommends). I don't know why I got it confused with Perl.

So anyway, I installed Apache again, then Python, and I think I installed Pylons properly. The welcome page showed up on localhost:5000 anyway, and Paste seemed to be doing something.

So! I think I'll get to grips a bit more with this whole Python lark first, then maybe make something useful :O
Caer
0/0
 Reply   Quote More 

 From:  CHYRON (DSMITHHFX)  
 To:  af (CAER)     
37663.16 In reply to 37663.15 
If you want a framework with it check out django...

----
What can't social media do?
  • Make coffee
  • Tie its shoes
  • Spell
0/0
 Reply   Quote More 

 From:  99% of gargoyles look like (MR_BASTARD)  
 To:  Peter (BOUGHTONP)     
37663.17 In reply to 37663.14 
PHP is fucking ugly

And you're an oil painting? :?
nobody cares if you know PHP (since it's so commonplace)

By the same token, there's plenty of help readily available.
he wants something that might be found interesting instead of mundane.

Your suggestion of CF (or derivative thereof) indicates a confusion between 'interesting' and 'quaint'.
Or maybe it's because it has a silly name and recursive acronym and is too many sylabulls.

The first sensible suggestion that you've made! :)

bastard by name, bastard by nature

0/0
 Reply   Quote More 

Reply to All    
 

1–17

Rate my interest:

Adjust text size : Smaller 10 Larger

Beehive Forum 1.5.2 |  FAQ |  Docs |  Support |  Donate! ©2002 - 2024 Project Beehive Forum

Forum Stats