lukator's blog

...a free, secure and useful platform which can be leveraged.

Full stop.

Working on the performance issues mentioned a few days ago. First of all, we reduced the overall table size by splitting one big table into smaller pieces. Roughly said, we now have now tables for North America, Europe, Asia, South America, Africa and the Pacific/Australia.

Lukator uses MySQL. For some reasons we decided to insert lots of data into a table. Around 3.8 Mio entries. The table has proper indices on the fields we want to search. But still, a search for a specific GEO entry takes too long because so many rows fits the conditions even if the final result counts only a few rows. This means we have to find a solution and speed up the query. The current approach is to split the table into smaller pieces and to put a switch statement in front of the query. We want to fix this issue ASAP and continue afterwards with the open point shown in the status view.

Location

After quite a while, the complete site was updated and redesigned. the underlaying infrastructure was replaced to be up-to-date. Surprise: the API is documented and available and a whoever is interested can see the status. We will now start a test phase and continue the development.

Location

There is one issue when posting offline blogs. The origin date/time when the blog was written should be used and not the date/time when the blog is stored on the server.

Location

the lukator mobile client supports offline geo blogging. This is extremely helpful to if you want to avoid roaming costs. All information are stored and the information can be posted whenever a (cheap) connection is available.

Location

More and more devices will have integrated GPS support. But there are still many users using a web browser or a "normal" mobile client. We are thinking how we can enable users to be part of the game even - regardless which client they are using.

Location

Why should someone combine text with Geo information? Because than the information becomes a clear context. Other users can search not only for the content, but also for things nearby. And for the user a blog with Geo information and a time can be used as a personal diary. I would like to travel back in time to explore what I have done in the past - and where I have been.