use Perl

• MySQL (Score:1)

  by koschei (147)

  Why MySQL? I had to evaluate it for some project I did a few years ago and found it severely lacking at the time (it has improved now that it has transactions [kindof]).

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

    by gizmo_mathboy (782)

    I'm more familiar with MySQL. I have been planning to give PostGreSql a try when I have the time.
    
    I'll probably need to move to PostGres or something else if the traffice really picks up, but MySQL does what I need to do and what it can't do I'm finding solutions.
• Dude (Score:1)

  by JeffK (3094)

  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.
  • 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. :-)
          
          
• temp tables (Score:1)

  by gav (2710)

  Have you tried creating a temporary table that has the columns you are searching for it it, that you update every day/hour/etc. You can get pretty good mileage out of such a technique.
  • Re:temp tables (Score:1)

    by gizmo_mathboy (782)

    Didn't really think about it. I'll keep it mind for future growth though. I'm guessing my double search kludge will work for some time (and I could try the SQL queries that JeffK posted).
    
    I really need to sit down and read some db books. I have "Database Design for Mere Mortals" which seems rather good so far as it is an intro for design. I not so sure what else I'll need to know other than learning via the school of hard knocks.