June and July 2014

As usual, I had quite a lot of stuff going on. First of all, I was working on PHP framework for QetriX. I got it working (and I'm quite satisfied with it), but it would take a lot of effort to make it done completely.

Then I learned to use location in Objective-C, especially in background. When I was about to finish, Apple announced Swift, so I created a few small apps in it, but unfortunately from the beta Xcode it's not allowed to publish them to the Store yet.

One of the apps was a database of address points in the Czech Republic. Because I needed various kinds of data, I "accidentaly" found a new source of such data for QetriX. I started just with EU (NUTS and LAU areas), but expanded to the US as well. Instead of importing from TSV right into QetriX, this time I imported it from source CSV to custom table. I hope I would be able to see the data better (because of SQL JOINs and such).

For the mobile app of CZ Address Points I created a QetriX based website. Because it involved some CSS, I also updated reference pages for grid and "friendly" colors - consisting only from pairs of 0, 3, 6, 9, C and F hex numbers.

QetriX Friendly Colors

QetriX Grid

Because I had to prepare DB and manage Types, I also made progress in QetriX Apmin, analogy to Adminer - single PHP file for complete management (of QetriX apps).