Tuesday, March 28, 2006

summary of Oracle/Python discussion

My OTN article on Oracle and Python was kept very brief, to be non-intimidating and to fit within OTN's preferred length. If you've come here, though, you're ready for the rest of the story! I'll use this post to summarize that discussion.
  • Python+Oracle on other Linux distributions - see Andy Todd's blog entry
  • alternatives to fetchone(): fetchmany(), fetchall(), and looping directly on the cursor - see my last entry and this comment
  • Passing an argument to split(), to avoid errors on more complex init.ora parameters - see this comment

3 comments:

  1. Anonymous9:25 PM

    file object also implements iterator protocol.
    You could have used in your read() function.
    For example:
    def read(fileName):
      initParams = {}
      for rawTextLine in open(fileName):
        param, val = rawTextLine.strip().split('=', 1)
        initParams[param] = val
      return initParams

    ReplyDelete
  2. Nice blog, Catherine.

    I too am a Oracle/Google/Vmware/Java enthusiast. And lately given all the fame that Ruby and Python is getting, I'm inclined to take a look at it.

    Anyways keep up the good work and keep blogging ;-)

    Tarry

    ReplyDelete
  3. Anonymous4:03 PM

    This comment has been removed by a blog administrator.

    ReplyDelete