How to deal with picky clients — Red Rabbit Technique

Here is a secret I would like to share with you. I bet that anyone who ever seriously worked as a web designer encountered a client (or clients) who always needed to change at least a pixel of your design. It can be a masterpiece – no matter what you create – but they’ll always [...]

rsync – synchronize web server and your local computer

When developing sites it’s always a pain to upload updates on server, i.e. to synchronize server with local copy of the files. This is especially true if you have a site which you don’t keep under version control (although there is no good reason for that) or if your hosting company doesn’t have CVS / [...]

How to sort MySQL results ignoring definite and indefinite articles (the, a, an)

We recently had a problem – we needed to sort MySQL result based on Title column, but while sorting we needed to ignore both definite and indefinite articles (i.e. ‘a’, ‘an’, ‘the’). Although this is an frequent request (people mostly want to ignore articles when sorting), we didn’t find a lot of solutions. Those which [...]

How to use lorem ipsum

Few days ago I read this article on Signal vs Noise Blog. Even though I respect their work and oppinions (after all, we are using their products), this particular article I coundn’t completelly agree on. As you’ll be able to read – they are strongly suggesting you shouldn’t use Lorem Ipsum as your “content-here” text. [...]

How to add multiple files to Subversion

After switching completely to Ubuntu I also had to switch from TortoiseSVN to plain svn command line. The problem I have is that I don’t see any way to add multiple files to SVN with one command. I want to be able to add ALL files that aren’t under Subversion version control and use a [...]

Install Ruby and Ruby On Rails on Ubuntu

Recently I started messing around with Ruby and I wanted to set it up on our local server, so I gave InstantRails a go – and it worked perfectly. Meanwhile we changed our operating system and switched from Windows to Linux (Ubuntu Dapper), so now I needed Rails for Ubuntu. Unfortunately (or luckily) there is [...]