THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Choosing the Appropriate Driver

For this blog I have compiled the main information specifically considering 11gR2 platform, but the concepts and idea also apply for older platforms as well.

Oracle provides the following JDBC drivers:

  • Oracle Call Interface (OCI) driver: For client-side use with an Oracle client installation.
  • Thin driver: A pure Java driver for client-side use, particularly with applets. It does not require an Oracle client installation.
  • Server-side Thin driver: Is functionally the same as the client-side Thin driver, but is for code that runs inside Oracle Database instance and needs to access a remote server.
  • Server-side internal driver: For code that runs inside the target server, that is, inside Oracle Database instance that it must access.
  • Read the rest of this entry . . .

    Shuck & Awe #7: Hunting for Perl

    [yanick@enkidu shuck]$ perl -MXML::LibXML \
        -E'say $_->toString for \
            XML::LibXML->load_xml( location => "news.xml")\
                       ->findnodes( q{//news[@lang="perl"]} )'
    

    No one is safe from the TPF Inquisition. Alberto Simões cornered Michael Schwern at YAPC and exacted a confession about the state of Test::Builder 2. No doubt threatened by the horrid torments that only torture by the comfy chair can provide, the Schwern spilled the beans.

    For the readers who aren’t BFF with Perl’s grep function yet, smash provides a little example how this function can help making your code shorter, faster, and most important, easier to read.

    Read the rest of this entry . . .

    Liveblogging at Confoo: [not just] PHP Performance by Rasmus Lerdorf

    Most of this stuff is not PHP specific, and Python or Ruby or Java or .NET developers can use the tools in this talk.

    The session on joind.in, with user comments/feedback, is at http://joind.in/talk/view/1320.

    Slides are at http://talks.php.net/show/confoo10

    “My name is Rasmus, I’ve been around for a long time. I’ve been doing this web stuff since 1992/1993.”

    “Generally performance is not a PHP problem.” Webservers not config’d, no expire headers on images, no favicon.

    Tools: Firefox/Firebug extension called YSlow (developed by yahoo) gives you a grade on your site.
    Read the rest of this entry . . .

    OpenSQLCamp Lightning Talk Videos

    OpenSQLCamp was a huge success! Not many folks have blogged about what they learned there….if you missed it, all is not lost. We did take videos of most of the sessions (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded).

    All the videos have been processed, and I am working on uploading them to YouTube and filling in details for the video descriptions. Not all the videos are up right now….right now all the lightning talks are up.

    Read the rest of this entry . . .

    Kuassi Knows Everything About How To Connect to an Oracle Database and Much More

    As you already know, I’ve spent a whole week near Redwood, California. Saying that the week has been difficult to manage is a euphemism:

    • My heater engine broke at home (I didn’t even know it had an engine!), almost leaving my children in the cold for a night. Thank you, people have been so helpful that day!
    • The snow storm in Canada prevented my plane from taking off from Chicago to Ottawa Saturday afternoon.
    • The same snow storm prevented even the bus from leaving Boston after I decided this could have been the best, and only way to go, and found a plane to go there.
    • And many more bad stories I don’t want to talk about . . .

    However, the week has been more than useful. I have worked very hard, and had some very good fun too. As always, I’m amazed what people are able to do with Oracle technologies. We’ve learned a lot from the good and bad experiences of several Oracle customers. Unfortunately, there is not a lot I can tell you.

    Here is something I can share anyway: one of the things I’ve liked the most is to spend some time (not enough!) with Kuassi Mensah. The guy is awesome! As a Product Manager at Oracle, he knows probably everything about JServer (the JVM in Oracle 11g), and he is one of the best guys on the subject of some of the key connection layer to access an Oracle database, including JDBC, OCI, and Web Services.

    If you’re interested by any of those subjects, you should subscribe to his 360° blog and read his book. If you’re lucky and can attend the Conférence PHP Québec in Montréal this week, rush to his presentations, especially the one about the Database Resident Connection Pool.

    Hey Kuassi! I hope the weather will be nice in Canada now that I’m back home. However, you may have to rename your blog “36°” for the end of the week — which is not so bad in this winter.

    Start NowWith Pythian - database design, management and emergency handling capabilities...

    Live Updates

    pythian: RT @FN_Press2: Schooner Information Technology Teams with Pythian to Deliver Advanced Support and High... http://finanznachrichten.de/20
    more



    Testimonials

    • Serge Racine

      DBA, Brookfield Energy

      We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more