Slash Boxes
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login | Reply
Loading... please wait.
  • In these sorts of languages, it make more sense to put the variables directly into the statement at prepare time, then you set the variables, and they get bound at execute time. That's how it's done in some languages...then the language knows what types the variables are at prepare time. E.g. "select foo from bar where baz = :some_number and blurgh = :some_string", and some_number and some_string are variables.
  • One of the better lightweight database libraries is jDBI []. It doesn't seem to have the varargs method corresponding to DBI's execute(), but it does have generic 'bind()' methods as well as the ability to pass in a Map which uses named params.

    Similar to the JDBC support in Spring, It's also got simple and very useful output mapping so you can get a list of objects back rather than raw resultsets.

    • Awesome! I didn't know such stuff existed!

      Unfortunately I probably can't use it at work at this time. :) But I've been encouraged at times to seek better ways of doing things that would radically alter our code base, so they might be open to it in the future, if I can prove it's a good idea.

      I think one of the big problems in the Java world is that "official" ways to do things have often been blessed into standards status by Sun, discouraging further innovation. EJB is a great example, and I've seen b

      J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
      • Actually, there's a TON of opensource stuff in the Java world. There's just no CPAN. A lot of it is in response to overdesigned standards (like EJB), crappy built-in libraries (like Joda Time improving datetime handling), or just building better functionality over basic work (like jDBI or iBatis over JDBC).

        One thing that's become more frequent is a widely-used open source project becoming part of the JDK. All the concurrency improvements in Java5 came pretty much verbatim from Doug Lea's concurrency libra