If you want to validate virtually any date (formatted as YYYY/MM/DD or YYYY-MM-DD) in JavaScript with a regular expression, you can use the following (fixed on August 8, 2013): This was actually inspired by the regular expressions from this post. Of course, the best way to check a date’s validity Read more…
Someone had an issue today where they were using a string as if it were a regular expression. Not totally understanding what the desired end result would be, I had suggested they use something equivalent to Java’s Pattern.quote() function. It turned out that they really just wanted to determine if Read more…
A while back, I wrote a function about Solid Type Checking. What is funny is that I often am writing just a bit of JavaScript in which I need a better way of checking the type of an object or primitive. Unfortunately, since I have been slacking on the next Read more…
There have been many times when I needed a way to define a function (or variable) only if it wasn’t already defined. Since this seems to be such a common situation, I decided to write a function which will only define a variable, in a given namespace if a definition Read more…
One thing that most JavaScript writers do now, which is a good practice, is they create namespaces for their functions and variables. The following is a definition for a function that can be used to easily create namespaces of any depth: I have to admit, this idea is not originally Read more…
Recently at work we had the need to convert a string parameter (passed into an iReport) into a table. For many people, the first thing that may come to mind is either the STRING_TO_ARRAY(...) function combined with the UNNEST(...) function. The biggest issue with using just those two functions is Read more…
Something that I did before, but never documented until now was querying the database for all of the PL/pgSQL function definitions. In PostgreSQL, you can run the following to pull all of them along with the owner, schema, function name, and function definition: Of course, you can modify the above Read more…
One of the things that I am not all that thrilled about is the fact that at times it is hard to find examples of PostgreSQL queries or plpgsql functions. For this reason, I want to help out anyone who would like to see an example of converting a query 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…
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: