Working with PHP and Oracle Presentation

I've just got back from delivering my Working with PHP and Oracle presentation at the Melbourne Opensource Developers' Conference. I don't think the organisers are going to post the presentations, so I wanted to make it available here. This talk covers:

  • Free Oracle tools
  • OCI8 extension
  • Connection management (including the new connection pooling feature)
  • Improving performance
  • XML
  • Oracle resources
Enjoy.

Comments:

Hey Alison, How does PHP fit into Oracle's fusion vision with Java, J2EE web services etc. Is PHP becoming a key technology, or is it going to remain niche?

Posted by Kirk Brocas on December 06, 2006 at 04:16 PM DDUT #

Hi there Kirk. Hope your world is sunny and bright. Oh, it's my world too. We're both in Melbourne! :-) PHP doesn't fit into Project Fusion. Fusion is Fusion. J2EE is J2EE. What we're doing with PHP here is to help the PHP community to work with Oracle. There are no plans to include PHP in our own technology stack, other than to support our customers who are using it.

Posted by Alison Holloway on December 06, 2006 at 04:38 PM DDUT #

Thanks Alison. Just couldn't see where PHP fitted into the picture. And yes, the world is sunny and bright here. That's because there is no ozone!

Posted by Kirk Brocas on December 06, 2006 at 07:22 PM DDUT #

Wish I could have attended your presentation. OSDC looked like fun. I was looking at your presentation, and was a little confused by the statement on p15 "PHP enhancements described here are proposed". Did that just pertain to the Database Resident Connection Pooling section? It looks like great things are in the plans. I am looking to tune my persistent connections from the PHP side and am not sure entirely how it acts if I set oci8.max_persistent or oci8.persistent_timeout.

Posted by Alton Crossley on January 25, 2007 at 05:15 AM DDUT #

Yes, the Database Resident Connection Pooling is a new feature, and that's what the note relates to. Everything else in that presentation already exists in the PHP driver. Setting oci8.max_persistent sets the maximum number of persistent connections the web server will allow at any one time. Setting oci8.persistent_timeout sets the time the persistent connections will live for. You'll need to do some testing and tweaking so you can get the load right for your application and server. Alison

Posted by Alison Holloway on January 30, 2007 at 05:41 PM DDUT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

A blog on Oracle VM, PHP and any other projects I work on.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today