use Perl

• Positional Parameters are a good idea (Score:2)

  by Dom2 (2981)

  Not using them means that you have to recreate the query execution plan each time. You get better performance by using them.

  You might want to have a look at Tim Bunce's Advanced DBI talk [gtsm.com]

  -Dom
  • Re:Positional Parameters are a good idea (Score:1)

    by nkuitse (193)

    Not using them means that you have to recreate the query execution plan each time.
    
    Actually, my code generates SQL with positional parameters. It takes a pseudo-SQL template like this:

    SELECT foo
      FROM bar
      WHERE baz = $baz
       AND qux = $qux

    And turns it into this:

    SELECT foo
      FROM bar
      WHERE baz = ?
       AND qux = ?

    Simultaneously taking the name-based parameters that you provide (in a hash, i.e., unordered) and lining their values up in the correct order in a params
• need testers? (Score:1)

  by WebDragon (1204)

  I'd be happy to help test this with MySQL if you'd like. It sounds a lot like it would be useful for me with an upcoming project I'm working on.
  • Re:need testers? (Score:1)

    by nkuitse (193)

    I'd be happy to help test this with MySQL if you'd like.
    
    Sure, thanks. (Though it doesn't really matter which RDBMS is used, since SQL::Template simply spits out SQL and a correctly ordered list of values.)
    
    You can download version 0.01 here (ca. 3KB) [nkuitse.com] for now. Do the usual to install:

    perl Makefile.PL
    make
    make test
    [sudo] make install

    It sounds a lot like it would be useful for me with an upcoming project I'm working on.
    
    Glad to hear it!