This is the answer to last week’s Problem of the Week: One thing that I like to do when solving these types of problems is determining what percentage of the work each participant will do. The problem stated that Tasheera takes 16 seconds for each balloon, whereas Omar takes 18 Read more…
A while back, when I first starting working with OpenKM, I accidentally removed the UserRole role from the root directory. For the longest time, I had know clue how to add the UserRole role back to that folder, or any other folder for that matter. Today, after playing around with Read more…
A group of friends are preparing for a party. Tasheera and Omar are in charge of preparing the balloons. Tasheera takes eight seconds to inflate each balloon, three seconds to tie each, and a five second break in between each one. Omar takes ten seconds to inflate each balloon, five Read more…
Today, I was asked how to select each element in an array as a separate row. In other words, I needed to convert an array into rows (one for each array element). Below is the right way to do it by using the built-in unnest() function (requires PostgreSQL 8.4+): If Read more…
I was surfing the internet a bit today and starting thinking about universally unique IDs. I came across this site which generates the UUIDs on the server side and then decided to make my own pseudo globally unique ID generator: You can use this function to generate as many UUIDs Read more…
Recently, since the DBA wasn’t available, I had to assume his duties and grant SELECT privileges to a user (let’s say john_doe) for all of the tables in the public schema. After quite a bit of research (Google of course), I learned about the pg_tables view. After realizing that this Read more…
As many of you may know, in JavaScript, you can define a date object by specifying a string that looks like a date. Recently I created a page using AJAX to get counter information, including the date/time that the page was hit. I thought that a pretty straight-forward format that Read more…
Over the past year I have been learning about so many different OpenSource packages it isn’t even funny. One thing that is available for free, but also has a paid version (which we at using at UniTek Global Services), is JasperServer. Right now we are on version 4.2.1. When we Read more…
The following is an implementation of a binary search for arrays which gives you the ability to do fuzzy matches (default), exact matches, or specify your own comparison function: I used the following to test the normal execution of this binary function:
One thing that I came to grips with today is the fact that if an error occurs in one of the functions that was bound to the document’s ready pseudo-event (I say this because the event doesn’t necessarily exist in every browser) by using jQuery, none of the subsequent callback Read more…