Category Archives: Uncategorized

Where the Startups Roam – Top Startup Cities in the US

As a high-tech entrepreneur I’ve always thought about relocating to one of the top startup cities in the US. But which cities are these? Besides the Silicon Valley many cities have claimed at one point or another to be the … Continue reading

Posted in Uncategorized | 7 Comments

Benchmarking PostgreSQL queries

In order to benchmark my SQL queries on PostgreSQL databases, I like to check the run time of the queries in two situations: with caching and without caching. If the query runs often and accesses the same pages in memory, … Continue reading

Posted in Uncategorized | Leave a comment

PostgreSQL help and resources

Whenever I want to try something new with a PostgreSQL DB the first thing I do is check if there is someone else out there who has already encountered my problem and has solved it for me. Around 90% of … Continue reading

Posted in Uncategorized | Leave a comment

PostgreSQL select with default value

I recently ran into a situation in which I wanted to select data from a table, and wanted a default value in case the data does not exist in the table. The straightforward solution is to use a CASE statement … Continue reading

Posted in Uncategorized | 2 Comments

Postgresql: Creating unique values from a non-unique field

Suppose you have a database table with a field that currently contains non-unique values. Now suppose you want to update the aforementioned field to contain only unique values, but you don’t want to update any values that were already unique. … Continue reading

Posted in Uncategorized | Leave a comment

Sluggish PostgreSQL Databases and Reindexing Indexes

The natural process of erosion affects not only the organic elements of the Earth, but also the hardware we use, the code we write, and the databases we keep. When it comes to maintaining databases, there are several things that … Continue reading

Posted in Uncategorized | Leave a comment

My fonts look different in Firefox

One of the most annoying parts of web development is making sure your website looks the same on all browsers. A few days ago I noticed that on one of my websites the fonts are different in IE and in … Continue reading

Posted in Uncategorized | Leave a comment

Adding a new Bugzilla version to all products

The Bugzilla GUI doesn’t support adding a new version to all products. I used to add new versions to each product one by one. This got very tedious and annoying, especially as the number of products grew. I searched online … Continue reading

Posted in Uncategorized | 4 Comments

‘ERROR: Garbage option.’ when using ps and awk

The other day I wanted to create a simple bash script that would receive the name of a process and print out its pid. I wanted to run ps and then use awk to filter out the correct process and … Continue reading

Posted in Uncategorized | Leave a comment

Improved SWIG C# wrappers for std::vector and std::map

My previous posts on this topic part 1 and part 2 were posted about half a year ago. Since then SWIG version 1.3.40 has been released and it includes several enhancements in the C# wrapper for std::vector and std::map based … Continue reading

Posted in Uncategorized | 1 Comment