In the uncharted backwaters of the Internet there exists a really awesome tool called rlwrap. This readline wrapper is able to call programs that are deficient in modern amenities like history, color, and tab completion, intercept input/output, and replace it as necessary with useful goodies. And what program could be
Getting Busy with Riak
Welcome back to Database Diversity, where the queries are made up and the relationships don’t matter. Today we’re going to talk about a simple yet insanely powerful NoSQL Database called Riak. While its core functionality is a key/value datastore, Riak is capable of so much more: full text querying, MapReduce,
A Few Words on Oracle Licenses
Despite reams of legalese and countless blog/forum posts, basic Oracle RDBMS licensing still remains a mystery to many. While I won’t even begin to discuss components like Oracle Apps, hopefully this post may help you attain a basic understanding of Oracle, what you can license, and what it costs. Editions
Deploying Outside the Box
I’ve been on quite a “broaden your horizons” kick lately, as evidenced by my team and DBA development posts and ultimately the Database Diversity series (in progress). But I truly think it is important to keep not only aware but conversant in emerging technologies both for your personal benefit and
Start Using MongoDB
Guten Tag, Namaste, Hola, Zdravstvuite! While you should always work to master your first language, a simple understanding of other cultures and their languages is always beneficial. In these days of social/career networks and rising global connectedness, being open to diversity is an absolute must. This is true in the
The Overly Shared Pool
Ever been in a really crowded pool? I have… and chances are so have your queries. This article will go into a little bit of high level detail about the shared pool and a portion of what it does for us, then show a real “good pools gone bad” issue
DBA, Grow Thyself – Moving and Shaking in the Era of Data Dominance
Beefing up your technical skills is important, and it’s what makes you a good DBA, Developer, Architect, or whatever you happen to be. But at the same time, it is incredibly important to keep up with the professional trends in your organization. While all organizations are different, there are some
DBA Team, Front and Center
A lot of database professionals seem to agree that the DBA acronym stands for “Default Blame Accepter”. Indeed, I’d be lying if I said that I’ve never felt that way. But I believe that a more in-depth look into why the DBA team always seems to be at the center
5 quick and dirty Linux tips you may not know
Remember that day you were sitting at a friendly bash$ prompt and discovered tab completion? It was like a choir of angels came down from the heavens and sang Hallelujah, the Shell Hath Come (yes, that’s a bourne again reference). While these 5 tips may not be that monumental, they
blobFS – Imported an Oracle dump from a BLOB using a FUSE filesystem
For those who have not been following, I reported previously that I had created a query-based filesystem with node.js, fuse4js, FUSE, and Oracle. This filesystem is mountable by any OS user and uses queries against Oracle tables as its source instead of disk. In this specific case, a table containing