For some time I was struggling with efficient of ts_highligh function of postgres using Rails and pg_search. I had bunch of really long articles and I wanted to highlight search results in the content as well in the title with the power of tsquery and polish dictionary that we feed our database.

In the end solutions was quite simple really, maybe not the most elegant one but does the job just right and in the end your will end up still with ActiveRecord::Relation, so you can easily paginate your results with will_paginate or kaminari gem.

So, let’s break it down.

Quick and useful code snippet that you may want to use eg. while upgrading some old Rails projects. That HAML awesomeness you should use, Luke!

Last week I’ve got a brand new server to play with ;). The mission was clear (I’m going over there, I’m going to do the mission…) - upgrade, install all essential stuff, prepare and migrate the data from the old machine. So here’s what I’ve done so far (except setting up system accounts, ssh access and all that basic stuff).

Here’s small chunk of code that will help you out with testing paperclip. Basically it will stub any fie upload of any instance for given model. So now you won’t be left with ridiculous amount of files created after each test run. Yay!

Lately I have been adding new and new features to existing application and now came time when I have to play with some seriously old code. I mean - really old, forgotten and never refactored code. It’s just there, it’s working and nobody dares touching it. So before I started I need to prepare myself for the battle.

(Link to Part 1) Now let’s look at some tools that can help you migrating messy html into some more easy to maintain format. Obvious choice for many would be markdown, but as markdown is quite geeky I decided to go with well known by average user - and hated by many programmers - BBCode. BBCode would also allow me to implement some custom tags that I needed anyway - so from now we will stick with it.

Whoa, that was a busy week, anyhow, here’s a quick reference for all new android phone users. If you own an old WindowsMobile 5/6 phone and you want to import your contacts and text messages here is a quick receipt (sources: 1, 2). Tools you will need:

For your windows phone:

• SMSExporter
• Dotfred’s PimBackup

For your android phone:

• Gmail account
• SMS Backup & Restore

I will give you some of my thoughts about migrating legacy database to Ruby On Rails framework. Welcome to part one.

I own a little pretty Buffalo Linkstation Mini that - I bought it over a year ago and I decided it’s about time to get this puppy for a spin, so to say. Tempted with idea of installing Debian on it I armed myself with a bunch of tutorials and just went for it.