use Perl

• Dude (Score:1)

  by JeffK (3094) <JeffKguru@hotmail.com> on 2002.05.01 12:35 (#7801)

  way to use the free software. Oracle's nice, but the cost is so prohibitive for the little guy. I might have some search scripts laying around if you wanna look at it.
  
  JeffK
  
  What was that other guys problem? You run into those jerks everywhere.

  Reply to This

  • Re:Dude (Score:1)

    by gizmo_mathboy (782)

    I'm running Apache and RedHat 7.2,too.
    
    I'm currently looking at Tomcat to see if a java servlet can run on it. I might have to use win2k for that since the company that created the servlet (and assoicated apps) is windows only. I would like to stay on Linux/Apache but I may have to move to win2k/Apache. I hope I won't have to go win2k/IIS.
    
    I think the biggest problem with the search script is that I'm potentially querying 2 tables. With no subqueries I had to make 2 queries and then merge them. Not that big
    • Try this (Score:1)

      by JeffK (3094)

      Here are different examples of how to do a psudeo-subquery with MySQL.
      
      # max_salary table to get the names of the
      # employees with the highest salary.
      #
      SELECT employee_name
      FROM employee, salary, max_salary
      WHERE employee.employee_id = salary.employee_id
      
      AND salary = max_salary
      ---------------------------------------------------------------
      
      SELECT employee_name
      FROM employee, salary
      WHERE employee.employee_id = salary.employee_id
      AND salary = (SELECT MAX(salary.salary) FROM
      salary);
      
      ------
      • Re:Try this (Score:1)

        by gizmo_mathboy (782)

        Cool. Perl runs strong in me but SQL is weak. Maybe I can trade Perl knowledge for SQL. ;-)
        
        Know of any good SQL books? I suppose I should poke around the usenet archives, but I'm lazy and like to get recommendations before I spend money on an area I'm not so knowledgeable.
  • Re:Dude (Score:1)

    by koschei (147)

    Bit OTT surely? No need to call me a jerk. Hmm. Or were you referring to that idiot who posted previous comments to other journal entries?
    
    I was merely asking after his reasons in using MySQL. It was only due to the mention of having trouble trying to do something that MySQL doesn't support and, as you noted, have to kludge around.
    
    fwiw, as gizmo noted: Postgres is also nice, and as free as MySQL. Hmm. And has solid transaction support =)
    
    I tried Oracle - ate my machine. Helps to have more than 128Mb RAM. A

    --
      ---ict / Spoon
    • Re:Dude (Score:1)

      by JeffK (3094)

      I'm really sorry if you thought I meant you.
      I was talking about the other guy you mentionned.
      I agree about Postgres. Everyone has there own
      reasons for everytihng they use. I mean
      do people really like to use Word or do
      they have to?
      Again I'm sorry for the confusion. What does
      OTT mean?
      
      JeffK
      • Re:Dude (Score:1)

        by koschei (147)

        It's cool. I was halfway through writing a much too nasty reply and suddenly thought "hang on! this is gizmo's journal. it's got that weird guy." Not to worry.
        
        I've always assumed that people use Word because they either have to or that they don't know any better - or that anything better is too much effort. I mean, I praise LaTeX and TeX to the heavens. Wouldn't live without them. But there's one hell of a learning curve. Now TechWriter, on the other hand, that's a wonderful program. GUI based (not quite

        --
          ---ict / Spoon
        • Re:Dude (Score:1)

          by gizmo_mathboy (782)

          Great. Now my journal is associated with that weird guy aka Cliffy (I'm guessing) ;-)
          
          Oh well, we all have burdens to bear. :-)