Meditations on programming, startups, and technology
Currently Browsing: IBM

IBM_DB 2.5.0 with support for Rails 3 is out

This is a tiny post to let you know that IBM just released version 2.5.0 of the IBM_DB gem with support for the upcoming Rails 3. That’s what I call both proactive and a true testament of IBM’s commitment towards DB2 on Rails. Aside from providing a working adapter and driver before the new framework release is even out, this release has a few improvements and fixes, such as getting rid of a minor...

Rails, DB2 and the Enterprise

Recently Matt Aimonetti wrote an insightful article about Rails and the Enterprise. In it he identifies five core Enterprise application needs: Reliability Support Performance Advantage over the competition Integration and transition path Matt then proceeds to illustrate how Rails does a good job in regards to most of these points, despite a few existing challenges. Among these challenges, I can clearly see the...

DB2 support for Django 1.2 is here

The latest release of the IBM Adapter for Django now supports Django 1.2. Aside from enabling you to use the most recent version of Django, this release adds a few new goodies into the mix, that I’m sure many will appreciate. For example, IBM’s adapter (through the underlying DBI wrapper) now uses persistent connections, which are especially helpful when dealing with Django – as it lacks connection...

Heads up: IBM is looking for top notch student hackers

As a thank you for following my blog, I’d like to introduce you to what I think is a great opportunity for the right students. My team is looking for two bright students for a 16 month, full-time internship opportunity with IBM. Aside from being a bright and ambitious student, you should currently be working towards a Computer Science degree at any recognized University in the world (and have completed at...

DB2 support for Ruby/Rails turns 2.0

This article is obsolete. Please refer to the following articles for up do date instructions: Ruby/Rails and DB2 | Python/Django and DB2. Thank you! The API development team just released a major version of the ibm_db gem. Detailed installation instructions are available on RubyForge (PDF). Among several improvements, there are three particularly newsworthy features: Support for Ruby 1.9; Support for mingw32, used...

Grab DB2 Express-C 9.7.1 now and join the DB2Night Show

IBM just released DB2 Express-C 9.7.1 (aka DB2 Express-C 9.7 FixPack 1). This version includes a long list of enhancements. Don’t forget to download and install it; as per its previous versions, it’s entirely free of charge. You can grab it directly from here: DB2 Express-C for Windows DB2 Express-C for Windows x86-64 DB2 Express-C for Linux DB2 Express-C for Linux x86-64 DB2 Express-C for...

What is DB2 pureScale?

There are two main types of scalability: vertical and horizontal. Vertical scalability consists of potentiating the hardware specs of a given server. This is typically done by increasing the number (and to a minor extent, speed) of the processors, adding more RAM, and so on. Commodity hardware tends to impose a strong limit on the resources that can be augmented. There is only so much that can be stuffed into your...

Installing and configuring DB2 Express-C 9.7 on Ubuntu 9.04 Server

DB2 Express-C 9.7 can easily be installed on Ubuntu 9.04 Desktop edition by simply issuing sudo ./db2setup. This will open up a launchpad and you’ll be able to install the product through a wizard. But what about setting up DB2 Express-C 9.7 on Ubuntu 9.04 Server edition? When you are ssh-ing into your VPS or dedicated sever, there are no GUIs to help you out. IBM provides all the information on how to proceed...

Improve the speed and security of your SQL queries

An easy way to improve the performance and security of SQL queries is to replace literals with parameters. By replacing literal values with parameters, advanced relational databases will be able to compile your queries and have their execution plans cached. This saves time and precious resources when the same query (minus the actual values) is executed over and over. Consider the following series of...

Enabling support for DB2 and Python/Django/SQLAlchemy on Mac OS X Snow Leopard

This article is obsolete. Please refer to the following articles for up do date instructions: Ruby/Rails and DB2 | Python/Django and DB2. Thank you! This is the Python version of a post I made about Ruby a few days ago. Now that Mac OS X 10.6 is out, it’s time to leave the world of 32 bit computing behind. The pre-installed Python interpreter will run in 64 bit mode by default, so you may need to pay attention...

Installing the Ruby driver for DB2 on Mac OS X Snow Leopard

Now that Mac OS X 10.6 is out, it’s time to leave the world of 32 bit computing behind. The pre-installed Ruby interpreter will run in 64 bit mode by default, so you may need to pay attention when installing some C-based gems. The ibm_db Ruby gem for DB2 can easily be installed or updated to the latest available version by following these simple steps: $ sudo -s $ export...

DB2 on Mac OS X Snow Leopard

Earlier today I headed over to the local Apple Store to purchase a copy of Snow Leopard, the newest version of Apple’s operating system. There was a decent line up, as I expected. Not the kind of line up you’d encounter with the launch of a new iPhone, but it was fairly busy for a Friday morning. When I arrived, I took my place at the end of the queue where rumors were swirling around about the store...

The DB2 adapter now supports Django 1.1

This article is obsolete. Please refer to the following articles for up do date instructions: Ruby/Rails and DB2 | Python/Django and DB2. Thank you! I’m glad to announce that the API team has just released version 1.0.2 of the adapter for Django. And on my birthday to boot, what a nice present. This version extends its support to the recently released Django 1.1, as well as incorporating the feedback that was...

Reasons to switch to DB2 9.7

IBM recently put out a video with a few quotes from customers who’ve had a chance to try DB2 9.7 in production. At times the editing is a bit cheesy, but what our customers are saying is factual. DB2 9.7 is quite a breakthrough and it can save millions of dollars for large companies. If your needs are more modest, like a demanding Web application or a point of sale server, DB2 Express-C can still give you most...

DB2 Express-C 9.7 and the Django adapter released

This is a great day for those of us who love DB2, as DB2 Express-C 9.7 has just been released. As mentioned before, this is the best DB2 ever, and an extremely important release. To learn more about what’s new in this release, please check out the recording of our latest webinar: If you run Linux, Unix or Windows, download it while it’s hot. DB2 9.7 on the Cloud Another great aspect of this release...

Do Androids Count Electric Sheep with DB2 or MySQL?

Counting rows is an ubiquitous operation on the web, so much so that it’s often overused. Regardless of misuse, there is no denying that the performance of counting operations has an impact on most applications. In this post I’ll discuss my findings about the performance of DB2 9.5 and MySQL 5.1 regarding counting records. For those of you who are not into science fiction, let me clarify that the odd...

TextMate bundle for DB2

Before leaving on a recent business trip to Italy I begun working on a TextMate bundle for DB2. Here I’ll introduce it in the hope that it will interest some TextMate and DB2 users. Installation There are two simple prerequisites for using this bundle: 1) Install DB2 as a regular user (not root); 2) Source the db2profile by, for example, adding . ~/sqllib/db2profile to your shell profile (e.g., in ~/.profile)....

Screencast on how to install DB2 Express-C on Mac OS X

Over the weekend I recorded a screencast on how to install DB2 on Mac OS X. You can watch it below: Installing DB2 on Mac OS X from Antonio Cangiano on Vimeo. The blog post I reference within the video can be found here. Yes, that’s an Italian accent. I hope you don’t mind it. ...

The Best DB2 Ever

Over the past few days the spotlight has certainly been on Sun’s acquisition by Oracle, but today IBM made a remarkable announcement of its own. DB2 9.7 (code-named “Cobra”) will be GA (generally available) in June. This new version of DB2 is loaded with interesting features and is undoubtedly the best DB2 ever. Within IBM we consider this to be the single most important release of DB2 since the...

IBM Cloud Computing Webinar

Photo by Kevin Dooley The IBM Toronto Software Lab periodically runs webinars on information management related topics, which are called DB2 Chat with the Lab. These tend to be highly informative sessions, which wrap up with a Q&A time that enables attendees to openly ask questions on the subjects that were discussed during the talks. Best of all, these sessions are absolutely free to the general public and...

« Previous Entries Next Entries »

Copyright © 2005-2012 Antonio Cangiano. All rights reserved.