Tag: DBA Lounge

XPathScript Reborn

A little hacking happened to decouple the core engine from its Apache roots, and XML::XPathScript was born. That module served me quite well throughout the years, but for some time now I’ve had this plan of doing a clean rewrite patiently sitting on my back-burner. This week I had a smashing staycation, and thanks to a very understanding wife, I was able to indulge in the necessary hacking sessions to get the ground work done. The result is not on CPAN yet, but can be perused on GitHub. As an example is worth a thousand pages of documentation, let’s say that you want to turn the piece of docbook-ish xml

Read More >

It’s the End of the World As We Know It (NoSQL Edition)

I think Michael Stonebraker overshot the target In a 2007 paper titled, “The End of an Architectural Era”. Why is this The End? According to Michael Stonebraker “current RDBMS code lines, while attempting to be ‘one size fits all’ solution, in face, excel at nothing. Hence, they are 25 years old legacy code lines that should be retired in favor of a collection of ‘from scratch’ specialized engined”.

Read More >

Beware the /var/tmp/.oracle Hidden Directory!

A few months ago, we had a test instance complaining that it couldn’t write to ASM. This was an 11.1.0.7 single (non-RAC) instance on Oracle Enterprise Linux 5, using ASM for the storage.We ended up booting the server altogether, after which everything came up nicely. We filed an SR with Oracle Support, who directed us to Note 391790.1 (Unable To Connect To Cluster Manager Ora-29701). This note lists the cause, quite simply, as…

Read More >

Shuck & Awe #7: Hunting for Perl

No one is safe from the TPF Inquisition. Alberto Simões cornered Michael Schwern at YAPC and exacted a confession about the state of Test::Builder 2. No doubt threatened by the horrid torments that only torture by the comfy chair can provide, the Schwern spilled the beans.

Read More >

Perl Survey Results In.

Holy Zarquon just released the initial results of the 2010 Perl Survey. The slides are also available. Now for my 2cents worth. Looking at the results I see that very few of the respondents have be ‘taught’ Perl (slide 16) and the majority have an educational background in Computing or Engineering.I think that we in the Perl community should be asking why ‘Perl’ is not being taught at higher institutions.

Read More >

Keeping Up

I’ve just wrote few bits about learning a new technology and after skimming through my Google Reader, I noticed a great post by Gwen Shapira — Deliberate Practice. That’s reminded me about another aspect of learning that I didn’t mention — learning is a continuous process.

Read More >

Oracle UTF8 Encoding and String Manipulation Overhead

For one of our customers, I’ve recently reviewed the strategy of migration from single-byte encoding to variable length multi-byte UTF8 (AL32UTF8 encoding in Oracle naming standards). These type of projects are coming up again and again so I think it must be common for many of you. Thus, this bit might be useful. This is the PL/SQL block I came up with

Read More >

Shuck & Awe #6: Hunting for Perl

Remember me mentioning David Wheeler’s CPAN-like project for PostgreSQL? Well, by now it has an official name — PGXN — and the ball has now been set into motion. This is going to be good.

Read More >

Dist::Zilla autocomplete

Here are two little things I hacked on top of Dist::Zilla that peeps might find useful. The first, as hinted by the blog entry’s title, is a direct adaptation of Aristotle’s perldoc-complete for dzil. The second is actually the one that started that round of shaving for me. As there is about a gazillion Dist::Zilla plugins, I wanted to have a quick way to see all the plugins installed on a specific machine. Enter a new dzil sub-command: plugins.

Read More >

APEX — Bulk Images Upload Using EPG

was recently installing one APEX application and needed to upload a bunch of images. APEX was configured to use EGP (Embedded PL/SQL Gateway) so traditional options were to configure FTP or WebDAV but I’d rather not open these services on production environment. Our resident APEX expert pointed me to the installation process and suggested there is a simple way to do that using a single PL/SQL call. It turned out that it was more than a single PL/SQL call involved but nothing too difficult. What you need is to create the hierarchy of files and directories that you want to upload (images or not – doesn’t matter). Then you create an XML file imagelist.xml listing required directories and files to upload. Here is the example:

Read More >
Page 30 of 68« First Page...10...2829303132...40...Last Page »