Transitions in teaching computing and science
Are you interested in using DB2 with your PHP web applications on Windows, but not interested in compiling the driver?
For many years there was a PHP website that you could go to and download Windows PHP extensions as DLLs to extend the capabilities of your website. For some reason the site has been down for many months.
Since the PHP driver for DB2 is not provided as a binary with DB2 itself and you can no longer download the DLL from the PHP community website, I'm posting it on the IBM Database wiki for everyone to access easily.
An excellent set of instructions on setting up DB2 and PHP web applications is available on the DB2 at UofT website.
Want to build better DB2 applications? Join me on Wednesday to learn more and share your insights !!
Save the date !!
Wednesday, November 7th at 11am ET.
Join myself and Chris Gruber (Technical Manager, Developer Initiatives for IBM Data Servers-DB2 and Informix) as we share our thoughts and insight into the new DB2 for LUW 9.5 release and the new IBM Data Studio.
During the webcast we will cover the latest in:
Everyone around me these days are heads down preparing for the single largest IBM Information Management conference on the planet.The inaugural event was a big success in Anaheim last year and 2007 is going to be bigger and better.
If you haven't registered for the event itself or if you have registered, but not decided which sessions to attend I would suggest you consider signing up for some of the excellent sessions planned for the Developer Den or the Hands-On labs. Register now ..
Okay, why did I mention DB2 Express-C in the title of this blog post?On Wednesday at the conference there is a beer bash planned, hope to see you there.
JPA - Java applications and databases, the easy way !!
Mapping the Java object world with the relational database world has never been a simple task.
JDBC is an powerful API, but it has so many classes and methods it is easy to make a coding mistake, especially if the database design changes. Every change in the physical data model requires a code analysis to ensure the JDBC code doesn't need fixing.
SQLJ is a more productive alternative, but it does require an extra translation step during development. We provide excellent SQLJ editing tools with IBM Rational Application Developer and DB2 Developer Workbench to make perform the translation for each SQLJ file. SQLJ applications gain a performance and security advantage when they are customized for DB2 as static SQL access plans come into play.
But, SQLJ doesn't solve the object/relational mapping issues.
Along comes Hibernate as an open source alternative and other proprietary alternatives like TopLink and others.
Entity EJBs worked, but they involved extra Java classes and "really" require tools to assist in the development and deployment tasks.
JPA is the EJB 3 persistence standard that is coming to life in 2007 with various implementations. JPA can be used with Java SE and Java EE environments and it will make and ideal Java interface for Informix Dynamic Server (IDS) and DB2. It's time to take a look at this new framework and see how it fits with your Java / database needs. A
n excellent book is Pro EJB 3: Java Persistence Architecture" by Mike Keith and Merrick Schincariol. It was an excellent read over the past week and I plan to try some experiments with OpenJPA and DB2 in the near future.
Longish flights that leave early in the morning always give me a chance to accomplish two things:
During this flight I was prepping for a conference with WebSphere gurus from IBM. My plan is to extoll the virtues of XQuery and generally storing/querying XML data in DB2 9. I remember reviewing early drafts of an IBM redbook on DB2 pureXML late last year, but this redbook has really improved and I highly recommend it as a source for you to learn and understand XQuery with DB2 from a developer's perspective.
Checkout this redbook, it has excellent examples including a nice Java Web application, called XMLoan, that was simple to deploy (now I'm examining the source code and overall design). The deployment was to Tomcat, but this could be easily deployed into WebSphere Application Server Community Edition v1.1 or WebSphere Application Server v6.1.
Switching from software to hardware in one paragraph. If you are looking for noise-cancellation headphones that don't make you look like a recording engineer I recommend these Seinhesser PXC250 headphones. The worked very well to virtually elimnate that annoying engine noise during the flight and unlike some other headphones in this category, they don't cost a small fortune.[Read More]
We now have a complete solution for Ruby and Ruby on Rails fans for accessing the entire DB2 set of servers.
The new Ruby driver and Rails adapter are available now on RubyForge the IBM development team is ready to hear from you with your feedback.
Download and give it a try.
This release is a follow on to the initial Ruby driver and Rails adapter for DB2 made availabe on IBM Alphaworks.
Have fun.[Read More]
Now available Zend Core for IBM with the new DB2 Express-C 9 integrated !!
The recent news from the Zend/PHP Conference this week in San Jose included the announcement of the latest release of Zend Core for IBM.
I'm downloading the final external version today to check it out on Linux. Report coming later this week.
I also just ordered a new home computer system the Dell Dimension 9200/aka XPS 410. I'm looking forward to trying out the Digital Video editing capabilities of this new system and then also trying out Vista ( they say it is only 1 week away now ).[Read More]
Last week was excellent at the IBM Information on Demand Global Conference in Anaheim. The entire event went very well, I was very busy getting the Developer Den ready for Monday, we had 30 laptops available for people to try out 13 different tutorials ranging from PHP, .NET, Cloudscape, IDS, and DB2. The short talks held in the Developer Den were also well received. It is difficult to have everything going on at the same time as we had a lounge area at the back and self-paced tutorials and talks occurring throughout the day.
Developer Den v1.0 went well, and I'm looking forward to IOD 2007 and helping out where I can. The most popular tutorials included: Cloudscape with Ajax, PHP with Ajax, DB2 on Rails, and the new Eclipse based DB2 Developer Workbench.
If you live in the San Francisco/San Jose area or the Kansas City area sign up for the free 1 day seminar on DB2 9. I'm looking forward to meeting people at these two events.
Here is the agenda:
and you can register for free here.
With the IOD 2006 conference now over it is time to focus on my new job as the Product and Release Manager for DB2, IDS drivers and tools for Developers and DBAs. Let me know if you have ideas for the DB2 Developer Workbench, Drivers (APIs), and or Visual Studio 2005 tools for IBM data servers.[Read More]
Great news to start the month of August.
DB2 Express-C has been recognized as one of the top 45 software products for the midmarket by VARBusiness.
This award is referring to DB2 Express-C v8.2 and now we have the new DB2 Express-C 9 hybrid pureXML data server available for everyone. Have you downloaded it yet ?
I'm a bit behind on my recent travel updates. Travelling by train from Toronto to Montreal on VIA 1 is always a great time. Now VIA Rail offers 24 hours of Wireless internet on the train for less than $10 CDN. Downloading large files is a bit slow, but otherwise it's like sitting in your office travelling 100 KM/hour with food and drinks ;->
The PHP|Quebec conference was an excellent experience, I would definitely recommend it to anyone interested in PHP (novice or experienced). My session Optimize your Data Access with DB2 Viper went well. There were probably 15-20 people and lots of great questions during the talk.
My presentation should be uploaded to the PHP|Quebec conference site at some point soon.[Read More]
The updated TIOBE index has been published.
It shows continued strength for Java and C. It is also interesting to see Ruby crack the top 10 of this survey. The survey technique is very interesting as it includes multiple search engines for job postings and courses offered.
These days I've been working on upcoming event plans including:
Come and join me for my talk on Tuesday, XML to the Max - DB2 Viper with PHP. I'm looking forward to the event next week with multiple keynotes and lots of interesting people.
I'm co-presenting with Leon on Sunday, May 7th Building leading edge DB2 applications: a practical approach.
Then I plan to help introduce people to some of the great new features of DB2 Viper during the expo from Monday to Wednesday.
Bring your laptop so you can spend sometime taking the DB2 Viper test drive, you'll be glad you did.
Next event, JavaOne 2006.What is it with software conferences in May ?
I'm definitely glad that my 3 week summer vacation is already book !!
New free book on PHP for DB2, IDS, and Cloudscape