Finding duplicates in PostgresSQL

Recently I had the task of finding some duplicate entries in a PostgreSQL database.

Read more

OSx TimeMachine

I’ve been using Apple’s TimeMachine to perform my computer’s backup. This has proven to be working and I have no complaints so far.

Read more

MarkerWithLabel.js

I’ve been using the lib MarkerWithLabel by Gary Little, available in here(check for the most recent version) and recently had a problem that took me a bit to figure out: How to update the label without having to remove the marker from the map and put it back again.

Read more

Socially (dis)connected

Curiosities about mass public transport

The oldest Metro System in the world is London’s. It was opened in 1863, it has 270 stations and covers 402 km.

Read more

Job interview guidelines

Be likable. Obvious? And critical. Making a great first impression and establishing a real connection is everything.

Read more

Worpress indent text

The problem: I have a piece of code that I want to show indented, but adding blank spaces by pressing the space bar is not solving the issue.

Read more

Rails 3++ translation text with url

Problem: I want to have a link in the translation file.

Read more

Fonts in rails assets

In order to use a custom font in a Rails 4 project, you can either put it under public folder (and configure the css path accordingly) or you can load it from assets folder.

Read more

Denormalising to improve performance?

Chris Date, which advanced the relational data model along with Dr Ted Codd, its creator, got tired of misinformed arguments against normalisation and systematically demolished them using scientific method – he got large databases and tested these assertions.

Read more