Category Archives: Uncategorized

Replace WordPress Search with Own Algorithm

WordPress is great, no doubt about that. But it’s search functionality is certainly worth improving, or to put it differently — depending on the use case, it requires heavy customization. Example: You want to show search results of products, but you want to decide which products show up first – maybe because there are older […]

Converting Japanese alphabets (Katakana & Hiragana) into Latin script

For a personal project, I needed to play around with Japanese alphabets (Hiragana and Katakana, that is). The project involved several simple tasks such as converting words written in Katakana or Hiragana to latin letters, finding strings written in Hiragana or Katakana and the conversion of voiced sounds into clear sounds. All solutions for these […]

Connect Filemaker with MySQL database using ODBC

Task: To use a remote MySQL database on FileMaker The setup: Client Side: —————- • FileMaker 12 Pro (though older versions can do this to) • Mac OS Mountain Lion 10.7.5 Server Side: —————- Linux (Cent OS 6) – though this shouldn’t matter MySQL 5.1.69 (this matters) Server hosted on Amazon The steps: 1. Preparing the […]

HTML comments and CDN

The functionality of HTML comments is self-explanatory: Comments should carry <!– comments  –>,i.e. contents that should be hidden from visitors (though this contents should of course not contain any type of sensitive information since it can be accessed very easily by looking at the source code) OR contents you’d like to hide temporarily. The latter, […]

Move mysql data directory to new location

In theory, it’s very easy: In linux distributions, you first stop mysql: service mysqld stop Then, copy the entire data to the new location. Use -rv to make sure permissions etc. are copied as well: cp -rv /var/lib/mysql /home Next, make user mysql the owner: chown -R mysql:mysql /home/mysql Next, open the config file /etc/my.cnf […]

Speeding up app search on iTunes Connect

We have some 100 apps in the iTunes store, and sometimes we run campaigns, making a couple of apps cheaper then usual, but only for a limited period of time. It would be nice if it was possible to batch-update metadata like price tier and campaign period information based on the AppID – but that’s wishful […]

Multiple SSL-secured domains on one IP

(partially taken from this manual: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 yum install gcc zlib-devel yum install mod_perl-devel wget gunzip < openssl-1.0.0g.tar.gz | tar xvf – cd openssl-1.0.0g ./config –prefix=/usr/local2 –openssldir=/usr/local2/openssl enable-tlsext shared make make install cd .. wget […]

Import b2evolution blog to wordpress

A few months ago I decided that it’s time to say goodbye to b2evolution. I liked the platform, and I’ve been using it for almost 5 years, but development seemed to have stalled, and while I compensated the stillstand for a while by developing my own tools, I grew tired of the fact that everything […]

Custom Function for Filemaker: Find Matches in 2 value lists

In a Filemaker database, I had to come up with a quick way to find out which values in array myitems also exist in array list1 and array list2. For this, I created the following function: _FindMatchesInTwoValueLists(list1,list2,start,myitems) This is the function – as you can see, it’s recursive. The variable “start” is usually 0 when […]