Reviews open!

I’ve been active populating the reviews category in the blog. I finalised the reviews section for the travel tips on Sunday, and it required some data. In the future, these reviews will appear in more relaxed pace.

Check the reviews out on the reviews main page.

As technical note, the implementation of the reviews page was not very easy or comfortable project. The metadata handling in WordPress is mediocre as its best; I had to use most of my SQL skills to create speedy queries that would return the required data in one bunch, in correct order and without duplicates. Sometimes this caused to make query that takes data twice from the same table and then joins this with third table. Fortunately, these queries are far and between.

I can explain more about the system, if somebody is willing to hear.

The next task is most probably either porting/reimplementing an Amazon storefront from another site, or making some more changes to Shortstat — I have a big list of these in my head. Any preferences?