Hibernate, triggers and yo-yo update

While using Hibernate to manage DB operations in your application you may also need to use triggers to perform specific updates directly inside DB. But if you're using both update methods it's essential to protect yourself against yo-yo effect.

Disable font autosizing in Chrome on Android

Chrome on Android has a feature called 'Font Boosting' which resizes text to make it larger once a paragraph of text reaches certain length. This maybe useful for a reader but also can destroy a layout of your web page.

Workaround for LESS Compiler in Intellij IDEA 13

After updating IntelliJ Idea to version 13, plugin which compiles LESS files to CSS stopped working, but we've got it working.

Dreadful 'deleted entity passed to persist' exception

From time to time I encounter the following exception: 'javax.persistence.EntityNotFoundException: deleted entity passed to persist'. It's nasty because its stack trace doesn't suggest a source of the problem. Thankfully it's also very easy to fix.

Concatenating with NULLs in SQL

A concatenation of 2 or more values in SQL looks like a pretty simple operation. It's enough to use '||' operator which comes in SQL standard. Well, it turns out that this is not so trivial in case of NULL values.