DBA Lounge

PostgreSQL Administrator’s Cheatsheet

Most people start with free databases and eventually get to know the enterprise products. I started the other way around. After being trapped for eight years in the Oracle world, I felt like exploring another database platform. For some reason I can’t get myself to fiddle around with MySQL. There’s nothing rational about this–no benchmarks, reviews, or co-worker horror stories. I feel it’s just not my type. So when looking for free database, I reached out for PostgreSQL, again for no objective reason–only the gut feeling that this could be what I’m looking for.

Oracle Streams Apply Process changes in 11GR2

It is somewhat timely that we’ve been doing some Oracle Golden Gate testing which in turn made me curious to take a closer look at Oracle Streams in 11GR2 and see where all the performance is coming from. I’ve setup a simple replication for table t1 from schema src to schema dst, changed Apply Server parallelism to 1 and did a simple test with inserting 100 rows while performing a sql trace. Let’s get started.

Oracle 11.2 Silent Installation on OpenSolaris

When Oracle announced Oracle 11.2 for Solaris (x86-64), I decided to try a silent installation of Oracle on OpenSolaris, even though it is not certified. I downloaded the Solaris ISO and installed it as 64-bit on one of my virtual machines without a problem, I was soon enjoying OpenSolaris. I eventually stopped admiring the good-looking interface and connected through a plain old black-and-white ssh terminal to execute the silent installation. Based on the silent installation that I had earlier executed on Linux for 11.2, I started the following…

Today’s Perl Lesson

One thing I find fascinating in Perl is that I am always seeing new ways to perform the same mundane task. Today I had to output some tabular data, so I thought it would be nice if I alternated colors for each row. Easy enough in Perl—just create a hash with your colours as the value and then the swapping variable as the key, like this…

C.J. Date’s Seminar Not to Miss in January 2010

I’ve recently learned that Chris Date is giving a three days seminar. It must be one of the unique opportunities to learn from the world renown expert in relational database theory. The seminar title is “How to Write Correct SQL and Know It: A Relational Approach to SQL”. It’s focused on writing reliable SQL. While SQL has been designed as a simple access interface to relational data, it turned out to be quite complex and requires your to follow a certain disciplines to produce truly reliable SQL code — relational discipline.

DBD::Oracle on AIX 5.1

I installed DBD::Oracle on an IBM AIX 5.1 box, and for once I have some good news. Anyone who has ever tried this will know of some of the troubles I speak of. When dealing with DBI and any DBD on a AIX box, you either must either be lucky enough to have the same compiler installed that built the version of Perl that comes with the box (I have never seen this happen); or you have to spend a great deal of time downloading and installing your own GCC and the building your own version of Perl. Fortunately, all the hard work was done for me by other members of my team. Here’s how to do it.

Perl CGI::param Overloaded Method?

This is a little story of a little bug. This gremlin suddenly appeared in a CGI.PM web-based application I work with. To make a long story short, an email was coming out something like this . . . I discovered that the page was in fact receiving three values for CGT::param(“rep_no”) when user was of type ‘B’, and thus sending that as an array to the send_TXT_email method, and as a result, buggering up the email content. Even more digging I found out the root cause was a web page that was three pages back from the one that was sending the email. Here’s the quick fix.

Ottawa Perl Mongers Presents: FormFu Assassin

Once more, the Ottawa Perl Mongers assemble! I’ll be presenting on how I’m implementing AJAX forms in a Catalyst application, using the deadly magic of Mason, Prototype, and FormFu. Pizza will be graciously provided by Pythian. So if you plan on coming, please let me know so that I can be a good little ninja and make the number of slices match the number of attendees.

Page 34 of 67« First Page...10...3233343536...40...Last Page »