Seek and ye shall find: full-text search in PostgreSQL

Posted on Tue 18 September 2012 in Databases • Tagged with PostgreSQL, postgresql

I'm at PostgresOpen in Chicago, and just gave my talk on Implementing full-text search in PostgreSQL. The goal was to give novice users the understanding and examples they needed to build a workable search solution using PostgreSQL's full-text search. And it went (in my opinion) well - an almost full room …


Continue reading

CouchDB: delicious sacrilege

Posted on Thu 28 February 2008 in Databases • Tagged with Coding

Well, the talk about CouchDB (an open-source document database similar in concept to Lotus Notes, but with a RESTful API and JSON as an interchange format) wasn't as much of a train wreck as it could have been. I learned a lot putting it together, and had some fun with …


Continue reading

The Linux Documentation Project, DB2, XML, and nostalgia

Posted on Mon 17 September 2007 in Databases • Tagged with DB2

I took a walk down memory lane this evening. I thought I might as well bore you with the details.

One of my first forays into the open source world was to participate in the Linux Documentation Project (TLDP). At the time (circa 1999), I was working for IBM as …


Continue reading

Java 6 is out; now including JavaDB (aka Apache Derby)

Posted on Tue 12 December 2006 in Databases • Tagged with Apache Derby

A quick little note to mention the official release of Java 6. Okay, Dan, but why do you care?, you might ask. Good question, oh person-who-does-not-read-headlines.

The reason I care is that Sun chose to bundle Apache Derby in this release -- take a peek in the /db/ subdirectory of the …


Continue reading

Neat-o: Archimède uses Apache Derby

Posted on Tue 14 November 2006 in Databases • Tagged with Apache Derby, Coding

A while back I mentioned on the DSpace-devel mailing list that I was interested in adapting DSpace to use embedded Apache Derby as the default database, rather than PostgreSQL, as a means of lowering the installation and configuration barriers involved with setting up access to an external database. I haven't …


Continue reading

In-depth _and_ official DB2 and PHP documentation

Posted on Tue 13 June 2006 in Databases • Tagged with DB2, PHP

I should have mentioned this before, but now that I noticed Chris Jones' post on the Underground PHP and Oracle Manual, I felt obliged to point out that one of the final fruits of my labours at IBM is now visible in the DB2 "Viper" Information Center -- a set of …


Continue reading

ibm_db2->close()

Posted on Mon 27 February 2006 in Databases • Tagged with Personal

After almost eight years, today is my penultimate day at IBM.

I've done a lot of interesting work for IBM in that time. From learning about Linux back in 1998 by testing the pre-release DB2 Version 5.2 beta for Linux, to writing the original DB2 for Linux HOWTO for …


Continue reading

ADOdb: getting good support for IBM DB2, Cloudscape, and Apache Derby

Posted on Fri 10 February 2006 in Databases • Tagged with DB2, PHP

The stable release of the ibm_db2 PECL extension for IBM DB2, Cloudscape, and Apache Derby brought a high performing, highly functional database connectivity alternative to Unified ODBC for PHP 4 and 5 users. However, in and of itself a database extension does not enable you to use the many …


Continue reading

(Un)common but potentially mind-twisting DB2 issues

Posted on Wed 18 January 2006 in Databases • Tagged with DB2

It is perhaps a sad reflection on my life that I'm using a personal blog to offer technical information about a product that I work on, rather than telling you about what I ate last night (spinach and goat cheese salad with a raspberry vinaigrette dressing, quinoa, and a rather …


Continue reading

DB2 validated for use on Ubuntu

Posted on Wed 09 November 2005 in Databases • Tagged with DB2

Good news for all you DB2 for Linux people who love Ubuntu -- IBM just validated Ubuntu as a Linux distribution on which IBM is willing to offer its enterprise level support. You can see that Ubuntu was excited in their press release about the accomplishment. And rightully so: no other …


Continue reading